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)	GPPL	98.35	99	99.6	97	97.2	233555	229.99	3738	105663	45.2400016784668
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPPL	97.2	97.2	97.7	95.15	96.5	222955	214.19	6794	107822	48.36000061035156
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPPL	96.5	97	97	94.65	94.9	2124752	2038.65	4068	1994645	93.87999725341795
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPPL	94.9	95.25	96.4	95.05	95.45	124853	119.36	4062	63487	50.84999847412109
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPPL	95.5	94.55	94.7	92.75	93.4	266899	249.45	5716	145411	54.47999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPPL	95.45	95.65	97.4	95.05	95.5	868905	829.94	4017	785087	90.3499984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPPL	97.75	98.25	99.5	97.3	98.35	2120925	2088.67	4787	1969095	92.83999633789062
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GPPL	88.25	90.4	90.4	86.65	87.35	46060	40.41	1265	24428	53.04
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GPPL	87.35	87.9	90	87.3	88.85	158105	140.49	4297	94520	59.78
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GPPL	88.85	89.85	92.4	89.05	91.05	260729	236.51	7974	151897	58.26


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