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)	JSWSTEEL	653.15	647	665.9	647	657.35	3284062	21707.37	64856	529834	16.1299991607666
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTEEL	657.35	659.4	666.65	645.6	651.15	2768417	18177.82	52229	579000	20.90999984741211
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTEEL	651.15	655.6	662.9	644.25	660.1	3184065	20915.73	57009	409997	12.880000114440918
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTEEL	660.1	662.85	666.6	657.85	663.05	2200828	14572.48	41436	433314	19.690000534057617
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTEEL	672.55	668.95	675	659.65	671.4	3122555	20886.47	59671	631779	20.229999542236328
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTEEL	663.05	666.2	678	664.1	672.55	4284880	28860.69	79471	1158499	27.040000915527344
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTEEL	659.85	657	667.4	650	653.15	2456228	16203.4	43674	493719	20.100000381469727
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTEEL	270.05	270.7	273.5	265.85	268.1	6952048	18735.12	44999	1052112	15.13
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTEEL	268.1	272	277	271.55	276.45	10780926	29640.45	73900	1139113	10.57
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTEEL	276.45	276.45	276.45	270.75	272.45	5943349	16235.33	38332	1042941	17.55


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