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
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
Anyone who has the link will be able to view this.