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)	ABBOTINDIA	16083.35	16214.9	16214.9	15794.7	15864.05	19876	3164.45	7364	10045	50.540000915527344
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABBOTINDIA	15864.05	15864	15964.1	15516.1	15775.35	27259	4262.91	6783	17262	63.33000183105469
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABBOTINDIA	15775.35	15885	15898.45	15514	15562.6	20754	3240.55	4786	13441	64.76000213623047
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABBOTINDIA	15562.6	15660	16811	15545.05	16672.4	110598	18099.42	31505	23923	21.6299991607666
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABBOTINDIA	16615	16600	16783	16300.05	16537.05	22038	3643.51	7853	4093	18.56999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABBOTINDIA	16672.4	16830	16900	16215.05	16615	72856	12085.79	22945	15684	21.530000686645508
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABBOTINDIA	16201.3	16179	16398.95	16018.8	16083.35	22333	3617.44	6437	12786	57.25
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ABBOTINDIA	13075.5	13170.6	13452.15	13080	13140	4037	532.88	1399	1754	43.45
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ABBOTINDIA	13140	13119.95	13314.9	13119.95	13139.9	3435	453.22	1401	1619	47.13
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ABBOTINDIA	13139.9	13170	13274.2	13150	13248.25	6850	904.98	1934	4644	67.8


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