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)	IDBI	51.55	51.8	52.1	50	50.2	11348404	5775.12	20385	3738391	32.939998626708984
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDBI	50.2	50.4	51.2	49.1	49.4	10555724	5283.58	19135	2764860	26.190000534057617
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDBI	49.4	49.55	49.85	48.05	48.7	7492918	3656.44	17453	1621041	21.6299991607666
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDBI	48.7	49.15	49.3	48.25	48.4	4301221	2090.89	9973	1291043	30.020000457763672
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDBI	48.55	48	48.4	47.5	47.65	4523815	2167.62	11330	1779770	39.34000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDBI	48.4	48.6	48.95	48.25	48.55	4363417	2120.21	10184	1325576	30.3799991607666
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDBI	49.2	50.55	52.2	50.05	51.55	27636623	14142.36	50528	6474595	23.43000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IDBI	37	36.9	37.6	36.85	37.1	1661071	617.19	3385	312090	18.79
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IDBI	37.1	37	37.85	37	37.5	2053240	769.9	6177	586316	28.56
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IDBI	37.5	37.45	37.7	37.05	37.2	1610210	600.98	4677	452129	28.08


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