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)	PETRONET	213.05	212.55	214.3	212.35	212.75	1414284	3013.83	31429	976381	69.04000091552734
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PETRONET	212.75	213.9	214.7	211.2	212	1627708	3459.44	21994	1066954	65.55000305175781
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PETRONET	212	213.1	218.5	212.6	216.45	6935599	14962.62	35997	4542282	65.48999786376953
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PETRONET	216.45	217.3	219.9	216.15	218	4111121	8947.31	29887	3076163	74.83000183105469
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PETRONET	219.55	219.05	224.3	217.35	223.55	4568378	10187.21	34385	2352031	51.4900016784668
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PETRONET	218	223	223	217	219.55	5382874	11806.6	45104	1442966	26.809999465942383
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PETRONET	213.6	214	214.45	212.1	213.05	880973	1875.99	24734	426723	48.43999862670898
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PETRONET	267.95	268.5	269.8	266.3	266.6	805652	2156.91	8082	409549	50.83
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PETRONET	266.6	267	270.5	267	268.95	916521	2458.06	19207	430904	47.02
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PETRONET	268.95	269.25	271.85	268.2	269.25	1433324	3873.53	36827	656162	45.78


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