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)	JKPAPER	238.75	240.7	242.65	234.5	239.7	1159242	2777.11	14240	415505	35.84000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKPAPER	239.7	240	240.6	232.35	238.65	655842	1554.44	11989	193261	29.46999931335449
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKPAPER	238.65	239.9	239.9	231.2	235	564101	1329.09	10219	195708	34.689998626708984
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKPAPER	235	242.25	248.05	239.05	243.2	2558030	6224.35	33368	672578	26.290000915527344
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKPAPER	237.2	234.1	235.6	230	231.95	454599	1059.46	6252	167824	36.91999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKPAPER	243.2	243.25	243.25	221.3	237.2	780508	1857.07	12612	218443	27.989999771118164
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKPAPER	234	235.2	240.9	231	238.75	1544714	3679.92	17993	605186	39.18000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JKPAPER	124.2	124.35	125.95	123.15	123.6	450104	559.31	4234	228628	50.79
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JKPAPER	123.6	124.35	130.45	123.3	129.65	2825323	3617.65	27692	1023676	36.23
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JKPAPER	129.65	128.9	132.65	127.8	129.75	2033562	2657.01	19647	639163	31.43


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