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)	IOLCP	458.55	461	465	436.2	447.9	144313	654.97	6106	70315	48.720001220703125
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOLCP	447.9	441	441	425	426.9	317178	1369.65	12128	142171	44.81999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOLCP	426.9	427	432.9	422	423.75	141294	602.97	6631	56468	39.959999084472656
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOLCP	423.75	426.25	431.35	416.1	419.1	203607	855.83	8072	92933	45.63999938964844
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOLCP	410.2	407	413.2	401	402.8	182559	743.16	8039	89279	48.900001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOLCP	419.1	420	421.95	407.95	410.2	213628	885.84	10274	110055	51.52000045776367
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IOLCP	457.95	461	468.75	457.2	458.55	224691	1041.89	8196	84468	37.59000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IOLCP	174.1	174.1	175.3	170.5	171.3	87392	150.98	1973	48250	55.21
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IOLCP	171.3	172	176.85	170.35	174.3	187466	326.18	3397	78189	41.71
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IOLCP	174.3	173.5	180	172.05	174.95	262445	462.89	4283	88053	33.55


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