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)	PFIZER	4568.05	4579.7	4598.95	4460	4471.4	218942	9831.5	16432	173399	79.19999694824219
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PFIZER	4471.4	4460	4479.8	4343	4405.25	44851	1968.42	8368	14460	32.2400016784668
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PFIZER	4405.25	4390	4590	4380	4537.5	113429	5137.62	14712	19072	16.809999465942383
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PFIZER	4537.5	4500	4580.95	4500	4566.1	135601	6147.44	5281	106082	78.2300033569336
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PFIZER	4518.95	4499.9	4499.9	4438.85	4450.95	18577	829.4	3001	6101	32.84000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PFIZER	4566.1	4566	4566	4485.65	4518.95	69798	3146.28	3433	59684	85.51000213623047
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PFIZER	4625.85	4648	4662.6	4551.15	4568.05	30144	1384.12	5499	13050	43.290000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PFIZER	4224.7	4225	4250	4200	4230.35	24620	1040.05	2289	19081	77.5
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PFIZER	4230.35	4243.2	4246.75	4213	4227.5	31741	1342.2	1979	27694	87.25
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PFIZER	4227.5	4237.9	4255	4180	4198.9	17391	732.81	2265	13283	76.38


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