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 sci (
"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 sequent (
"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 sfl (
"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 shardacrop (
"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 shilpamed (
"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 shreecem (
"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 shriramcit (
"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 siemens (
"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 sis (
"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 sjvn (
"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 skfindia (
"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 sobha (
"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 solara (
"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 solarinds (
"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 sonacoms (
"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 sonatsoftw (
"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 spandana (
"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 sparc (
"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 spicejet (
"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 srf (
"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 srtransfin (
"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 star (
"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 starcement (
"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 stltech (
"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 sudarschem (
"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.