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)	JSL	211.6	212	219.7	210.9	216.45	1503570	3261.62	17135	458218	30.479999542236328
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSL	216.45	218	222	215.1	217.7	1476227	3242.47	18932	451398	30.57999992370605
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSL	217.7	221.5	224.4	208.5	211.3	1986606	4267.18	25000	515814	25.959999084472656
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSL	211.3	214.8	215.45	209.3	212.65	832392	1764.82	16528	320169	38.459999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSL	208.35	208.35	210.9	203	204.5	740076	1537.91	11139	201229	27.190000534057617
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSL	212.65	212.95	214.5	207.25	208.35	975416	2051.13	16072	359154	36.81999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSL	210.4	209	215.7	208.65	211.6	830857	1762.3	9356	204348	24.59000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JSL	38.65	38.9	39.4	38.35	39.05	462305	180.32	1511	224513	48.56
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JSL	39.05	39.4	41.7	38.65	39.35	2331596	944.68	6374	1123618	48.19
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JSL	39.35	39.4	41.2	38.85	39.3	1342182	538.02	7026	635123	47.32


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