Name: Gold Historical Datasets
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Gold Historical Datasets

Content

This contains data files of gold historical data (USD).

Date : Date of observation
Price: The official price of the given day, month, or year
Open : Opening price on the given day, month, or year
High : Highest price on the given day, month, or year
Low : Lowest price on the given day, month, or year
Volume : Volume of transactions on the given day, month, or year
Change %: Percent change of the previous and current (day, month, or year) price.

Tables

Gold Daily

@kaggle.nward7_gold_historical_datasets.gold_daily

210.1 kB
6,886 rows
7 columns

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

Gold Monthly

@kaggle.nward7_gold_historical_datasets.gold_monthly

24.95 kB
515 rows
7 columns

CREATE TABLE gold_monthly (
  "date" VARCHAR,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" VARCHAR  -- Vol.,
  "change" DOUBLE  -- Change %
);

Gold Yearly

@kaggle.nward7_gold_historical_datasets.gold_yearly

8.02 kB
53 rows
7 columns

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  -- Annual % Change
);