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)	IOB	21.55	21.55	21.65	20.95	21.05	4102521	872.58	10815	1572196	38.31999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOB	21.05	21	21.5	20.8	21	5395835	1140.54	7955	1364252	25.280000686645508
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOB	21	21.1	21.15	20.45	20.65	5698019	1181.62	7041	1212476	21.280000686645508
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOB	20.65	20.85	20.9	20.4	20.5	2496500	514.48	4620	1042830	41.77000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOB	20.6	20.45	20.6	20.25	20.3	1900007	387.78	4498	752632	39.61000061035156
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOB	20.5	20.55	20.65	20.4	20.6	3123804	641.52	4958	1019217	32.630001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOB	21.65	21.85	22.35	21.45	21.55	14776542	3233.82	16070	3886392	26.299999237060547
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IOB	11.3	11.3	11.4	11	11.1	856923	95.54	1464	424706	49.56
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IOB	11.1	11.2	11.3	11.05	11.15	808985	90.43	1312	356632	44.08
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IOB	11.15	11.2	11.2	11	11.1	637236	70.76	1209	408619	64.12


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