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)	ICICIBANK	808.95	809.8	812	795.8	805.05	10314067	82874.51	233121	5646806	54.75
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	805.05	798.05	805	781.45	786.4	14659368	115922.37	332005	8884191	60.59999847412109
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	786.4	790	795.7	774.3	792.5	14642455	114833.36	296476	7532297	51.43999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	792.5	797.25	804.25	794.2	802.8	8855292	70804.58	194125	5006434	56.540000915527344
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	805.5	796.85	797.4	787.9	790.8	13138408	104162.94	206865	7556702	57.52000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	802.8	805.95	808.8	796.3	805.5	13159771	105836.71	248496	7276067	55.290000915527344
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	813.75	814.05	818.4	806	808.95	9755335	79153.63	225774	4787466	49.08000183105469
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	538.9	539.9	542.5	535.7	536.75	7642793	41118.22	63603	3140787	41.09
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	536.75	536	541.9	535.85	540.6	10264223	55369.66	98335	5046054	49.16
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	540.6	538	540.8	536.25	538.85	9594690	51663.26	93857	4945623	51.55


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