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)	IIFL	351.85	353.6	353.6	339	343.8	742692	2574.48	11073	391096	52.65999984741211
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFL	343.8	349.9	352	332	339.35	594095	2029.86	10182	294133	49.5099983215332
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFL	339.35	338.9	346.7	325.7	337.9	759515	2559.81	12842	381950	50.290000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFL	337.9	342.3	343.95	330.3	333.5	276664	931.94	7686	147154	53.18999862670898
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFL	334.05	330	332.6	323.5	327.25	405405	1326.8	8438	255942	63.130001068115234
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFL	333.5	335.75	339.4	329.35	334.05	353168	1185.54	6998	203136	57.52000045776367
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFL	346.05	348	359.65	337.3	351.85	1879626	6629.66	15829	826300	43.959999084472656
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFL	140.05	140.1	142.95	139	140.85	118369	166.87	2643	49810	42.08
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFL	140.85	141.95	147.5	141.05	142.8	217802	313.57	5145	132582	60.87
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFL	142.8	150	153.5	143.3	145	623981	912.24	10992	278891	44.7


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