Federal Exchange Rates

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.<br/>VW_G7_COUNTRY_CURRENCIES_FOREIGN_EXCHANGE_RATE: View offering records for Global 7 Country Currencies.<br/>4.VW_TOP_FIVE_TRADABLE_CURRENCIES_FOREIGN_EXCHANGE_RATE: View presenting records for the most top 5 tradable currencies.

**Cryptocurrency data:**<br/>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 

2. TOP_100_MARKET_CAP_CRYPTO_CURRENCY_HISTORICAL_DATA 

Description: 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.