Dataset: Gold Rates (1985 - Present)

About this Dataset

Gold Rates (1985 - Present)

Context

Gold rates differ from place to place, here is the dataset which included major six countries' Gold rates. This data can also be viewed as a Time Series data.

Content

This dataset contains two csv files -
-Daily gold rates : which includes daily data of gold rates from 1st Jan 1985 to 8th September 2023
-Annual average gold rates : this file includes average annual gold rate in their national currency from 1978 to 2021
-The rates are in their national currencies and per troy ounce
-Currencies included are USD, INR, AED, EUR, GBP, CNY

Acknowledgements

This data was collected from https://www.gold.org/goldhub and then cleaned.
Banner by Unsplash

Inspiration

Things which can be done with this data:

Time series analysis and prediction
EDA and Visualization of the gold rates
Country that has highest and lowest rate in their national currency (Latest Years)

Tables

Annual Gold Rate

@kaggle.hemil26_gold_rates_1985_jan_2022.annual_gold_rate

7.54 KB
43 rows
7 columns


CREATE TABLE annual_gold_rate (
  "date" TIMESTAMP,
  "usd" DOUBLE,
  "eur" DOUBLE,
  "gbp" DOUBLE,
  "inr" DOUBLE,
  "aed" DOUBLE,
  "cny" DOUBLE
);

Daily Gold Rate

@kaggle.hemil26_gold_rates_1985_jan_2022.daily_gold_rate

428.89 KB
10114 rows
7 columns


CREATE TABLE daily_gold_rate (
  "date" TIMESTAMP,
  "usd" DOUBLE,
  "eur" DOUBLE,
  "gbp" DOUBLE,
  "inr" DOUBLE,
  "aed" DOUBLE,
  "cny" DOUBLE
);