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)	PFC	121.9	122.05	122.4	119.25	119.9	5249504	6313.41	26135	3038866	57.88999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PFC	119.9	120.4	120.75	118.6	120	3977530	4760.02	21236	1860442	46.77000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PFC	120	120.2	120.7	116.8	118.1	10081872	11896.09	43201	4515100	44.77999877929688
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PFC	118.1	118.6	120.75	117.9	120.3	9470932	11279.99	32838	5968531	63.02000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PFC	123.15	121.95	124.15	120.15	121.3	16233602	19748.92	46497	6821569	42.02000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PFC	120.3	120.9	123.8	120.4	123.15	7913066	9670.83	31480	4066822	51.38999938964844
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PFC	123.05	123.45	123.7	121.6	121.9	4793109	5859.34	14771	3145378	65.62000274658203
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PFC	117.9	117.65	118.85	117.25	118.4	4243195	5013.84	16263	1069444	25.2
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PFC	118.4	118.7	120.3	118.1	119.85	2825976	3369.72	17065	497395	17.6
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PFC	119.85	119.55	121.25	118.1	118.75	3218434	3854.15	12766	617958	19.2


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