Dataset: Daily Gold Price (1996-2023)

About this Dataset

Daily Gold Price (1996-2023)

Context

Gold is a highly liquid asset, which is no one’s liability, carries no credit risk, and is scarce, historically preserving its value over time. It also benefits from diverse sources of demand: as an investment, a reserve asset, jewellery, and a technology component. Since 1971, gold’s return has been similar to equities and outperformed bonds. In the last 20 years, gold outperformed most major asset classes and it’s global investment demand increased by an average of 15% per year. Through its dual nature as a consumer good and investment, gold has historically preserved its value. Unlike fiat currencies, gold can’t be printed, only mined — this explains in good part why it has consistently outperformed all major fiat currencies.

Content

Date: The date of the trading day.
Open: The opening price of the gold share on that day.
High: The highest price the gold share reached during the trading day.
Low: The lowest price the gold share reached during the trading day.
Close: The closing price of the gold share on that day.
WAP: Weighted Average Price, which is the average price at which all trades of the stock or asset were executed during the trading day.
WAP = (Total Cost of Purchases / Total Quantity Purchased)
No. of Shares: The total number of shares traded on that day.
No. of Trades: The total number of trades executed on that day.
Total Turnover: The total value of all trades executed on that day.
Deliverable Quantity: The total number of shares that were actually delivered to buyers on that day.
% Deli. Qty to Traded Qty: The percentage of the total traded quantity of shares that were actually delivered to buyers on that day.
Spread H-L: The difference between the highest and lowest prices of the gold share on that day.
Spread C-O: The difference between the closing and opening prices of the gold share on that day.

Tables

Deccan Gold Mines Ltd Eod Price 2

@kaggle.ritwikb3_daily_gold_price_1996_2023_time_series.deccan_gold_mines_ltd_eod_price_2

271.59 KB
4846 rows
13 columns


CREATE TABLE deccan_gold_mines_ltd_eod_price_2 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" DOUBLE,
  "no_of_trades" DOUBLE,
  "total_turnover" DOUBLE,
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE,
  "spread_h_l" DOUBLE,
  "spread_c_o" DOUBLE
);