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)	PGHH	14842.35	14950.7	15260	14771.15	15119	38682	5802.27	4510	33865	87.55000305175781
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHH	15119	15225	15398.6	14780.1	14894.8	3924	592.46	2193	1110	28.290000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHH	14894.8	15064.8	15300	14950.05	15216.1	16684	2530.74	4057	9447	56.619998931884766
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHH	15216.1	15298.5	15666	15139.3	15336	17467	2669.51	3469	14263	81.66000366210938
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHH	15641.15	15635	15641.15	15315	15384.4	1932	298.49	1072	820	42.43999862670898
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHH	15336	15481.75	15700	15319.95	15641.15	11333	1757.57	2366	9015	79.55000305175781
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHH	14785.6	14803	15164.85	14710.15	14842.35	8776	1312.3	3945	2419	27.559999465942383
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHH	11447	11430.3	11472	11374	11408.6	4548	519.53	326	3967	87.23
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHH	11408.6	11360	11451.2	11290.1	11317.05	1411	160.02	906	915	64.85
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PGHH	11317.05	11375	11388.1	11290.05	11322.8	6039	683.69	483	5496	91.01


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