Dataset: Foreign Exchange Rates (daily Updates)

About this Dataset

Foreign Exchange Rates (daily Updates)

This dataset contains daily FX rates for the major currencies provided by Yahoo finance; the naming convention should be self-explanatory, for convenience the codes of individual currencies:

USD: US dollar
EUR: Euro
JPY: Japanese yen
GBP: British pound
AUD: Australian dollar
NZD: New Zealand dollar
CAD: Canadian dollar
SEK: Swedish krona
CHF: Swiss franc
HUF: Hungarian forint
CNY: Chinese yuan (renminbi)
HKD: Hong Kong dollar
SGD: Singapore dollar
INR: Indian rupee
MXN: Mexican peso
PHP: Philippine peso
THB: Thai baht
MYR: Malaysian ringgit
ZAR: South African rand
RUB: Russian ruble

Note from KB2: Please leave an upvote if you download the dataset:-)

Tables

Fx Data

@kaggle.konradb_foreign_exchange_rates_daily_updates.fx_data

3.47 MB
4937 rows
121 columns


CREATE TABLE fx_data (
  "date" VARCHAR,
  "eurusd_open" DOUBLE,
  "eurusd_high" DOUBLE,
  "eurusd_low" DOUBLE,
  "eurusd_close" DOUBLE,
  "eurusd_adj_close" DOUBLE,
  "usdjpy_open" DOUBLE,
  "usdjpy_high" DOUBLE,
  "usdjpy_low" DOUBLE,
  "usdjpy_close" DOUBLE,
  "usdjpy_adj_close" DOUBLE,
  "gbpusd_open" DOUBLE,
  "gbpusd_high" DOUBLE,
  "gbpusd_low" DOUBLE,
  "gbpusd_close" DOUBLE,
  "gbpusd_adj_close" DOUBLE,
  "audusd_open" DOUBLE,
  "audusd_high" DOUBLE,
  "audusd_low" DOUBLE,
  "audusd_close" DOUBLE,
  "audusd_adj_close" DOUBLE,
  "nzdusd_open" DOUBLE,
  "nzdusd_high" DOUBLE,
  "nzdusd_low" DOUBLE,
  "nzdusd_close" DOUBLE,
  "nzdusd_adj_close" DOUBLE,
  "eurjpy_open_x" DOUBLE,
  "eurjpy_high_x" DOUBLE,
  "eurjpy_low_x" DOUBLE,
  "eurjpy_close_x" DOUBLE,
  "eurjpy_adj_close_x" DOUBLE,
  "gbpjpy_open" DOUBLE,
  "gbpjpy_high" DOUBLE,
  "gbpjpy_low" DOUBLE,
  "gbpjpy_close" DOUBLE,
  "gbpjpy_adj_close" DOUBLE,
  "eurgbp_open" DOUBLE,
  "eurgbp_high" DOUBLE,
  "eurgbp_low" DOUBLE,
  "eurgbp_close" DOUBLE,
  "eurgbp_adj_close" DOUBLE,
  "eurcad_open" DOUBLE,
  "eurcad_high" DOUBLE,
  "eurcad_low" DOUBLE,
  "eurcad_close" DOUBLE,
  "eurcad_adj_close" DOUBLE,
  "eursek_open" DOUBLE,
  "eursek_high" DOUBLE,
  "eursek_low" DOUBLE,
  "eursek_close" DOUBLE,
  "eursek_adj_close" DOUBLE,
  "eurchf_open" DOUBLE,
  "eurchf_high" DOUBLE,
  "eurchf_low" DOUBLE,
  "eurchf_close" DOUBLE,
  "eurchf_adj_close" DOUBLE,
  "eurhuf_open" DOUBLE,
  "eurhuf_high" DOUBLE,
  "eurhuf_low" DOUBLE,
  "eurhuf_close" DOUBLE,
  "eurhuf_adj_close" DOUBLE,
  "eurjpy_open_y" DOUBLE,
  "eurjpy_high_y" DOUBLE,
  "eurjpy_low_y" DOUBLE,
  "eurjpy_close_y" DOUBLE,
  "eurjpy_adj_close_y" DOUBLE,
  "usdcny_open" DOUBLE,
  "usdcny_high" DOUBLE,
  "usdcny_low" DOUBLE,
  "usdcny_close" DOUBLE,
  "usdcny_adj_close" DOUBLE,
  "usdhkd_open" DOUBLE,
  "usdhkd_high" DOUBLE,
  "usdhkd_low" DOUBLE,
  "usdhkd_close" DOUBLE,
  "usdhkd_adj_close" DOUBLE,
  "usdsgd_open" DOUBLE,
  "usdsgd_high" DOUBLE,
  "usdsgd_low" DOUBLE,
  "usdsgd_close" DOUBLE,
  "usdsgd_adj_close" DOUBLE,
  "usdinr_open" DOUBLE,
  "usdinr_high" DOUBLE,
  "usdinr_low" DOUBLE,
  "usdinr_close" DOUBLE,
  "usdinr_adj_close" DOUBLE,
  "usdmxn_open" DOUBLE,
  "usdmxn_high" DOUBLE,
  "usdmxn_low" DOUBLE,
  "usdmxn_close" DOUBLE,
  "usdmxn_adj_close" DOUBLE,
  "usdphp_open" DOUBLE,
  "usdphp_high" DOUBLE,
  "usdphp_low" DOUBLE,
  "usdphp_close" DOUBLE,
  "usdphp_adj_close" DOUBLE,
  "usdidr_open" DOUBLE,
  "usdidr_high" DOUBLE,
  "usdidr_low" DOUBLE,
  "usdidr_close" DOUBLE
);