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)	BEL	207.95	209.45	209.6	204.35	204.8	5977692	12357.41	58586	3341097	55.88999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BEL	204.8	204.9	205.8	199.6	202.1	6108343	12324.36	63205	2718576	44.5099983215332
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BEL	202.1	202.2	203.9	196.4	199.5	8759626	17433.52	73603	5469887	62.43999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BEL	199.5	199.4	203.25	198.1	202.6	5101734	10310.6	48726	2838311	55.630001068115234
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BEL	202.8	200.85	203.65	199.85	200.35	3835311	7714.34	42324	1981132	51.65999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BEL	202.6	202.95	204.75	200.5	202.8	4034747	8186.12	56124	2082502	51.61000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BEL	210.75	211	211.45	207.55	207.95	3851742	8052.9	41019	1701803	44.18000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BEL	100.05	100.3	100.95	99.4	100.15	5146098	5153.01	12979	1941887	37.74
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BEL	100.15	100.65	103.8	99.9	103.15	8754250	8905.34	28420	3281472	37.48
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BEL	103.15	103.2	103.9	100.35	100.95	7316741	7466.52	18943	2259266	30.88


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