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)	POWERGRID	211.3	212	213.35	209.1	209.7	5496948	11583.26	66832	3054390	55.56999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	209.7	211.05	214.3	210	213.65	5901928	12579.31	53206	2531433	42.88999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	213.65	214	215.4	208.5	210.05	6805678	14323.82	65707	3289906	48.34000015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	210.05	210.6	211.65	208.7	209.35	7375489	15466.47	64650	4044469	54.84000015258789
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	212.05	210.2	212	207.05	207.8	15053348	31343.31	75003	10870678	72.20999908447266
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	209.35	210.05	215.7	210.05	212.05	14385251	30635.99	100131	8066694	56.08000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	214	214	215	211	211.3	3445792	7325.22	51152	1649249	47.86000061035156
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	190.25	190.55	195.9	190.25	195.5	7661462	14846.13	27168	3762688	49.11
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	195.5	195.55	196.7	194.35	195.1	3191453	6227.97	26046	1098914	34.43
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	195.1	194.25	194.8	191.25	193	4139027	7989.38	38139	2581533	62.37


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