Historical Performance : World's Top Stock Indices
Daily Market Data from 2007 - 2021
@kaggle.rohitktiwari04_top_10_stock_indices
Daily Market Data from 2007 - 2021
@kaggle.rohitktiwari04_top_10_stock_indices
Stock Exchange is a market that allows you to buy and sell securities including shares of stock, bonds, and other financial instruments in a public venue. Stock markets enable companies to be traded publicly and raise capital. Stock markets promote investment. The raising of capital allows companies to grow their businesses, expand operations and create jobs in the economy. This investment is a key driver for economic trade, growth, and prosperity.
This dataset consists of 15 years of data of some of the world's most-followed stock indices from various developed and emerging markets. The data includes
the opening, closing, high, low, adjusted close and total volume of transactions that occurred on a given day.
People who invest in stock must be familiar with the Dow Jones, Nasdaq, Shanghai stock exchange as a few biggest exchanges in the list of largest stock exchanges in the world. But there are some other large stock exchanges that are tracked on a daily basis by traders and investors to gauge the global market sentiment. During the past 15 years, a few of these markets have also outperformed their global peers in terms of the total return delivered.
CREATE TABLE cac (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE dax (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE dow_jones (
"date" TIMESTAMP,
"n__open" DOUBLE -- Open,
"n__high" DOUBLE -- High,
"n__low" DOUBLE -- Low,
"n__close" DOUBLE -- Close
);CREATE TABLE ftse (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE hang_seng (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE kospi (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE nasdaq (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);CREATE TABLE nifty50 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE nikkei_225 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE sse (
"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.