NIFTY ALL STOCK Dataset
NIFTY 50, NIFTY BANK, NIFTY 500, RELIANCE, ZOMATO all equity dataset
@kaggle.akshaypawar7_nifty_dataset
NIFTY 50, NIFTY BANK, NIFTY 500, RELIANCE, ZOMATO all equity dataset
@kaggle.akshaypawar7_nifty_dataset
CREATE TABLE hindzinc (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE homefirst (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE honaut (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE hudco (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE ibrealest (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE ibulhsgfin (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE icicibank (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE icicigi (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE icicipruli (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE icil (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE idbi (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE idea (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE idfc (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE idfcfirstb (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE iex (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE ifbind (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE igl (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE iifl (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE iiflwam (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE indhotel (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE indiacem (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE indiamart (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE indianb (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE indigo (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
CREATE TABLE indigopnts (
"date" TIMESTAMP,
"symbol" VARCHAR,
"pre_close" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"turnover_lacs" DOUBLE,
"no_of_trades" BIGINT,
"deliv_volume" DOUBLE,
"deliv" DOUBLE -- Deliv %
);
Anyone who has the link will be able to view this.