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)	PRSMJOHNSN	139.7	140	140.85	136.1	136.4	292838	404.16	3732	120525	41.15999984741211
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRSMJOHNSN	136.4	137.1	138.7	130.15	132.9	348185	466.39	5697	120275	34.540000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRSMJOHNSN	132.9	133.6	134.85	126.1	128.15	494983	635.54	8609	212867	43
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRSMJOHNSN	128.15	130	135	126.2	129.7	390232	502.25	5955	196255	50.290000915527344
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRSMJOHNSN	130.05	129	130.3	125	127	338808	433.48	5065	134129	39.59000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRSMJOHNSN	129.7	130.35	131.75	129.15	130.05	350353	456.59	4660	112709	32.16999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRSMJOHNSN	138	138.5	143.4	138.05	139.7	381690	538.78	5096	134193	35.15999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PRSMJOHNSN	62.8	62.7	63.7	61.8	63.5	237632	149.53	2226	181480	76.37
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PRSMJOHNSN	63.5	63.5	70	63.5	67.35	786913	536.33	7765	299002	38
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PRSMJOHNSN	67.35	67.1	68.75	65.6	66.45	224600	151.05	4125	116726	51.97


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