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)	CGPOWER	182.55	183.45	188.5	182.9	185.6	6687911	12376.46	17573	5434682	81.26000213623047
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CGPOWER	185.6	185.7	185.7	177	179.75	1890761	3415.77	19538	1380915	73.02999877929688
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CGPOWER	179.75	180.1	180.2	171	172.9	1357275	2353.28	21867	905235	66.69999694824219
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CGPOWER	172.9	173	178	170.1	172.15	1516747	2630.75	13651	1083204	71.41999816894531
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CGPOWER	172.8	173	173.05	169.05	171.65	902074	1540.67	7288	603856	66.94000244140625
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CGPOWER	172.15	173	175.15	170.85	172.8	904046	1556.97	9604	564672	62.459999084472656
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CGPOWER	175.75	176.85	184.5	174.7	182.55	2882064	5234.5	21752	1759305	61.040000915527344
Thu Feb 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CGPOWER	8.65	9	9.05	8.5	9.05	247319	22.04	686	183548	74.22
Fri Feb 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CGPOWER	9.05	9.35	9.5	8.8	8.95	420418	38.52	1279	281156	66.88
Mon Feb 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CGPOWER	8.95	8.85	8.85	8.55	8.75	316923	27.47	710	266846	84.2


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