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)	WELSPUNIND	137.8	135	135.85	127.4	129.25	4573960	5961.26	39892	2249284	49.18000030517578
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WELSPUNIND	129.25	129.25	130.5	122.7	123.4	2020503	2531.79	22894	987833	48.88999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WELSPUNIND	123.4	124	125.2	116.4	117.3	3512558	4168.34	33625	1841985	52.43999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WELSPUNIND	117.3	118.5	123.9	118.2	120.15	3290160	3982.01	31207	1538979	46.77999877929688
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WELSPUNIND	121.85	120.7	121.25	117.35	117.85	1803502	2146.13	16156	1048086	58.11000061035156
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WELSPUNIND	120.15	120.1	123.1	118.55	121.85	1563943	1883.02	20754	687128	43.93999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WELSPUNIND	143	142.55	144.5	136.6	137.8	2591008	3612.38	20717	1164091	44.93000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WELSPUNIND	48	48.15	50.4	48.15	49.2	387963	191.87	3853	229187	59.07
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WELSPUNIND	49.2	49.45	50	49.1	49.35	360953	179.12	5431	226232	62.68
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WELSPUNIND	49.35	49.7	52.3	49.2	50	751530	380.67	5276	328032	43.65


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