Historical Data Gold Prices In XAU/USD (2004-2024)
Uncovering Gold Market Fluctuations Over 20 Years
@kaggle.zeesolver_usd_gold_detail
Uncovering Gold Market Fluctuations Over 20 Years
@kaggle.zeesolver_usd_gold_detail
The dataset is a detailed collection of XAU/USD (Gold vs. USD) price information, spanning two decades from 2004 to 2024. It’s designed to give a full picture of gold price movements, from quick changes every 5 minutes to broader shifts seen in monthly trends. Each entry tells a story, showing the highs, lows, opening, and closing prices of gold, plus the volume of trades at that time. By including data across various intervals—like 5-minute, 15-minute, 30-minute, 1-hour, 4-hour, daily, weekly, and monthly—it captures both the subtle ripples and the big waves in the market. This makes it not just numbers on a spreadsheet but a look into how gold's value has danced through global economic events, investor moods, and market shifts over these years. It's perfect for anyone who wants to dig deep into gold's journey, understand its patterns, and maybe even find clues for what might come next. The volume data adds another layer, revealing how much interest and activity there was behind each price move, making it a rich resource for traders and enthusiasts alike.
CREATE TABLE xau_15m_data_2004_to_2024_20_09 (
"date" TIMESTAMP,
"time" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE xau_1d_data_2004_to_2024_09_20 (
"date" TIMESTAMP,
"time" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE xau_1h_data_2004_to_2024_09_20 (
"date" TIMESTAMP,
"time" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE xau_1month_data_2004_to_2024_09_20 (
"date" TIMESTAMP,
"time" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE xau_1w_data_2004_to_2024_09_20 (
"date" TIMESTAMP,
"time" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE xau_30m_data_2004_to_2024_09_20 (
"date" TIMESTAMP,
"time" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE xau_4h_data_2004_to_2024_09_20 (
"date" TIMESTAMP,
"time" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE xau_5m_data_2004_to_2024_09_20 (
"date" TIMESTAMP,
"time" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);Anyone who has the link will be able to view this.