Skip to main content

Exchange Rates Dataset

Overview​

The "EXCHANGERATES" dataset provides comprehensive information about currency exchange rates across global financial markets. It includes detailed data about currency pairs, historical rate movements, and key trading information across different timeframes and market conditions.

This dataset helps users:

  • Track currency pair relationships and their historical patterns
  • Access reliable exchange rate data across multiple time periods
  • Monitor market volatility and rate fluctuations
  • Analyze currency performance and market trends
  • Evaluate cross-currency relationships and correlations

Table Details​

Name: LISTINGS.PUBLIC.EXCHANGERATES

Schema​

CREATE OR REPLACE TABLE LISTINGS.PUBLIC.EXCHANGERATES (
    time_period_start     TIMESTAMP_NTZ(9),
    time_period_end       TIMESTAMP_NTZ(9),
    time_open             TIMESTAMP_NTZ(9),
    time_close            TIMESTAMP_NTZ(9),
    rate_open             NUMBER(38,2),
    rate_high             NUMBER(38,2),
    rate_low              NUMBER(38,2),
    rate_close            NUMBER(38,2)
);