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)	KNRCON	311.8	314	319	310	311.45	661632	2081.39	16649	330260	49.91999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KNRCON	311.45	312.8	316.4	308.65	311.1	304591	951.68	9683	127902	41.9900016784668
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KNRCON	311.1	311.1	314.35	306.55	310	277546	863.5	10431	118761	42.790000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KNRCON	310	312.7	315.5	310	311.35	263724	826.61	8345	113599	43.06999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KNRCON	316	313	315	310.1	311.7	174694	545.41	8936	81287	46.52999877929688
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KNRCON	311.35	312.7	317	307.25	316	222376	696.12	9669	95798	43.08000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KNRCON	320.05	322.25	322.25	310	311.8	446040	1401.85	13309	188808	42.33000183105469
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KNRCON	249.5	247.8	254.8	242.8	253.6	397725	998.93	9488	135740	34.13
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KNRCON	253.6	256	270	253	263.9	485899	1270.02	9652	188616	38.82
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KNRCON	263.9	271.7	271.7	260.55	261.3	361454	955.77	9076	157122	43.47


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