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)	IEX	235.6	236.8	236.85	232.1	232.85	5622404	13167.1	70602	2253568	40.08000183105469
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IEX	232.85	232	233.4	224	225.65	9931957	22570.36	178940	4347622	43.77000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IEX	225.65	226.5	227.5	215.6	222.85	16038816	35503.1	171923	5471434	34.11000061035156
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IEX	222.85	223.95	224.9	217.55	222.05	15125046	33335.77	130839	6772502	44.77999877929688
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IEX	225.3	223.5	224.8	218.5	219.45	8199030	18227.64	79632	2676690	32.650001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IEX	222.05	223.45	227.45	221.5	225.3	8898041	19989.49	84712	2754071	30.950000762939453
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IEX	239.75	239.75	240.95	235.15	235.6	5123711	12112.52	86991	2314014	45.15999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IEX	142.8	142.75	143.5	141.55	143.1	122079	174.65	1189	108313	88.72
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IEX	143.1	145	154	141.65	150.65	1278723	1860.26	3672	1140296	89.17
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IEX	150.65	152.85	162.4	152.2	159.9	1055314	1646.88	6813	765650	72.55


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