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)	INOXLEISUR	414.35	414.35	419.8	403	405.95	901255	3700.37	29968	487749	54.119998931884766
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INOXLEISUR	405.95	408.4	409.1	395.95	399.35	302150	1218.03	11737	123436	40.84999847412109
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INOXLEISUR	399.35	402.4	403.2	391.35	394.7	451236	1792.95	16998	157005	34.790000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INOXLEISUR	394.7	396.7	405.95	393.05	404.5	470735	1885.26	16396	207460	44.06999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INOXLEISUR	413.45	409.7	412.1	398	402.15	407578	1655.76	13925	201239	49.369998931884766
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INOXLEISUR	404.5	404.85	416	402.8	413.45	315247	1296.48	8746	101901	32.31999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INOXLEISUR	433.25	434.9	434.9	408.55	414.35	875042	3636.37	22946	420946	48.11000061035156
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INOXLEISUR	382.35	382	384.6	374	380.5	101393	384.74	8248	51497	50.79
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INOXLEISUR	380.5	381.95	384.5	378.1	379.05	127836	486.35	5233	94584	73.99
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INOXLEISUR	379.05	374	379	373	375.05	109686	412.31	8936	65772	59.96


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