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
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.