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)	IIFLWAM	1638.8	1653	1680.9	1634	1657.5	115974	1923	9730	73540	63.40999984741211
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFLWAM	1657.5	1686	1704.9	1661	1680.6	59667	1006.63	8164	32748	54.880001068115234
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFLWAM	1680.6	1690	1692.25	1637.85	1680	74887	1249.1	10968	47258	63.11000061035156
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFLWAM	1680	1688.4	1695	1656.45	1688.45	33905	568.71	4515	19345	57.060001373291016
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFLWAM	1673.6	1613.35	1673.2	1590	1609.5	31209	509.33	4335	19302	61.84999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFLWAM	1688.45	1695	1695	1640	1673.6	41324	689.13	6513	23498	56.86000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFLWAM	1622.8	1675.05	1687	1625.9	1638.8	130671	2170.99	22926	63729	48.77000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFLWAM	1133.85	1133.7	1148.35	1117.15	1142.75	795	9.04	149	634	79.75
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFLWAM	1142.75	1120	1148.95	1120	1136.7	1661	18.86	238	1424	85.73
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IIFLWAM	1136.7	1147.95	1247.75	1132	1171.7	14253	169.32	2026	10506	73.71


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