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)	ICICIGI	1384.4	1387	1391.3	1353	1364.85	660886	9093.5	18024	553858	83.80999755859375
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIGI	1364.85	1360.1	1372.45	1326.1	1337	972861	13143.26	51974	733908	75.44000244140625
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIGI	1337	1337	1388.7	1336.95	1366.2	1016198	13877.79	56571	452841	44.560001373291016
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIGI	1366.2	1373.95	1378.2	1351	1366.85	604378	8278.95	22005	407826	67.4800033569336
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIGI	1344.25	1340	1356.4	1315.75	1343.5	837852	11218.24	51235	505548	60.34000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIGI	1366.85	1366.2	1366.2	1338.1	1344.25	579032	7790.59	41630	393978	68.04000091552734
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIGI	1383.95	1383	1391	1366.7	1384.4	316535	4355.86	21836	229601	72.54000091552734
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIGI	1386.8	1389.3	1398.4	1381.6	1385.45	104012	1445.3	12396	51144	49.17
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIGI	1385.45	1380	1389.95	1352	1360.7	310211	4229.63	22409	213105	68.7
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIGI	1360.7	1364	1397.8	1360.7	1388	577617	7949.34	30019	433417	75.04


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