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