Name: Foreign Exchange Rate (1994 - 2020)
Creator: Kaggle
License: https://www.gnu.org/licenses/gpl.html

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.14 MB
6,737 rows
54 columns

CREATE TABLE exchange_rate_report (
  "date" TIMESTAMP,
  "algerian_dinar_dzd" DOUBLE  -- Algerian Dinar (DZD),
  "australian_dollar_aud" DOUBLE  -- Australian Dollar (AUD),
  "austrian_schilling_ats" DOUBLE  -- Austrian Schilling (ATS),
  "belgian_franc_bef" DOUBLE  -- Belgian Franc (BEF),
  "botswana_pula_bwp" DOUBLE  -- Botswana Pula (BWP),
  "brazilian_real_brl" DOUBLE  -- Brazilian Real (BRL),
  "brunei_dollar_bnd" DOUBLE  -- Brunei Dollar (BND),
  "canadian_dollar_cad" DOUBLE  -- Canadian Dollar (CAD),
  "chilean_peso_clp" DOUBLE  -- Chilean Peso (CLP),
  "chinese_yuan_cny" DOUBLE  -- Chinese Yuan (CNY),
  "colombian_peso_cop" DOUBLE  -- Colombian Peso (COP),
  "czech_koruna_czk" DOUBLE  -- Czech Koruna (CZK),
  "danish_krone_dkk" DOUBLE  -- Danish Krone (DKK),
  "deutsche_mark_dem" DOUBLE  -- Deutsche Mark (DEM),
  "estonian_kroon_eek" VARCHAR  -- Estonian Kroon (EEK),
  "euro_eur" DOUBLE  -- Euro (EUR),
  "finnish_markka_fim" DOUBLE  -- Finnish Markka (FIM),
  "french_franc_frf" DOUBLE  -- French Franc (FRF),
  "greek_drachma_grd" DOUBLE  -- Greek Drachma (GRD),
  "indian_rupee_inr" DOUBLE  -- Indian Rupee (INR),
  "irish_pound_iep" DOUBLE  -- Irish Pound (IEP),
  "israeli_new_shekel_ils" DOUBLE  -- Israeli New Shekel (ILS),
  "italian_lira_itl" DOUBLE  -- Italian Lira (ITL),
  "japanese_yen_jpy" DOUBLE  -- Japanese Yen (JPY),
  "korean_won_krw" DOUBLE  -- Korean Won (KRW),
  "kuwaiti_dinar_kwd" DOUBLE  -- Kuwaiti Dinar (KWD),
  "luxembourg_franc_luf" DOUBLE  -- Luxembourg Franc (LUF),
  "malaysian_ringgit_myr" DOUBLE  -- Malaysian Ringgit (MYR),
  "maltese_lira_mtl" DOUBLE  -- Maltese Lira (MTL),
  "mauritian_rupee_mur" DOUBLE  -- Mauritian Rupee (MUR),
  "mexican_peso_mxn" DOUBLE  -- Mexican Peso (MXN),
  "netherlands_guilder_nlg" DOUBLE  -- Netherlands Guilder (NLG),
  "new_zealand_dollar_nzd" DOUBLE  -- New Zealand Dollar (NZD),
  "norwegian_krone_nok" DOUBLE  -- Norwegian Krone (NOK),
  "omani_rial_omr" DOUBLE  -- Omani Rial (OMR),
  "peruvian_sol_pen" DOUBLE  -- Peruvian Sol (PEN),
  "philippine_peso_php" DOUBLE  -- Philippine Peso (PHP),
  "polish_zloty_pln" DOUBLE  -- Polish Zloty (PLN),
  "portuguese_escudo_pte" DOUBLE  -- Portuguese Escudo (PTE),
  "qatari_riyal_qar" DOUBLE  -- Qatari Riyal (QAR),
  "russian_ruble_rub" DOUBLE  -- Russian Ruble (RUB),
  "saudi_arabian_riyal_sar" DOUBLE  -- Saudi Arabian Riyal (SAR),
  "singapore_dollar_sgd" DOUBLE  -- Singapore Dollar (SGD),
  "south_african_rand_zar" DOUBLE  -- South African Rand (ZAR),
  "spanish_peseta_esp" DOUBLE  -- Spanish Peseta (ESP),
  "swedish_krona_sek" DOUBLE  -- Swedish Krona (SEK),
  "swiss_franc_chf" DOUBLE  -- Swiss Franc (CHF),
  "thai_baht_thb" DOUBLE  -- Thai Baht (THB),
  "trinidadian_dollar_ttd" DOUBLE  -- Trinidadian Dollar (TTD),
  "u_a_e_dirham_aed" DOUBLE  -- U.A.E. Dirham (AED),
  "u_k_pound_gbp" DOUBLE  -- U.K. Pound (GBP),
  "u_s_dollar_usd" DOUBLE  -- U.S. Dollar (USD),
  "uruguayan_peso_uyu" DOUBLE  -- Uruguayan Peso (UYU)
);