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)	PAGEIND	42458.55	42458.55	42624.75	41547	41691.35	14639	6146.23	6786	6195	42.31999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PAGEIND	41691.35	41850	41935	40500	40715.5	10597	4333.02	5908	4159	39.25
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PAGEIND	40715.5	40900	41426.6	40400	40884.2	31879	13020.46	12360	14818	46.47999954223633
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PAGEIND	40884.2	41399	42520	41066.85	42415.35	22580	9485.66	9765	8978	39.7599983215332
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PAGEIND	40953.5	40902.1	41500	39688.85	39803.3	43217	17501.69	14831	19461	45.02999877929688
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PAGEIND	42415.35	42151	42628.95	40300	40953.5	52366	21663.74	19395	21471	41
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PAGEIND	43221.15	43000	43748.75	42225.05	42458.55	18463	7927.28	7032	8174	44.27000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PAGEIND	23393.1	23350	23799	23241.1	23602.15	16716	3945.19	6464	2964	17.73
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PAGEIND	23602.15	23622	23849	23400	23587	17276	4076.58	6314	4697	27.19
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PAGEIND	23587	23520	23640.8	23205.25	23281.95	14078	3298.88	5876	3940	27.99


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