Daily Exchange Rate Dataset

DataHawk's daily exchange rate table for cross-marketplace currency conversion; sourced from exchangeratesapi.io, USD as base, available since 2016.

DataHawk operates across multiple Amazon and Walmart marketplaces, each with its own local currency (EUR, GBP, CAD, JPY, etc.). To make cross-marketplace comparisons meaningful, DataHawk maintains a daily exchange rate table that lets you convert any financial metric into a common currency.

In practice, this means you can report revenue, profit, or pricing in USD, or in any currency you choose, regardless of the marketplace it came from. Most DataHawk dashboards handle this conversion automatically.

💡

If you're using the DataHawk dashboards, currency conversion is already handled for you. This page is primarily relevant if you're writing your own SQL queries against the DataHawk database.

Data source

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

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

USD is always the base currency
Each currency has one rate per day
Historical values are stable and do not change retroactively (safe for reproducible analysis)

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

Location

Schema: REFERENTIAL Table: REFERENTIAL_CURRENCY_RATE

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

Typical usage pattern

This table is joined on date and currency to convert local values into USD. See the Convert Currencies page for a full worked SQL example.

Basic pattern for converting local revenue to USD:

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