FX Rates

Foreign Exchange (FOREX) 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.

As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details.

Notes

EAV Model: All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. Index tables contain all entities of a certain type. Timeseries tables contain all timeseries' dates and values that refer to an entity type. Additional tables, such as the relationships table and attributes table, are used to describe the entities and timeseries. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details.

Tables & Sources

TablesSources

FRED for historical data, ECB and BIS for daily data

Cybersyn Products

Tables above are available in the following Cybersyn data product:

Examples & 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 support@cybersyn.com for questions.

Last updated

Copyright © 2024 Cybersyn