Dataset: Foreign Exchange Rates 2000-2019

About this Dataset

Foreign Exchange Rates 2000-2019

This dataset was generated on the Federal Reserve's Download Data Program. Some changes were made in the dataset, such as header simplifications and inversions of base currency. For example, Fed provides Australian Dollar, Euro, New Zeland Dollar and United Kingdom Pound based in their units (not in dollar). So I made a convertion for this dataset in order to view all rates based in dollar units.

Tables

Foreign Exchange Rates

@kaggle.brunotly_foreign_exchange_rates_per_dollar_20002019.foreign_exchange_rates

537.91 KB
5217 rows
24 columns


CREATE TABLE foreign_exchange_rates (
  "unnamed_0" BIGINT,
  "time_serie" TIMESTAMP,
  "australia_australian_dollar_us" VARCHAR,
  "euro_area_euro_us" VARCHAR,
  "new_zealand_new_zeland_dollar_us" VARCHAR,
  "united_kingdom_united_kingdom_pound_us" VARCHAR,
  "brazil_real_us" VARCHAR,
  "canada_canadian_dollar_us" VARCHAR,
  "china_yuan_us" VARCHAR,
  "hong_kong_hong_kong_dollar_us" VARCHAR,
  "india_indian_rupee_us" VARCHAR,
  "korea_won_us" VARCHAR,
  "mexico_mexican_peso_us" VARCHAR,
  "south_africa_rand_us" VARCHAR,
  "singapore_singapore_dollar_us" VARCHAR,
  "denmark_danish_krone_us" VARCHAR,
  "japan_yen_us" VARCHAR,
  "malaysia_ringgit_us" VARCHAR,
  "norway_norwegian_krone_us" VARCHAR,
  "sweden_krona_us" VARCHAR,
  "sri_lanka_sri_lankan_rupee_us" VARCHAR,
  "switzerland_franc_us" VARCHAR,
  "taiwan_new_taiwan_dollar_us" VARCHAR,
  "thailand_baht_us" VARCHAR
);