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)	DIVISLAB	4262.45	4270	4374.6	4232.45	4304.5	964227	41766.72	61352	492104	51.040000915527344
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DIVISLAB	4304.5	4304.5	4345.85	4178.35	4201.5	380821	16067.24	42532	118033	30.989999771118164
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DIVISLAB	4201.5	4201.5	4288.4	4168.25	4277.55	436195	18535.66	59480	167635	38.43000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DIVISLAB	4277.55	4280	4357.45	4278.8	4329.45	280094	12119.46	31958	127131	45.38999938964844
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DIVISLAB	4313.75	4313.75	4474	4240.05	4291.25	2585446	112089.49	211593	900726	34.84000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DIVISLAB	4329.45	4334.5	4361.95	4300.05	4313.75	559595	24194.1	53279	345950	61.81999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DIVISLAB	4219.65	4250	4274	4203	4262.45	504989	21427.5	45246	256889	50.869998931884766
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DIVISLAB	1845.8	1845	1849.6	1815.9	1818.85	157063	2871.57	5547	66204	42.15
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DIVISLAB	1818.85	1820.5	1833.8	1820.5	1825.9	102841	1878.17	6957	23397	22.75
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DIVISLAB	1825.9	1817	1847.85	1817	1834.8	281177	5163.6	16587	72159	25.66


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