Exchange Rates

Facts

Definitions

Column	Description
date	Factual reference to the date (links to Dates).
currency_pair_id	Currency pair (links to Currency Pairs, e.g. EURUSD, GBPUSD, EURCHF).
value	Fact registered.

Sample & Implementation

A list of Exchange Rates
date	currency_pair_id	value
2025-01-01	1	1.234

CREATE TABLE IF NOT EXISTS exchange_rates (
    date DATE NOT NULL,
    currency_pair_id INTEGER NOT NULL,
    value DOUBLE NOT NULL,
    FOREIGN KEY (date) REFERENCES dates(date),
    FOREIGN KEY (currency_pair_id) REFERENCES currency_pairs(id),
    PRIMARY KEY (date, currency_pair_id)
)

Data Format

Field

Type

The primary key is formed by constrainst on Dates and Currency Pairs:
PRIMARY KEY (date, currency_pair_id)

Dependencies

Dates
Currency Pairs

Facts

Definitions

Sample & Implementation

Data Format

Dependencies

On this page