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)	LTI	6198.3	6150	6300	6108.3	6282	219167	13729	22534	72436	33.04999923706055
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LTI	6282	6289.8	6330	6084.2	6127.65	157433	9743.19	25633	57430	36.47999954223633
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LTI	6127.65	6140	6220	6029.05	6143.95	183679	11251.26	19124	70106	38.16999816894531
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LTI	6143.95	6160	6319.85	6160	6290.7	232924	14606.44	31281	121435	52.13999938964844
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LTI	6317.4	6160	6201.8	5976	5999.85	424193	25632.87	60749	221480	52.209999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LTI	6290.7	6339.9	6340	6250	6317.4	141271	8899.02	20218	62091	43.95000076293945
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LTI	6396.75	6378	6378	6179.6	6198.3	224304	14037.01	27738	91631	40.84999847412109
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LTI	1750.5	1750.1	1799	1750.1	1782.1	96053	1715.29	9530	40993	42.68
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LTI	1782.1	1786.9	1828	1782.5	1821.55	136403	2477.54	13369	85238	62.49
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LTI	1821.55	1821.45	1839	1791.25	1812.55	103417	1878.91	9558	57623	55.72


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