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 ksb (
"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 kscl (
"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 lalpathlab (
"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 laopala (
"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 lauruslabs (
"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 laxmimach (
"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 lemontree (
"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 lichsgfin (
"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 lindeindia (
"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 lodha (
"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 lt (
"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 l_tfh (
"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 lti (
"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 ltts (
"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 lupin (
"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 luxind (
"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 lxchem (
"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 mahabank (
"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 mahindcie (
"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 mahlog (
"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 manappuram (
"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 marico (
"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 maruti (
"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 mastek (
"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 maxhealth (
"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.