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)	JSWENERGY	301.6	298.2	303.55	295.25	297.75	263628	788.69	12103
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWENERGY	297.75	296	305	296	304.1	362558	1098.57	7331
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWENERGY	304.1	304.9	309.9	301	308.25	419619	1280.56	8294
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWENERGY	308.25	308.7	311.35	305	309.6	745184	2303.38	4488
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWENERGY	325.05	328	341.3	327.05	341.3	1096398	3720.71	15527
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWENERGY	309.6	307	325.05	302.1	325.05	1362602	4404.78	14022
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWENERGY	303.35	304.8	305	298	301.6	187621	564.22	6565
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWENERGY	69.35	69.55	70.1	68.65	69.05	281629	195.69	1540	164775	58.51
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWENERGY	69.05	69.15	71.4	69.05	69.5	1604845	1125.12	6792	1011880	63.05
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWENERGY	69.5	69.9	71.45	69.65	70.2	1021494	719.96	4918	332708	32.57


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