Name: Foreign Exchange Rates 2000-2019
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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

550.82 kB
5,217 rows
24 columns

CREATE TABLE foreign_exchange_rates (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "time_serie" TIMESTAMP,
  "australia_australian_dollar_us" VARCHAR  -- AUSTRALIA - AUSTRALIAN DOLLAR/US$,
  "euro_area_euro_us" VARCHAR  -- EURO AREA - EURO/US$,
  "new_zealand_new_zeland_dollar_us" VARCHAR  -- NEW ZEALAND - NEW ZELAND DOLLAR/US$,
  "united_kingdom_united_kingdom_pound_us" VARCHAR  -- UNITED KINGDOM - UNITED KINGDOM POUND/US$,
  "brazil_real_us" VARCHAR  -- BRAZIL - REAL/US$,
  "canada_canadian_dollar_us" VARCHAR  -- CANADA - CANADIAN DOLLAR/US$,
  "china_yuan_us" VARCHAR  -- CHINA - YUAN/US$,
  "hong_kong_hong_kong_dollar_us" VARCHAR  -- HONG KONG - HONG KONG DOLLAR/US$,
  "india_indian_rupee_us" VARCHAR  -- INDIA - INDIAN RUPEE/US$,
  "korea_won_us" VARCHAR  -- KOREA - WON/US$,
  "mexico_mexican_peso_us" VARCHAR  -- MEXICO - MEXICAN PESO/US$,
  "south_africa_rand_us" VARCHAR  -- SOUTH AFRICA - RAND/US$,
  "singapore_singapore_dollar_us" VARCHAR  -- SINGAPORE - SINGAPORE DOLLAR/US$,
  "denmark_danish_krone_us" VARCHAR  -- DENMARK - DANISH KRONE/US$,
  "japan_yen_us" VARCHAR  -- JAPAN - YEN/US$,
  "malaysia_ringgit_us" VARCHAR  -- MALAYSIA - RINGGIT/US$,
  "norway_norwegian_krone_us" VARCHAR  -- NORWAY - NORWEGIAN KRONE/US$,
  "sweden_krona_us" VARCHAR  -- SWEDEN - KRONA/US$,
  "sri_lanka_sri_lankan_rupee_us" VARCHAR  -- SRI LANKA - SRI LANKAN RUPEE/US$,
  "switzerland_franc_us" VARCHAR  -- SWITZERLAND - FRANC/US$,
  "taiwan_new_taiwan_dollar_us" VARCHAR  -- TAIWAN - NEW TAIWAN DOLLAR/US$,
  "thailand_baht_us" VARCHAR  -- THAILAND - BAHT/US$
);