NIFTY-50 Stock Market Data (2000 - 2021)
Stock price data of the fifty stocks in NIFTY-50 index from NSE India
@kaggle.rohanrao_nifty50_stock_market_data
Stock price data of the fifty stocks in NIFTY-50 index from NSE India
@kaggle.rohanrao_nifty50_stock_market_data
Stock market data is widely analyzed for educational, business and personal interests.
The data is the price history and trading volumes of the fifty stocks in the index NIFTY 50 from NSE (National Stock Exchange) India. All datasets are at a day-level with pricing and trading values split across .cvs files for each stock along with a metadata file with some macro-information about the stocks itself. The data spans from 1st January, 2000 to 30th April, 2021.
Since new stock market data is generated and made available every day, in order to have the latest and most useful information, the dataset will be updated once a month.
NSE India: https://www.nseindia.com/
Thanks to NSE for providing all the data publicly.
Various machine learning techniques can be applied and explored to stock market data, especially for trading algorithms and learning time series models.
CREATE TABLE adaniports (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" BIGINT,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE asianpaint (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE axisbank (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE bajaj_auto (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" BIGINT,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE bajajfinsv (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" BIGINT,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE bajfinance (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE bhartiartl (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE bpcl (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE britannia (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE cipla (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE coalindia (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" BIGINT,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE drreddy (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE eichermot (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE gail (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE grasim (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE hcltech (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE hdfc (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE hdfcbank (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE heromotoco (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE hindalco (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE hindunilvr (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE icicibank (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE indusindbk (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE infy (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);CREATE TABLE ioc (
"date" TIMESTAMP,
"symbol" VARCHAR,
"series" VARCHAR,
"prev_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"last" DOUBLE,
"close" DOUBLE,
"vwap" DOUBLE,
"volume" BIGINT,
"turnover" DOUBLE,
"trades" DOUBLE,
"deliverable_volume" DOUBLE,
"n__deliverble" DOUBLE -- %Deliverble
);Anyone who has the link will be able to view this.