Exchange Rates

Exchange rates as far back as 1971 between the USA and 23 countries

@kaggle.federalreserve_exchange_rates

Table List

1 table(1.01 MB)

Exchange Rates

@kaggle.federalreserve_exchange_rates.exchange_rates

1.01 MB
12175 rows
27 columns

series_description Series Description	spot_exchange_rate_euro_area SPOT EXCHANGE RATE - EURO AREA	united_kingdom_spot_exchange_rate_us_pound_1_rxi_n_b_uk UNITED KINGDOM -- SPOT EXCHANGE RATE, US$/POUND (1/RXI N.B.UK)	spot_exchange_rate_brazil SPOT EXCHANGE RATE - BRAZIL	china_spot_exchange_rate_yuan_us_p_r CHINA -- SPOT EXCHANGE RATE, YUAN/US$ P.R.	denmark_spot_exchange_rate_kroner_us DENMARK -- SPOT EXCHANGE RATE, KRONER/US$	india_spot_exchange_rate_rupees_us INDIA -- SPOT EXCHANGE RATE, RUPEES/US$	japan_spot_exchange_rate_yen_us JAPAN -- SPOT EXCHANGE RATE, YEN/US$	korea_spot_exchange_rate_won_us KOREA -- SPOT EXCHANGE RATE, WON/US$	malaysia_spot_exchange_rate_ringgit_us MALAYSIA -- SPOT EXCHANGE RATE, RINGGIT/US$	mexico_spot_exchange_rate_pesos_us MEXICO -- SPOT EXCHANGE RATE, PESOS/US$	norway_spot_exchange_rate_kroner_us NORWAY -- SPOT EXCHANGE RATE, KRONER/US$	sweden_spot_exchange_rate_kronor_us SWEDEN -- SPOT EXCHANGE RATE, KRONOR/US$	south_africa_spot_exchange_rate_rand_us SOUTH AFRICA -- SPOT EXCHANGE RATE, RAND/$US	singapore_spot_exchange_rate_singapore_us SINGAPORE -- SPOT EXCHANGE RATE, SINGAPORE $/US$	switzerland_spot_exchange_rate_francs_us SWITZERLAND -- SPOT EXCHANGE RATE, FRANCS/US$	taiwan_spot_exchange_rate_nt_us TAIWAN -- SPOT EXCHANGE RATE, NT$/US$	thailand_spot_exchange_rate_baht_us THAILAND -- SPOT EXCHANGE RATE, BAHT/US$	spot_exchange_rate_venezuela SPOT EXCHANGE RATE - VENEZUELA	nominal_broad_dollar_index Nominal Broad Dollar Index	nominal_major_currencies_dollar_index Nominal Major Currencies Dollar Index	nominal_other_important_trading_partners_dollar_index Nominal Other Important Trading Partners Dollar Index	australia_spot_exchange_rate_us_au_reciprocal_of_rxi_n_b_al 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 NEW ZEALAND -- SPOT EXCHANGE RATE, US$/NZ$ RECIPROCAL OF RXI N.B.NZ	canada_spot_exchange_rate_canadian_us CANADA -- SPOT EXCHANGE RATE, CANADIAN $/US$	hong_kong_spot_exchange_rate_hk_us HONG KONG -- SPOT EXCHANGE RATE, HK$/US$	sri_lanka_spot_exchange_rate_rupees_us SRI LANKA -- SPOT EXCHANGE RATE, RUPEES/US$
Unit:	Currency:_Per_EUR	Currency:_Per_GBP	Currency:_Per_USD	Currency:_Per_USD	Currency:_Per_USD	Currency:_Per_USD	Currency:_Per_USD	Currency:_Per_USD	Currency:_Per_USD	Currency:_Per_USD	Currency:_Per_USD	Currency:_Per_USD	Currency:_Per_USD	Currency:_Per_USD	Currency:_Per_USD	Currency:_Per_USD	Currency:_Per_USD	Currency:_Per_USD	Index:_1973_Mar_100	Index:_1973_Mar_100	Index:_1997_Jan_100	Currency:_Per_AUD	Currency:_Per_NZD	Currency:_Per_USD	Currency:_Per_USD	Currency:_Per_USD
Multiplier:	1	0.00999999978	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
Currency:	USD	USD	BRL	CNY	DKK	INR	JPY	KRW	MYR	MXN	NOK	SEK	ZAR	SGD	CHF	TWD	THB	VEB	nan	nan	nan	USD	USD	CAD	HKD	LKR
Unique Identifier:	H10/H10/RXI$US_N.B.EU	H10/H10/RXI$US_N.B.UK	H10/H10/RXI_N.B.BZ	H10/H10/RXI_N.B.CH	H10/H10/RXI_N.B.DN	H10/H10/RXI_N.B.IN	H10/H10/RXI_N.B.JA	H10/H10/RXI_N.B.KO	H10/H10/RXI_N.B.MA	H10/H10/RXI_N.B.MX	H10/H10/RXI_N.B.NO	H10/H10/RXI_N.B.SD	H10/H10/RXI_N.B.SF	H10/H10/RXI_N.B.SI	H10/H10/RXI_N.B.SZ	H10/H10/RXI_N.B.TA	H10/H10/RXI_N.B.TH	H10/H10/RXI_N.B.VE	H10/H10/JRXWTFB_N.B	H10/H10/JRXWTFN_N.B	H10/H10/JRXWTFO_N.B	H10/H10/RXI$US_N.B.AL	H10/H10/RXI$US_N.B.NZ	H10/H10/RXI_N.B.CA	H10/H10/RXI_N.B.HK	H10/H10/RXI_N.B.SL
Time Period	RXI$US_N.B.EU	RXI$US_N.B.UK	RXI_N.B.BZ	RXI_N.B.CH	RXI_N.B.DN	RXI_N.B.IN	RXI_N.B.JA	RXI_N.B.KO	RXI_N.B.MA	RXI_N.B.MX	RXI_N.B.NO	RXI_N.B.SD	RXI_N.B.SF	RXI_N.B.SI	RXI_N.B.SZ	RXI_N.B.TA	RXI_N.B.TH	RXI_N.B.VE	JRXWTFB_N.B	JRXWTFN_N.B	JRXWTFO_N.B	RXI$US_N.B.AL	RXI$US_N.B.NZ	RXI_N.B.CA	RXI_N.B.HK	RXI_N.B.SL
1971-01-04	nan	2.3938	nan	nan	7.4850	nan	357.7300	nan	3.0867	nan	7.1359	5.1643	nan	nan	4.3180	nan	nan	nan	nan	nan	nan	1.1127	1.1138	1.0109	nan	nan
1971-01-05	nan	2.3949	nan	nan	7.4872	nan	357.8100	nan	3.0861	nan	7.1422	5.1628	nan	nan	4.3117	nan	nan	nan	nan	nan	nan	1.1132	1.1143	1.0102	nan	nan
1971-01-06	nan	2.3967	nan	nan	7.4839	nan	357.8600	nan	3.0845	nan	7.1367	5.1614	nan	nan	4.3113	nan	nan	nan	nan	nan	nan	1.1140	1.1151	1.0106	nan	nan
1971-01-07	nan	2.3963	nan	nan	7.4850	nan	357.8700	nan	3.0850	nan	7.1386	5.1649	nan	nan	4.3103	nan	nan	nan	nan	nan	nan	1.1138	1.1150	1.0148	nan	nan
1971-01-08	nan	2.3972	nan	nan	7.4850	nan	357.8200	nan	3.0845	nan	7.1382	5.1631	nan	nan	4.3109	nan	nan	nan	nan	nan	nan	1.1124	1.1154	1.0154	nan	nan


CREATE TABLE exchange_rates (
  "series_description" VARCHAR,
  "spot_exchange_rate_euro_area" VARCHAR,
  "united_kingdom_spot_exchange_rate_us_pound_1_rxi_n_b_uk" VARCHAR,
  "spot_exchange_rate_brazil" VARCHAR,
  "china_spot_exchange_rate_yuan_us_p_r" VARCHAR,
  "denmark_spot_exchange_rate_kroner_us" VARCHAR,
  "india_spot_exchange_rate_rupees_us" VARCHAR,
  "japan_spot_exchange_rate_yen_us" VARCHAR,
  "korea_spot_exchange_rate_won_us" VARCHAR,
  "malaysia_spot_exchange_rate_ringgit_us" VARCHAR,
  "mexico_spot_exchange_rate_pesos_us" VARCHAR,
  "norway_spot_exchange_rate_kroner_us" VARCHAR,
  "sweden_spot_exchange_rate_kronor_us" VARCHAR,
  "south_africa_spot_exchange_rate_rand_us" VARCHAR,
  "singapore_spot_exchange_rate_singapore_us" VARCHAR,
  "switzerland_spot_exchange_rate_francs_us" VARCHAR,
  "taiwan_spot_exchange_rate_nt_us" VARCHAR,
  "thailand_spot_exchange_rate_baht_us" VARCHAR,
  "spot_exchange_rate_venezuela" VARCHAR,
  "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,
  "new_zealand_spot_exchange_rate_us_nz_reciprocal_of_rxi_n_b_nz" VARCHAR,
  "canada_spot_exchange_rate_canadian_us" VARCHAR,
  "hong_kong_spot_exchange_rate_hk_us" VARCHAR,
  "sri_lanka_spot_exchange_rate_rupees_us" VARCHAR
);