Global Stock Market (2008-2023)
Dataset encompasses daily price and volume data from several major global stock
@kaggle.pavankrishnanarne_global_stock_market_2008_present
Dataset encompasses daily price and volume data from several major global stock
@kaggle.pavankrishnanarne_global_stock_market_2008_present
This dataset encompasses daily price and volume data from several major global stock indices and commodities for the period of 2008 to 2023. The following financial instruments are included:
^NYA: NYSE Composite (New York Stock Exchange)
^IXIC: NASDAQ Composite
^FTSE: FTSE 100 Index (Financial Times Stock Exchange, UK)
^NSEI: Nifty 50 (National Stock Exchange of India)
^BSESN: BSE SENSEX (Bombay Stock Exchange, India)
^N225: Nikkei 225 (Japan)
000001.SS: SSE Composite Index (Shanghai Stock Exchange)
^N100: Euronext 100 (European Stock Exchange)
^DJI: Dow Jones Industrial Average (USA)
^GSPC: S&P 500 Index (USA)
GC=F: Gold Futures
CL=F: Crude Oil Futures
For each ticker symbol, the following columns are included:
Date: The date of the data point.
Open: The opening price for the given date.
High: The highest price for the given date.
Low: The lowest price for the given date.
Close: The closing price for the given date.
Adj Close: The adjusted closing price for the given date.
Volume: The number of shares traded on the given date.
Usage:
This data can be used for a wide range of tasks such as financial analysis, trading strategy backtesting, machine learning modelling, etc. It's a valuable resource for anyone interested in financial market dynamics and the interconnectedness of global financial markets.
CREATE TABLE n_2008_globla_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE n_2009_globla_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE n_2010_global_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE n_2011_global_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE n_2012_global_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE n_2013_global_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE n_2014_global_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE n_2015_global_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE n_2016_global_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE n_2017_global_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE n_2018_global_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE n_2019_global_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE n_2020_global_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE n_2021_global_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE n_2022_global_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE n_2023_global_markets_data (
"ticker" VARCHAR,
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);Anyone who has the link will be able to view this.