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)	IOC	124.65	124.9	125.35	123.7	124.15	7149068	8898.76	57670	3319075	46.43000030517578
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	124.15	124.5	124.6	122.5	122.9	8968249	11045.86	61392	5183472	57.79999923706055
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	122.9	123.1	123.55	120	121.35	15697108	19007.53	80230	8438662	53.7599983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	121.35	118.5	121.7	117.75	121.05	11720982	14103.91	75334	4041321	34.47999954223633
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	119.95	119.5	122.65	119.05	122.05	17657900	21467.03	95763	6483363	36.720001220703125
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	121.05	121.1	121.45	119.65	119.95	12080112	14553.07	86201	3715505	30.76000022888184
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	124.45	125.4	125.85	124.15	124.65	8744759	10918.2	70072	3585489	41
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	125.55	125.95	126.75	125.75	125.95	2127492	2683.16	13955	493903	23.22
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	125.95	126.2	127.2	126	127	2559180	3242.62	16315	977380	38.19
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	127	126.5	127.5	126.15	126.85	8852105	11217.36	45004	4438644	50.14


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