Federal Exchange Rates
收藏Snowflake2025-11-04 更新2025-11-05 收录
下载链接:
https://app.snowflake.com/marketplace/listing/GZTYZAPS3FL
下载链接
链接失效反馈官方服务:
资源简介:
Foreign exchange rates, commonly referred to as forex or FX rates, denote the value of one currency compared to another.<br/>
These rates are pivotal in international transactions, determining the worth of one currency in relation to another. They are subject to continuous fluctuations influenced by factors such as supply and demand dynamics, geopolitical events, economic indicators, and market sentiment.
Exchange rates are quoted in two main ways:
1. Direct Quote: This reflects the price of one unit of foreign currency in terms of the domestic currency. For instance, a EUR/USD exchange rate of 1.20 indicates that 1 Euro equals 1.20 US Dollars.
2. Indirect Quote: This represents the price of one unit of domestic currency in terms of the foreign currency. Using the same example, a USD/EUR exchange rate of 0.83 signifies that 1 US Dollar equals 0.83 Euros.
Views published:
1. VW_FORIEGN_EXCHANGE_RATES_BY_CURRENCY: View presenting currency records in column-wise format with data on open, close, high, and low values of FER price points within a trading day.
2. VW_FOREIGN_EXCHANGE_RATES: Horizontal view containing all data where exchange rates are specified for each currency field.
3. VW_G21_COUNTRY_CURRENCIES_FOREIGN_EXCHANGE_RATE: View providing records for Global 21 Country Currencies.
4. VW_G7_COUNTRY_CURRENCIES_FOREIGN_EXCHANGE_RATE: View offering records for Global 7 Country Currencies.
5. VW_TOP_FIVE_TRADABLE_CURRENCIES_FOREIGN_EXCHANGE_RATE: View presenting records for the most top 5 tradable currencies.
Cryptocurrency data
The Cryptocurrency Historical Data dataset provides detailed and granular information on cryptocurrency market trends. It includes historical trading data that helps users analyze market movements, track price patterns, and derive actionable insights. This dataset is ideal for traders, analysts, researchers, and businesses involved in cryptocurrency trading or analysis.
Key Features:
1. Covers major cryptocurrencies like Bitcoin (BTC), Ethereum (ETH), and others.
2. Includes metrics such as opening and closing prices, trading volumes, and timestamps for critical events.
3. Provides granular data points including top-tier and direct volumes for precise market analysis.
Published Views
1. CRYPTO_CURRENCY_HISTORICAL_DATA
Description: Contains detailed historical trading data for all cryptocurrencies.
Fields:
- TIMESTAMP: Timestamp of the data point
- CURRENCY: Code of the cryptocurrency (e.g., BTC)
- BASE: Base of the cryptocurrency (e.g., USD)
- OPEN: Opening price
- HIGH: Highest price
- LOW: Lowest price
- CLOSE: Closing price
- VOLUME: Trading volume <br/><br/>2. TOP_100_MARKET_CAP_CRYPTO_CURRENCY_HISTORICAL_DATA <br/>A subset view of the top 100 currencies by market capitalization, focusing on essential trading metrics.
Fields: Similar to CRYPTO_CURRENCY_HISTORICAL_DATA but limited to the top-performing assets.
提供机构:
InSights
创建时间:
2025-08-05
原始信息汇总
Federal Exchange Rates 数据集概述
数据集基本信息
- 提供商: InSights
- 价格: 免费
- 访问权限: 无限制访问
- 更新频率: 每周
- 时间覆盖范围: 2004年1月1日 - 2024年7月12日
- 地理覆盖范围: 全球
- 云区域可用性: AWS多个区域
数据集内容
外汇汇率数据
外汇汇率表示一种货币相对于另一种货币的价值,在国际交易中至关重要。
主要视图:
- VW_FORIEGN_EXCHANGE_RATES_BY_CURRENCY: 按货币列式展示交易日内开盘价、收盘价、最高价和最低价
- VW_FOREIGN_EXCHANGE_RATES: 水平视图,包含所有货币的汇率数据
- VW_G21_COUNTRY_CURRENCIES_FOREIGN_EXCHANGE_RATE: 全球21国货币记录
- VW_G7_COUNTRY_CURRENCIES_FOREIGN_EXCHANGE_RATE: 全球7国货币记录
- VW_TOP_FIVE_TRADABLE_CURRENCIES_FOREIGN_EXCHANGE_RATE: 前5大交易货币记录
加密货币数据
提供加密货币市场趋势的详细历史交易数据。
主要视图:
- CRYPTO_CURRENCY_HISTORICAL_DATA: 包含所有加密货币的详细历史交易数据
- TOP_100_MARKET_CAP_CRYPTO_CURRENCY_HISTORICAL_DATA: 按市值排名前100的加密货币子集
数据字典
加密货币历史数据字段
- TIMESTAMP: 数据点时间戳
- CURRENCY: 加密货币代码(如BTC)
- BASE: 加密货币基础货币(如USD)
- OPEN: 开盘价
- HIGH: 最高价
- LOW: 最低价
- CLOSE: 收盘价
- VOLUME: 交易量
外汇汇率字段示例
- AFGHAN_AFGHANI: 阿富汗尼汇率
- ALBANIAN_LEK: 阿尔巴尼亚列克汇率
- ALGERIAN_DINAR: 阿尔及利亚第纳尔汇率
- ARGENTINE_PESO: 阿根廷比索汇率
- ARMENIAN_DRAM: 亚美尼亚德拉姆汇率
- AUSTRALIAN_DOLLAR: 澳元汇率
- BASE: 基础货币(美元)
业务应用场景
国际贸易趋势分析
汇率直接影响进出口商品和服务的成本和竞争力
货币转换
跨境业务中利润、费用和投资在不同货币间的转换
宏观经济政策
政府和央行监控汇率波动以实现经济稳定
财务报告
跨国公司准确报告不同货币的财务结果
使用示例
汇率分析查询
- 特定货币最低、最高和平均汇率计算
- 货币对波动率计算
- 套利机会识别
- 最强和最弱货币识别
- 货币对相关性分析
- 汇率趋势识别
加密货币分析查询
- 按收盘价获取前5大加密货币
- 市场走势分析
- 价格模式跟踪
联系方式
- 销售: snowflakesupport@cginfinity.com
- 支持: snowflakesupport@cginfinity.com



