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)	AARTIDRUGS	513.7	513.7	528.3	513.7	525.1	301978	1581.47	12064	119970	39.72999954223633
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIDRUGS	525.1	527	536.4	524.05	526	219486	1158.54	9092	88346	40.25
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIDRUGS	526	528.8	529.8	519.4	522.45	189733	991.82	9190	87352	46.040000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIDRUGS	522.45	519.5	527	519.5	525	71601	374.75	5791	36060	50.36000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIDRUGS	525.15	524.85	524.85	516.15	518.25	75074	389.56	4365	41568	55.369998931884766
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIDRUGS	525	523.05	528.95	522.4	525.15	93492	490.29	6261	48723	52.11000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIDRUGS	512.9	516.9	517	507	513.7	130816	670.6	7663	79912	61.09000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIDRUGS	579.3	579.3	598.4	575.55	591.9	13121	77.55	1183	6883	52.46
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIDRUGS	591.9	589.55	600	588.25	590.2	8625	51.18	725	4899	56.8
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIDRUGS	590.2	590.2	590.2	565	568.45	19115	109.61	1462	10549	55.19


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