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)	PCBL	229	230.65	230.8	225.6	226.8	437269	997.57	6812	193039	44.150001525878906
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PCBL	226.8	227	230.75	224.6	228.8	425485	968.37	8306	206705	48.58000183105469
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PCBL	228.8	229	230.45	221.85	226.2	642697	1460.23	11469	183152	28.5
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PCBL	226.2	227.9	229.25	223.55	224.25	358793	809.16	6784	160727	44.79999923706055
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PCBL	226.55	225	225.9	223.5	224.6	229399	515.19	4472	98149	42.790000915527344
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PCBL	224.25	227	228	223.25	226.55	488446	1100.69	9056	163588	33.4900016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PCBL	228.8	228.15	230.5	228	229	283307	649.53	4294	117801	41.58000183105469
Thu Jan 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PCBL	247.05	246.8	249.45	242.1	244.6	583316	1434.85	7125	316505	54.26
Fri Jan 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PCBL	244.6	243.75	245.85	241.2	242.45	351051	852.75	5701	185289	52.78
Mon Jan 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PCBL	242.45	245	252.95	244.25	251.6	1394520	3479.74	17178	783460	56.18


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