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)
);

Example Query

SELECT
    time_period_start,
    time_period_end,
    rate_open,
    rate_high,
    rate_low,
    rate_close,
ROUND(((rate_close - rate_open) / rate_open) * 100, 2) as price_change_percent
FROM EXCHANGERATES
LIMIT 100;