COVID-19 - World Major Indices Historical Data
Last 10 years of Historical Data from the World Major Indices
@kaggle.alvarob96_covid19_world_major_indices_historical_data
Last 10 years of Historical Data from the World Major Indices
@kaggle.alvarob96_covid19_world_major_indices_historical_data
COVID-19 or Corona Virus is on anyone's lips, since it has affected (and still affecting) a lot of aspects in our lives. From when the virus was first considered a pandemic until now, it has driven the markets crazy, having one of the most significant effects on the past years. No one was able to predict this and none of the financial models was prepared for the huge change the market has suffered. This dataset aims to explain the market evolution before and after the COVID-19
Financial historical data from the World Major Indices, including: Shanghai, FTSE MIB, S&P 500, Nasdaq, Dow 30, Euro Stoxx 50, and much more. The dataset contains: OHLC values, the Volume and the Currency.
Note that the dataset has been generated using investpy an open-source Python package to extract financial data from Investing.com, and you can find all the usage information and documentation at: https://github.com/alvarobartt/investpy.
This dataset aims to explain the market evolution before and after the COVID-19 so as to extract conclusions based on just market data or maybe aggregating external data such as news reports, tweets, etc. so feel free to use this dataset and combine it with others so that we, the community, can develop useful kernels so as to analyse and understand this situation and its impacts. So it is also an open call to researchers, data scientists, financial analysts, etc. so to collaborate together in a market study on the impacts of COVID-19.
This dataset been created by Álvaro Bartolomé del Canto using investpy so as to retrieve the historical data from Investing.com. Also, the banner image is property of Investing.com since it is an Investing.com Weekly Comic.
CREATE TABLE aex (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE atx (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE bel_20 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE bist_100 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE bovespa (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE bse_sensex (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE budapest_se (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE cac_40 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE china_a50 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE cse_all_share (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE dax (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE dj_new_zealand (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE dj_shanghai (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE dow_30 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE euro_stoxx_50 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE ftse_100 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE ftse_mib (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE hang_seng (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE hnx_30 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE ibex_35 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE idx_composite (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE karachi_100 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE kospi (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE moex (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);CREATE TABLE nasdaq (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"currency" VARCHAR
);Anyone who has the link will be able to view this.