Dataset: Foreign Exchange Rate (1994 - 2020)

About this Dataset

Foreign Exchange Rate (1994 - 2020)

Context

The currency exchange rate is a key determinants of a country's relative level of economic health. It plays an essential role in a country's level of trade, which is critical to most every free market economy in the world.

Content

This dataset starts from 3 Jan 1994 to 28 Feb 2020. This is a raw dataset, with the presence of blank values.

Acknowledgements

This dataset is obtained from International Monetary Fund (IMF) from this website. This dataset won't be possible without this website. Kudos to those that help to obtain and manage the dataset.

Tables

Exchange Rate Report

@kaggle.kianwee_foreign_exchange_rate_1994_2020.exchange_rate_report

1.08 MB
6737 rows
54 columns


CREATE TABLE exchange_rate_report (
  "date" TIMESTAMP,
  "algerian_dinar_dzd" DOUBLE,
  "australian_dollar_aud" DOUBLE,
  "austrian_schilling_ats" DOUBLE,
  "belgian_franc_bef" DOUBLE,
  "botswana_pula_bwp" DOUBLE,
  "brazilian_real_brl" DOUBLE,
  "brunei_dollar_bnd" DOUBLE,
  "canadian_dollar_cad" DOUBLE,
  "chilean_peso_clp" DOUBLE,
  "chinese_yuan_cny" DOUBLE,
  "colombian_peso_cop" DOUBLE,
  "czech_koruna_czk" DOUBLE,
  "danish_krone_dkk" DOUBLE,
  "deutsche_mark_dem" DOUBLE,
  "estonian_kroon_eek" VARCHAR,
  "euro_eur" DOUBLE,
  "finnish_markka_fim" DOUBLE,
  "french_franc_frf" DOUBLE,
  "greek_drachma_grd" DOUBLE,
  "indian_rupee_inr" DOUBLE,
  "irish_pound_iep" DOUBLE,
  "israeli_new_shekel_ils" DOUBLE,
  "italian_lira_itl" DOUBLE,
  "japanese_yen_jpy" DOUBLE,
  "korean_won_krw" DOUBLE,
  "kuwaiti_dinar_kwd" DOUBLE,
  "luxembourg_franc_luf" DOUBLE,
  "malaysian_ringgit_myr" DOUBLE,
  "maltese_lira_mtl" DOUBLE,
  "mauritian_rupee_mur" DOUBLE,
  "mexican_peso_mxn" DOUBLE,
  "netherlands_guilder_nlg" DOUBLE,
  "new_zealand_dollar_nzd" DOUBLE,
  "norwegian_krone_nok" DOUBLE,
  "omani_rial_omr" DOUBLE,
  "peruvian_sol_pen" DOUBLE,
  "philippine_peso_php" DOUBLE,
  "polish_zloty_pln" DOUBLE,
  "portuguese_escudo_pte" DOUBLE,
  "qatari_riyal_qar" DOUBLE,
  "russian_ruble_rub" DOUBLE,
  "saudi_arabian_riyal_sar" DOUBLE,
  "singapore_dollar_sgd" DOUBLE,
  "south_african_rand_zar" DOUBLE,
  "spanish_peseta_esp" DOUBLE,
  "swedish_krona_sek" DOUBLE,
  "swiss_franc_chf" DOUBLE,
  "thai_baht_thb" DOUBLE,
  "trinidadian_dollar_ttd" DOUBLE,
  "u_a_e_dirham_aed" DOUBLE,
  "u_k_pound_gbp" DOUBLE,
  "u_s_dollar_usd" DOUBLE,
  "uruguayan_peso_uyu" DOUBLE
);