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)	LT	1933.65	1948	1957.8	1923.3	1947.95	1440816	28016.36	85121	657575	45.63999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	1947.95	1932.5	1947.5	1874.55	1884.5	2641464	50064.22	129248	1506561	57.040000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	1884.5	1890	1896.95	1848	1875.6	2040523	38112.3	108225	972675	47.66999816894531
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	1875.6	1884.5	1899.9	1875.6	1888.8	1390810	26250.61	74046	741730	53.33000183105469
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	1901	1889	1889	1850	1871.25	1744894	32574.52	104505	939148	53.81999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	1888.8	1892	1911	1881	1901	1288856	24510.26	74334	610260	47.34999847412109
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	1982.7	1981.5	1985	1930	1933.65	2262217	44061.2	114638	1309045	57.869998931884766
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	1298.2	1308.4	1318.9	1303	1309.95	3123998	40952.86	73190	931657	29.82
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	1309.95	1312	1348	1311	1345.3	4335359	57846.06	135378	2189407	50.5
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	1345.3	1344.95	1344.95	1330.15	1335.05	2059871	27517.28	77644	996530	48.38


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