NIFTY ALL STOCK Dataset

date Date	symbol Symbol	pre_close Pre Close	open Open	high High	low Low	close Close	volume Volume	turnover_lacs Turnover Lacs	no_of_trades No Of Trades	deliv_volume Deliv Volume	deliv Deliv %
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACHEM	965.35	970	972	950.6	957.7	935679	9019.11	22690	167288	17.8799991607666
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACHEM	957.7	960	967.75	946.5	953.2	657299	6294.02	24057	126896	19.309999465942383
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACHEM	953.2	957	959.6	916	927.9	1061197	9870.35	30976	173681	16.3700008392334
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACHEM	927.9	934.2	973	933.8	967.55	1041919	9932.63	27501	228234	21.90999984741211
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACHEM	959.8	964	968.9	911.55	914.7	3439322	32091.1	84388	1028359	29.899999618530277
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACHEM	967.55	971.8	975	956	959.8	1395980	13503.03	33266	220229	15.779999732971191
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACHEM	966.75	965	981	961.5	965.35	1577566	15346.65	46630	348632	22.100000381469727
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACHEM	667.1	668.55	673.4	663.25	671.35	519610	3479.05	8209	176050	33.88
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACHEM	671.35	672.2	675.2	667.55	672.8	578952	3885.89	7853	212207	36.65
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACHEM	672.8	672.8	676.7	666.05	670.05	415545	2792.01	7261	182646	43.95


CREATE TABLE tatachem (
  "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
);