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 fretail (
"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 fsl (
"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 gael (
"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 gail (
"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 galaxysurf (
"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 garfibres (
"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 geship (
"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 gicre (
"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 gillette (
"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 gland (
"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 glaxo (
"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 glenmark (
"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 gmmpfaudlr (
"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 gnfc (
"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 godfryphlp (
"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 godrejagro (
"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 godrejcp (
"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 godrejind (
"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 godrejprop (
"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 gppl (
"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 granules (
"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 graphite (
"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 grasim (
"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 greavescot (
"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 grindwell (
"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.