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)	ZENSARTECH	428.5	427	428.95	414	414.95	1396419	5819.45	27196	827195	59.2400016784668
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZENSARTECH	414.95	414.5	422.55	398.2	401.8	1103548	4532.02	23200	643081	58.27000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZENSARTECH	401.8	406.3	409.55	386.05	389.4	1262137	4959.73	36876	628035	49.7599983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZENSARTECH	389.4	392.1	400.5	385.25	387.2	1173841	4593.8	36869	641618	54.65999984741211
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZENSARTECH	403.8	401	401	389.45	390	542508	2139.14	18660	267726	49.34999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZENSARTECH	387.2	392.55	407.7	391.85	403.8	1066193	4272.45	29449	452403	42.43000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZENSARTECH	436.75	437	437	426	428.5	458310	1972.91	16988	182595	39.84000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ZENSARTECH	174.6	175.95	176.9	173	175.4	18748	32.81	4269	12151	64.81
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ZENSARTECH	175.4	176.4	182.5	175.8	180.3	41068	73.37	4865	28076	68.36
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ZENSARTECH	180.3	181.5	202.4	181.5	190.95	274773	530.25	11745	71216	25.92


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