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)	ICIL	235.6	237.85	240	234	236	193141	458.05	3926	104512	54.11000061035156
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICIL	236	237.4	238.9	222	223.3	484930	1103.34	10276	246944	50.91999816894531
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICIL	223.3	223	223.95	206	211.65	565039	1210.63	12308	265506	46.9900016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICIL	211.65	213.4	215.4	204	205.55	502459	1040.05	10263	273899	54.5099983215332
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICIL	214.6	212.9	219.25	207.05	208.4	319539	680.54	6906	149755	46.869998931884766
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICIL	205.55	209.4	216	206.05	214.6	438811	924.71	8442	177037	40.34000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICIL	242.5	244	246.3	235	235.6	364707	869.74	7445	207746	56.959999084472656
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ICIL	46.7	46.95	53.7	46.95	51.75	289724	149.33	3220	139366	48.1
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ICIL	51.75	53.3	54	50.75	52.85	433789	231.2	5906	369200	85.11
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ICIL	52.85	51.1	55	51.1	53	210711	112.53	2555	142810	67.78


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