Commodity Prices Dataset (2000 - 2023)

A daily time-series of commodity futures for over 20 different commodities.

@kaggle.debashish311601_commodity_prices

Table List

1 table(618.22 KB)

Commodity Futures

@kaggle.debashish311601_commodity_prices.commodity_futures

618.22 KB
6092 rows
24 columns

date Date	natural_gas NATURAL GAS	gold GOLD	wti_crude WTI CRUDE	brent_crude BRENT CRUDE	soybeans SOYBEANS	corn CORN	copper COPPER	silver SILVER	low_sulphur_gas_oil LOW SULPHUR GAS OIL	live_cattle LIVE CATTLE	soybean_oil SOYBEAN OIL	aluminium ALUMINIUM	soybean_meal SOYBEAN MEAL	zinc ZINC	uls_diesel ULS DIESEL	nickel NICKEL	wheat WHEAT	sugar SUGAR	coffee COFFEE	lean_hogs LEAN HOGS	hrw_wheat HRW WHEAT	cotton COTTON
Mon Jan 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)					456.5	200.75				69.7	15.44		146.4	1237.5		8446	247.5	6.1	116.5	55.975	274.25	51.07
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	2.176	283.7	25.55	24.39	464.25	203	0.848	5.375	213.5	69.075	15.57	1617.5	147.9	1215	67.78	8314	247.25	5.77	116.25	55.625	274	50.73
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	2.168	282.1	24.91	23.73	469.25	203	0.8565	5.21	213	68.975	15.74	1636.5	150.7	1209.25	66.55	8307	249.75	5.81	118.6	55.075	276.25	51.56
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	2.196	282.4	24.78	23.62	468	203.75	0.853	5.167	211.25	70.075	15.72	1639.75	149.1	1212	66.28	8252	248.5	5.77	116.85	55.175	275	52.08
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	2.173	282.9	24.22	23.09	471.5	207	0.854	5.195	205.25	70.875	15.9	1652	149.1	1209.25	64.75	8174	251.75	5.84	114.15	55.625	277.75	53.96
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	2.216	282.7	24.67	23.73	466.25	208.5	0.8465	5.19	196	70.775	15.71	1636.75	147.7	1196.75	64.72	8130	253.5	5.83	117.55	55.65	279.75	53.56
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	2.26	284.4	25.77	24.62	467	207.25	0.8435	5.195	201.5	70.875	15.57	1640.75	148.8	1185	66.75	8052.5	253.75	5.67	117.8	56.025	280	54.18
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	2.244	283.7	26.28	24.81	472.5	215.5	0.866	5.143	201.5	70.425	15.68	1643.5	150.9	1195.75	68.47	8191	258.75	5.45	118.95	54.8	285.75	53.72
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	2.252	285.1	26.69	24.98	481.75	220.75	0.8565	5.153	208.25	70.6	16.12	1633.75	153.8	1194	69.28	8107	263.5	5.49	118.55	54.825	290	54.75
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	2.322	284.9	28.02	25.47	485.5	219	0.8625	5.15	213.75	70.825	16.03	1653.5	155	1195.75	73.81	8125	265	5.45	112.55	56.15	293	55.12


CREATE TABLE commodity_futures (
  "date" TIMESTAMP,
  "natural_gas" DOUBLE,
  "gold" DOUBLE,
  "wti_crude" DOUBLE,
  "brent_crude" DOUBLE,
  "soybeans" DOUBLE,
  "corn" DOUBLE,
  "copper" DOUBLE,
  "silver" DOUBLE,
  "low_sulphur_gas_oil" DOUBLE,
  "live_cattle" DOUBLE,
  "soybean_oil" DOUBLE,
  "aluminium" DOUBLE,
  "soybean_meal" DOUBLE,
  "zinc" DOUBLE,
  "uls_diesel" DOUBLE,
  "nickel" DOUBLE,
  "wheat" DOUBLE,
  "sugar" DOUBLE,
  "gasoline" DOUBLE,
  "coffee" DOUBLE,
  "lean_hogs" DOUBLE,
  "hrw_wheat" DOUBLE,
  "cotton" DOUBLE
);