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)	PGHL	5095.85	5099.95	5099.95	5054.75	5074.35	2263	114.98	713	1476	65.22000122070312
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHL	5074.35	5085	5099.9	5025	5048.3	7005	353.98	1396	5465	78.0199966430664
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHL	5048.3	5073.55	5087.2	5012.05	5024.3	11147	562.67	1376	8738	78.38999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHL	5024.3	5029	5100	5000	5006.65	14987	755.36	2751	8235	54.95000076293945
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHL	4946.8	4940.5	4959	4905	4920.55	3130	154.56	1152	2135	68.20999908447266
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHL	5006.65	5001	5006.65	4940.15	4946.8	8433	418.96	2194	5972	70.81999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHL	5093.3	5100	5131.9	5064	5095.85	3123	159.05	1031	2035	65.16000366210938
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHL	4366.7	4360	4422	4360	4408.35	13727	604.02	2465	8893	64.78
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHL	4408.35	4415.1	4440	4350	4399.9	12843	564.04	2563	8276	64.44
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHL	4399.9	4395	4417.95	4351.2	4380.65	8877	389.73	1612	6455	72.72


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