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)	APLAPOLLO	912.2	912.2	916.95	901.95	909.1	292193	2658.63	11593	190369	65.1500015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APLAPOLLO	909.1	908.3	914.15	895	902.95	169413	1532.63	14915	88820	52.43000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APLAPOLLO	902.95	901	912.1	873	879.55	175578	1552.15	13165	63114	35.95000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APLAPOLLO	879.55	880	904	876.95	893.75	159091	1420.02	9682	59499	37.400001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APLAPOLLO	896.25	880.05	901.9	874	899	271334	2417.98	13020	166930	61.52000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APLAPOLLO	893.75	894	903.7	869	896.25	413100	3658.02	18193	207555	50.2400016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APLAPOLLO	922.7	925	926.55	896.4	912.2	652086	5942.21	21748	505991	77.5999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	APLAPOLLO	1877.7	1892.1	1939	1872	1892.8	70001	1339.64	6743	26971	38.53
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	APLAPOLLO	1892.8	1908	1918.75	1881.1	1901.95	123291	2353.88	1972	111970	90.82
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	APLAPOLLO	1901.95	1910	1910	1825.35	1851.3	35950	671.34	2941	23254	64.68


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