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 itc (
"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 jswsteel (
"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 kotakbank (
"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 lt (
"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 maruti (
"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 mm (
"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 nestleind (
"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 nifty50_all (
"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 ntpc (
"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 ongc (
"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 powergrid (
"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 reliance (
"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 sbin (
"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 shreecem (
"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 stock_metadata (
"company_name" VARCHAR,
"industry" VARCHAR,
"symbol" VARCHAR,
"series" VARCHAR,
"isin_code" VARCHAR
);CREATE TABLE sunpharma (
"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 tatamotors (
"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 tatasteel (
"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 tcs (
"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 techm (
"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 titan (
"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 ultracemco (
"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 upl (
"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 vedl (
"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 wipro (
"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.