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 aartidrugs (
"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 aartiind (
"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 aavas (
"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 abb (
"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 abbotindia (
"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 abcapital (
"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 abfrl (
"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 acc (
"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 adanient (
"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 adanigreen (
"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 adaniports (
"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 adanitrans (
"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 advenzymes (
"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 aegischem (
"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 affle (
"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 aiaeng (
"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 ajantpharm (
"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 alembicltd (
"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 alkem (
"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 alkylamine (
"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 alokinds (
"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 amarajabat (
"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 amber (
"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 ambujacem (
"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 angelone (
"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.