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)	ITI	116.95	117	118.25	116.05	116.6	116451	136.38	3326	43379	37.25
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ITI	116.6	116.5	117.55	115.3	116.3	125542	146.53	2851	51871	41.31999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ITI	116.3	116.1	116.85	114.6	114.95	168843	194.73	4347	83066	49.20000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ITI	114.95	115.3	116.5	114.1	114.95	161553	186.25	4010	65363	40.459999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ITI	114.8	114.6	114.85	113.85	113.95	100467	114.69	1798	60752	60.470001220703125
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ITI	114.95	114.95	115.75	114.55	114.8	106019	121.84	2401	52011	49.060001373291016
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ITI	118.5	117.6	118.6	116.65	116.95	139607	163.97	2783	66565	47.68000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ITI	92.5	92.5	93.5	91.5	91.8	416545	384.57	3357	138357	33.22
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ITI	91.8	92	96.45	91.8	95.8	2193295	2075.16	14238	778592	35.5
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ITI	95.8	96.5	98	94.2	94.8	2144433	2065.11	14721	802560	37.43


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