Gold Historical Datasets

Gold historical datasets: Daily, Monthly, and Yearly

@kaggle.nward7_gold_historical_datasets

Table List

3 tables(237.38 KB)

Gold Daily

Gold Monthly

Gold Yearly

Gold Daily

@kaggle.nward7_gold_historical_datasets.gold_daily

205.18 KB
6886 rows
7 columns

date Date	price Price	open Open	high High	low Low	vol Vol	change Change %
Tue Dec 06 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	375.8	375.6	376.5	375.1	0.99K	0.0008
Wed Dec 07 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	376.1	377	377.5	375.1	1.88K	0.0008
Thu Dec 08 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	376.6	375.3	376.7	374.8	0.48K	0.0013
Fri Dec 09 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	377	375.6	377	375.5	0.38K	0.0011
Mon Dec 12 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	377.5	376.8	377.8	376.5	0.07K	0.0013
Tue Dec 13 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	377.6	379.5	379.5	378	0.04K	0.0003
Wed Dec 14 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	378.9	379	381	379	0.05K	0.0034
Thu Dec 15 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	380.2	379.9	380.3	378.9	0.08K	0.0034
Fri Dec 16 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	378.6	380.5	380.5	379	0.04K	-0.0042
Mon Dec 19 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	379.2	379.2	379.2	379.2	0.01K	0.0016


CREATE TABLE gold_daily (
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" VARCHAR,
  "change" DOUBLE
);