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)	PERSISTENT	4342.65	4326.25	4342.95	4236.05	4296.25	114605	4925.23	18312	36417	31.780000686645508
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PERSISTENT	4296.25	4307	4316.5	4203	4232.7	113568	4815.2	19433	48653	42.84000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PERSISTENT	4232.7	4237	4274	4140	4163.4	126001	5273.23	20000	57714	45.79999923706055
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PERSISTENT	4163.4	4198.4	4392.4	4171	4366.5	241640	10423.58	29849	89331	36.970001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PERSISTENT	4413	4305	4339.1	4164.9	4196.25	240633	10188.35	26092	118173	49.11000061035156
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PERSISTENT	4366.5	4400	4456.1	4323.9	4413	258539	11406.22	36114	111727	43.209999084472656
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PERSISTENT	4436.15	4430	4430	4320	4342.65	128734	5641.01	17727	55379	43.02000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PERSISTENT	674.15	677.85	709.95	675.3	706.4	235944	1645.36	11806	110054	46.64
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PERSISTENT	706.4	708	728.8	707.4	713.4	217432	1556.79	10044	68600	31.55
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PERSISTENT	713.4	716	716	692	694.6	52485	367.29	4266	22880	43.59


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