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)	JSLHISAR	411	410.05	431	410.05	421.65	551525	2346.23	16321	223958	40.61000061035156
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSLHISAR	421.65	427	431.95	415.65	421.25	191974	818.25	7025	97837	50.959999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSLHISAR	421.25	426.7	429	402.35	413.6	171730	709.93	8607	69768	40.630001068115234
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSLHISAR	413.6	416.7	425	404.8	418.6	211189	876.13	7597	92871	43.97999954223633
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSLHISAR	408.35	408	412.2	388.65	395.05	135763	546.44	5477	75223	55.40999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSLHISAR	418.6	418	420	407.2	408.35	196804	811.92	6300	102129	51.88999938964844
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSLHISAR	414.5	413	418	410	411	105047	434.54	3486	55967	53.27999877929688
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JSLHISAR	75.65	75.45	80.7	74	78.25	596729	465.83	5341	274865	46.06
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JSLHISAR	78.25	78.25	80.95	78	80.4	379019	302.7	2983	185355	48.9
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JSLHISAR	80.4	80.4	83.3	79.8	80.45	170934	139.02	1773	91083	53.29


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