FX Rates

Overview

Foreign exchange (also known as FX or FOREX) rates are the rates at which one currency can be exchanged for another. These rates fluctuate based on various factors including economic indicators, market sentiment, political events, and global financial stability. Foreign exchange rates are crucial for international trade and finance, as they determine how much of one currency is needed to buy a unit of another currency. These rates can be floating, changing continuously based on market forces, or they might be pegged (fixed) to another major currency or basket of currencies, managed by a country's central bank.

Key Attributes

Geographic Coverage	Global; over 130 currency exchange rates
Entity Level	Base currency; Quote currency
Time Granularity	Daily
Release Frequency	Data is released on different schedules by source: ECB: Released daily around 16:00 CET every working day, except European holidays (timing is based on the daily concertation procedure between central banks across Europe, which normally takes place around 14:10 CET) BIS: Reports daily rates on a weekly basis for the previous week. It often excludes weekends and US holidays. FRED: Provides historical data. To note, gaps in the data are due to the above data source limitations.
History	History will vary by base currency <> quote currency pair. Some rates go back as far as 1953. FX rates data is provided historically by FRED (pre-2000) and by the European Central Bank (ECB) and Bank for International Settlements (BIS) for 2000 onwards. European Central Bank (ECB) stopped reporting certain currency pairs in late 2023.

Cybersyn Products

Tables above are available in the following Cybersyn data product:

• Finance & Economics
• Cybersyn Foundations - PAID

Sample Queries

Calculate the reciprocal FX rates.

Calculate CAD/USD Exchange Rate from USD/CAD Exchange Rate.

SELECT
    quote_currency_id AS base_currency_id,
    quote_currency_name AS base_currency_name,
    base_currency_id AS quote_currency_id,
    base_currency_name AS quote_currency_name,
    date,
    1/value AS rate
FROM cybersyn.fx_rates_timeseries
WHERE 
    base_currency_id = 'USD' 
    AND quote_currency_id = 'CAD';

Calculate the cross rate.

Calculate GBP/EUR from GBP/USD Exchange Rate and USD/EUR Exchange Rate.

SELECT
    date,
    MAX(CASE WHEN variable = 'gbp_usd' THEN value END) AS gbp_usd,
    MAX(CASE WHEN variable = 'usd_eur' THEN value END) AS usd_eur,
    gbp_usd / usd_eur AS gbp_eur
FROM cybersyn.fx_rates_timeseries
WHERE 
    variable IN ('gbp_usd','usd_eur')
    AND YEAR(date) >= 2024
GROUP BY 1
HAVING gbp_eur IS NOT NULL
ORDER BY 1;

Disclaimers

The data in this product is sourced from FRED, ECB, and BIS.

Cybersyn is not endorsed by or affiliated with any of these providers. Contact snowflake-public-data@snowflake.com for questions.