Name: Exchange Rates
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Exchange Rates

The Federal Reserve's H.10 statistical release provides data on exchange rates between the US dollar, 23 other currencies, and three benchmark indexes. The data extend back to 1971 for several of these.

Please note that the csv has six header rows. The first contains the

Acknowledgements

This dataset was provided by the US Federal Reserve. If you need the current version, you can find their weekly updates here.

Inspiration

Venezuela is both unusually dependent on oil revenues and experiencing unusual degrees of political upheaval. Can you determine which movements in their currency were driven by changes in the oil price and which were driven by political events?

Tables

Exchange Rates

@kaggle.federalreserve_exchange_rates.exchange_rates

1.06 MB
12,175 rows
27 columns

CREATE TABLE exchange_rates (
  "series_description" VARCHAR,
  "spot_exchange_rate_euro_area" VARCHAR  -- SPOT EXCHANGE RATE - EURO AREA,
  "united_kingdom_spot_exchange_rate_us_pound_1_rxi_n_b_uk" VARCHAR  -- UNITED KINGDOM -- SPOT EXCHANGE RATE, US$/POUND (1/RXI N.B.UK),
  "spot_exchange_rate_brazil" VARCHAR  -- SPOT EXCHANGE RATE - BRAZIL,
  "china_spot_exchange_rate_yuan_us_p_r" VARCHAR  -- CHINA -- SPOT EXCHANGE RATE, YUAN/US$ P.R.,
  "denmark_spot_exchange_rate_kroner_us" VARCHAR  -- DENMARK -- SPOT EXCHANGE RATE, KRONER/US$,
  "india_spot_exchange_rate_rupees_us" VARCHAR  -- INDIA -- SPOT EXCHANGE RATE, RUPEES/US$,
  "japan_spot_exchange_rate_yen_us" VARCHAR  -- JAPAN -- SPOT EXCHANGE RATE, YEN/US$,
  "korea_spot_exchange_rate_won_us" VARCHAR  -- KOREA -- SPOT EXCHANGE RATE, WON/US$,
  "malaysia_spot_exchange_rate_ringgit_us" VARCHAR  -- MALAYSIA -- SPOT EXCHANGE RATE, RINGGIT/US$,
  "mexico_spot_exchange_rate_pesos_us" VARCHAR  -- MEXICO -- SPOT EXCHANGE RATE, PESOS/US$,
  "norway_spot_exchange_rate_kroner_us" VARCHAR  -- NORWAY -- SPOT EXCHANGE RATE, KRONER/US$,
  "sweden_spot_exchange_rate_kronor_us" VARCHAR  -- SWEDEN -- SPOT EXCHANGE RATE, KRONOR/US$,
  "south_africa_spot_exchange_rate_rand_us" VARCHAR  -- SOUTH AFRICA -- SPOT EXCHANGE RATE, RAND/$US,
  "singapore_spot_exchange_rate_singapore_us" VARCHAR  -- SINGAPORE -- SPOT EXCHANGE RATE, SINGAPORE $/US$,
  "switzerland_spot_exchange_rate_francs_us" VARCHAR  -- SWITZERLAND -- SPOT EXCHANGE RATE, FRANCS/US$,
  "taiwan_spot_exchange_rate_nt_us" VARCHAR  -- TAIWAN -- SPOT EXCHANGE RATE, NT$/US$,
  "thailand_spot_exchange_rate_baht_us" VARCHAR  -- THAILAND -- SPOT EXCHANGE RATE, BAHT/US$,
  "spot_exchange_rate_venezuela" VARCHAR  -- SPOT EXCHANGE RATE - VENEZUELA,
  "nominal_broad_dollar_index" VARCHAR,
  "nominal_major_currencies_dollar_index" VARCHAR,
  "nominal_other_important_trading_partners_dollar_index" VARCHAR,
  "australia_spot_exchange_rate_us_au_reciprocal_of_rxi_n_b_al" VARCHAR  -- AUSTRALIA -- SPOT EXCHANGE RATE US$/AU$ (RECIPROCAL OF RXI N.B.AL),
  "new_zealand_spot_exchange_rate_us_nz_reciprocal_of_rxi_n_b_nz" VARCHAR  -- NEW ZEALAND -- SPOT EXCHANGE RATE, US$/NZ$ RECIPROCAL OF RXI N.B.NZ,
  "canada_spot_exchange_rate_canadian_us" VARCHAR  -- CANADA -- SPOT EXCHANGE RATE, CANADIAN $/US$,
  "hong_kong_spot_exchange_rate_hk_us" VARCHAR  -- HONG KONG -- SPOT EXCHANGE RATE, HK$/US$,
  "sri_lanka_spot_exchange_rate_rupees_us" VARCHAR  -- SRI LANKA -- SPOT EXCHANGE RATE, RUPEES/US$
);