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)	WELCORP	189.25	190	193.9	187.35	190.3	2258400	4326.94	15509	1090496	48.290000915527344
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WELCORP	190.3	191	191	178.1	180.5	1009290	1853.53	11606	396498	39.27999877929688
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WELCORP	180.5	181.8	183.35	176.6	178.5	1349405	2434.38	10562	640913	47.5
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WELCORP	178.5	179.95	183.8	178.95	181.95	1224068	2214.01	11689	717897	58.650001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WELCORP	185	176	177.5	170	172.85	3342925	5797.37	23640	1696309	50.7400016784668
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WELCORP	181.95	182	186	180.35	185	719028	1323.66	10248	414896	57.70000076293945
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WELCORP	189.75	187.15	191	186.5	189.25	853649	1614.25	6980	308069	36.09000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WELCORP	144.25	143.6	148.7	143	146.85	999508	1467.04	8834	396399	39.66
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WELCORP	146.85	147.85	148.6	145	146.2	467634	684.92	5838	212825	45.51
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WELCORP	146.2	145.5	154.4	143.05	148.5	1872702	2803.28	17390	771865	41.22


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