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)	LTTS	4591.95	4580	4624.45	4510.4	4543.85	326087	14902.91	27740	142500	43.70000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LTTS	4543.85	4544	4566.2	4426.05	4444.6	163147	7295.8	24288	57463	35.220001220703125
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LTTS	4444.6	4444.6	4489	4311.6	4417.4	270352	11851.21	33450	122588	45.34000015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LTTS	4417.4	4449.95	4640	4444.15	4575.2	437827	20107.98	36384	158093	36.11000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LTTS	4686.7	4610	4624.9	4466.15	4486	415641	18776.39	45640	183700	44.20000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LTTS	4575.2	4611.8	4700	4579.3	4686.7	327004	15215.14	28946	102705	31.40999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LTTS	4780	4750	4750	4576	4591.95	253639	11821.27	28170	118848	46.86000061035156
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LTTS	1468.45	1475	1500.75	1470	1493.8	81809	1219.69	6443	55415	67.74
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LTTS	1493.8	1483	1525	1483	1513.2	69666	1050.8	5840	34582	49.64
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LTTS	1513.2	1519.95	1524.95	1502.85	1510.6	41244	624.69	4485	21201	51.4


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