Monthly Currency Exchange Rates

The Value of Money Across Borders

@kaggle.rlakshminarayanan_monthly_currency_exchange_rates

Table List

1 table(3.25 MB)

Monthly Currency Exchaange Rates

@kaggle.rlakshminarayanan_monthly_currency_exchange_rates.monthly_currency_exchaange_rates

3.25 MB
468948 rows
54 columns

iso3 ISO3	country Country	adm1_name Adm1 Name	adm2_name Adm2 Name	mkt_name Mkt Name	lat Lat	lon Lon	geo_id Geo Id	dates DATES	year Year	month Month	currency Currency	o_exchange_rate_unofficial O Exchange Rate Unofficial	h_exchange_rate_unofficial H Exchange Rate Unofficial	l_exchange_rate_unofficial L Exchange Rate Unofficial	c_exchange_rate_unofficial C Exchange Rate Unofficial	trust_exchange_rate_unofficial Trust Exchange Rate Unofficial	o_wage_non_qualified_labour_non_agricultural O Wage Non Qualified Labour Non Agricultural	h_wage_non_qualified_labour_non_agricultural H Wage Non Qualified Labour Non Agricultural	l_wage_non_qualified_labour_non_agricultural L Wage Non Qualified Labour Non Agricultural	c_wage_non_qualified_labour_non_agricultural C Wage Non Qualified Labour Non Agricultural	trust_wage_non_qualified_labour_non_agricultural Trust Wage Non Qualified Labour Non Agricultural	o_wage_qualified_labour O Wage Qualified Labour	h_wage_qualified_labour H Wage Qualified Labour	l_wage_qualified_labour L Wage Qualified Labour	c_wage_qualified_labour C Wage Qualified Labour	trust_wage_qualified_labour Trust Wage Qualified Labour
AFG	Afghanistan	Badakhshan	Argo	Badakhshan	37.03785	70.45621	gid_370378500704562100	Mon Jan 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	2007	1	AFN	50.26	50.71	49.81	50.26	9.5	243.62	245.07	242.38	243.65	8.3	1051.64	1064.52	1036.28	1051.41	8
AFG	Afghanistan	Badakhshan	Argo	Badakhshan	37.03785	70.45621	gid_370378500704562100	Thu Feb 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	2007	2	AFN	50.26	50.71	49.81	50.32	9.5	243.75	245.1	242.4	243.48	8.3	1050.17	1064.29	1036.05	1056.41	8
AFG	Afghanistan	Badakhshan	Argo	Badakhshan	37.03785	70.45621	gid_370378500704562100	Thu Mar 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	2007	3	AFN	50.33	50.76	49.9	50.38	9.5	243.42	244.67	242.17	243.78	8.3	1058.39	1072.28	1044.49	1057.21	8
AFG	Afghanistan	Badakhshan	Argo	Badakhshan	37.03785	70.45621	gid_370378500704562100	Sun Apr 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	2007	4	AFN	50.4	50.81	50	50.48	9.5	244.03	249.56	242.78	249.56	8.3	1057.53	1070.95	1010.84	1010.84	8
AFG	Afghanistan	Badakhshan	Argo	Badakhshan	37.03785	70.45621	gid_370378500704562100	Tue May 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	2007	5	AFN	50.51	50.9	50.12	50.51	9.5	251.87	260.71	247.95	260.71	8.3	993.39	1021.61	927.96	927.96	8
AFG	Afghanistan	Badakhshan	Argo	Badakhshan	37.03785	70.45621	gid_370378500704562100	Fri Jun 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	2007	6	AFN	50.53	50.9	50.16	50.43	9.5	264.92	271.18	258.65	266.16	8.3	897.88	934.66	858.39	858.39	8
AFG	Afghanistan	Badakhshan	Argo	Badakhshan	37.03785	70.45621	gid_370378500704562100	Sun Jul 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	2007	7	AFN	50.42	50.77	50.06	50.35	9.5	267.96	270.22	265.7	269.3	8.3	832.76	858.74	806.79	823.03	8
AFG	Afghanistan	Badakhshan	Argo	Badakhshan	37.03785	70.45621	gid_370378500704562100	Wed Aug 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	2007	8	AFN	50.32	50.66	49.99	50.55	9.5	268.97	270.67	267.28	268.96	8.3	809.34	825.04	795.16	825.04	8
AFG	Afghanistan	Badakhshan	Argo	Badakhshan	37.03785	70.45621	gid_370378500704562100	Sat Sep 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	2007	9	AFN	50.58	50.91	50.26	50.54	9.5	266.34	267.73	263.01	263.01	8.3	825.55	899.64	811.44	899.64	8
AFG	Afghanistan	Badakhshan	Argo	Badakhshan	37.03785	70.45621	gid_370378500704562100	Mon Oct 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	2007	10	AFN	50.57	50.88	50.26	50.6	9.5	258.54	263.44	256.03	263.44	8.3	931.23	977.96	884.5	897.33	8


CREATE TABLE monthly_currency_exchaange_rates (
  "iso3" VARCHAR,
  "country" VARCHAR,
  "adm1_name" VARCHAR,
  "adm2_name" VARCHAR,
  "mkt_name" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "geo_id" VARCHAR,
  "dates" TIMESTAMP,
  "year" BIGINT,
  "month" BIGINT,
  "currency" VARCHAR,
  "exchange_rate_unofficial" DOUBLE,
  "milling_cost_wheat" DOUBLE,
  "wage_non_qualified_labour" DOUBLE,
  "wage_non_qualified_labour_non_agricultural" DOUBLE,
  "wage_qualified_labour" DOUBLE,
  "water_drinking" DOUBLE,
  "o_exchange_rate_unofficial" DOUBLE,
  "h_exchange_rate_unofficial" DOUBLE,
  "l_exchange_rate_unofficial" DOUBLE,
  "c_exchange_rate_unofficial" DOUBLE,
  "inflation_exchange_rate_unofficial" DOUBLE,
  "trust_exchange_rate_unofficial" DOUBLE,
  "o_milling_cost_wheat" DOUBLE,
  "h_milling_cost_wheat" DOUBLE,
  "l_milling_cost_wheat" DOUBLE,
  "c_milling_cost_wheat" DOUBLE,
  "inflation_milling_cost_wheat" DOUBLE,
  "trust_milling_cost_wheat" DOUBLE,
  "o_wage_non_qualified_labour" DOUBLE,
  "h_wage_non_qualified_labour" DOUBLE,
  "l_wage_non_qualified_labour" DOUBLE,
  "c_wage_non_qualified_labour" DOUBLE,
  "inflation_wage_non_qualified_labour" DOUBLE,
  "trust_wage_non_qualified_labour" DOUBLE,
  "o_wage_non_qualified_labour_non_agricultural" DOUBLE,
  "h_wage_non_qualified_labour_non_agricultural" DOUBLE,
  "l_wage_non_qualified_labour_non_agricultural" DOUBLE,
  "c_wage_non_qualified_labour_non_agricultural" DOUBLE,
  "inflation_wage_non_qualified_labour_non_agricultural" DOUBLE,
  "trust_wage_non_qualified_labour_non_agricultural" DOUBLE,
  "o_wage_qualified_labour" DOUBLE,
  "h_wage_qualified_labour" DOUBLE,
  "l_wage_qualified_labour" DOUBLE,
  "c_wage_qualified_labour" DOUBLE,
  "inflation_wage_qualified_labour" DOUBLE,
  "trust_wage_qualified_labour" DOUBLE,
  "o_water_drinking" DOUBLE,
  "h_water_drinking" DOUBLE,
  "l_water_drinking" DOUBLE,
  "c_water_drinking" DOUBLE,
  "inflation_water_drinking" DOUBLE,
  "trust_water_drinking" DOUBLE
);