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)	L&TFH	76.4	76.4	76.95	74.9	75.4	3357638	2543.13	16968	1167184	34.7599983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	L&TFH	75.4	75.45	75.8	74	74.5	4493230	3362.77	25353	1694849	37.720001220703125
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	L&TFH	74.5	74.5	74.95	73.1	74.3	5286504	3917.26	26186	1933509	36.56999969482422
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	L&TFH	74.3	74.75	75.65	74.5	75.4	5179124	3890.55	27357	1683574	32.5099983215332
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	L&TFH	75.75	75	75.45	73.95	74.15	4028548	2999.44	24013	1731458	42.97999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	L&TFH	75.4	75.85	76.3	74.75	75.75	4765434	3610.33	24850	1903819	39.95000076293945
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	L&TFH	77.35	77.5	77.5	76.2	76.4	2579279	1979.49	13203	1012803	39.27000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	L&TFH	118.55	118.4	119.5	117.4	118.1	3105250	3677.11	16429	349138	11.24
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	L&TFH	118.1	118.6	122.2	118.05	121	10145837	12253.08	41698	2569366	25.32
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	L&TFH	121	120.7	122.05	118	118.45	7609742	9120.49	29595	1393398	18.31


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