Geopolitical Event Noted
Severe Natural Disasters with Geopolitical Consequences
@kaggle.sidraaazam_geopolitical_event_noted
Severe Natural Disasters with Geopolitical Consequences
@kaggle.sidraaazam_geopolitical_event_noted
What important event happened on that date.
The type of event (e.g., war, terrorism, global conflict, sanctions, economic crisis, or a major international decision).
How that event influenced global markets — especially gold and silver prices.
** Examples:
1990: Gulf War begins — gold prices surged as markets became uncertain.
2001: 9/11 Attacks — investors rushed to safe-haven assets like gold and silver.
2022: Russia–Ukraine War — precious metals rose again due to geopolitical risks.
So, “Geopolitical Event Noted” is basically a marker in the dataset showing which global event affected the market at that time.
CREATE TABLE gold_silver_geopoliticalrisk_historicaldata (
"date" TIMESTAMP,
"gold_price" DOUBLE,
"gold_open" DOUBLE,
"gold_high" DOUBLE,
"gold_low" DOUBLE,
"gold_change" DOUBLE -- GOLD CHANGE %,
"silver_price" DOUBLE,
"silver_open" DOUBLE,
"silver_high" DOUBLE,
"silver_low" DOUBLE,
"silver_change" DOUBLE -- SILVER CHANGE %,
"gprd" DOUBLE,
"gprd_act" DOUBLE,
"gprd_threat" DOUBLE,
"event" VARCHAR
);
Anyone who has the link will be able to view this.