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)	IGL	401.15	402.4	402.85	396	396.65	1414618	5642.56	21501	501490	35.45000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IGL	396.65	400	400.7	390.7	394.1	1846075	7297.55	27273	814081	44.09999847412109
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IGL	394.1	396	396.1	384.75	392.1	2161065	8439.64	32656	866291	40.09000015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IGL	392.1	396.5	406	378.9	387.1	6930165	26961.01	102488	1647357	23.770000457763672
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IGL	389.9	387.5	395.8	387	392.85	3259759	12818.19	46505	1335755	40.97999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IGL	387.1	388.95	392.45	385.25	389.9	1665999	6489.95	41565	663299	39.810001373291016
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IGL	407.45	409.5	411	399	401.15	1913670	7741.94	35175	771278	40.29999923706055
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IGL	428.15	428.9	430.8	423.8	425.25	523748	2233.18	8815	121256	23.15
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IGL	425.25	426.3	426.8	419.5	421.85	1274239	5383.4	20220	456799	35.85
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IGL	421.85	422.3	423.1	412.25	417.05	1925765	8014.74	27674	498083	25.86


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