Overview

The Daily Exchange Rate dataset provides historical currency conversion rates used to standardize financial values across datasets. It allows metrics such as revenue, price, or sales stored in local currencies to be converted into USD or any other target currency, which is the reference currency used across most DataHawk reporting.

The dataset contains one exchange rate per currency per day since January 1, 2016.

Data source

Exchange rates are sourced from https://exchangeratesapi.io/, a financial data API providing daily foreign exchange rates.

DataHawk ingests the data and stores it in a referential table where:

Location

Database: REFERENTIAL

Table: REFERENTIAL_CURRENCY_RATE

This table serves as the reference dataset for currency conversions across the DataHawk warehouse.

Table schema

Column Description
DATE_DAY Date of the exchange rate.
CURRENCY 3-letter currency code (EUR, GBP, CAD, etc.).
BASE Base currency used for the rate. Always USD.
RATE Exchange rate relative to USD.

How it is typically used

This table is usually joined on date and currency to convert local values into USD.

Example pattern:

SELECT
    revenue_local / rate AS revenue_usd
FROM some_table t
JOIN referential.referential_currency_rate r
  ON t.currency = r.currency
 AND t.date_day = r.date_day