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 Yearly

@kaggle.nward7_gold_historical_datasets.gold_yearly

7.83 KB
53 rows
7 columns

year Year	average_closing_price Average Closing Price	year_open Year Open	year_high Year High	year_low Year Low	year_close Year Close	annual_change Annual % Change
1969	41.1	41.8	43.75	35	35.21	-0.1607
1970	35.96	35.13	39.19	34.78	37.38	0.0616
1971	40.8	37.33	43.9	37.33	43.5	0.1637
1972	58.17	43.73	70	43.73	64.7	0.4874
1973	97.12	64.99	127	64.1	112.25	0.7349
1974	158.76	114.75	197.5	114.75	187.5	0.6704
1975	160.87	185	186.25	128.75	140.25	-0.252
1976	124.8	140.35	140.35	103.05	134.55	-0.0406
1977	147.84	136.1	168.15	129.4	165.6	0.2308
1978	193.57	168.6	243.65	166.3	224.5	0.3557


CREATE TABLE gold_yearly (
  "year" BIGINT,
  "average_closing_price" DOUBLE,
  "year_open" DOUBLE,
  "year_high" DOUBLE,
  "year_low" DOUBLE,
  "year_close" DOUBLE,
  "annual_change" DOUBLE
);