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)	KPRMILL	707.65	711.2	723.4	696.95	715.3	316624	2258.62	18787	177946	56.20000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KPRMILL	715.3	719.65	727.95	687.4	691.8	1443014	10232.1	50161	534237	37.02000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KPRMILL	691.8	685	692.5	656.1	658.15	687816	4572.56	32896	413854	60.16999816894531
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KPRMILL	658.15	658.15	669.95	646	660.75	414123	2722	18560	245214	59.209999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KPRMILL	642.65	643	657.95	641.55	644.35	448181	2901.47	26920	289007	64.4800033569336
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KPRMILL	660.75	662.95	662.95	640	642.65	425117	2740.2	21458	289913	68.19999694824219
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KPRMILL	716.75	724	725.65	704.9	707.65	308645	2199.37	18963	181215	58.709999084472656
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KPRMILL	658.45	654.05	664.9	653.7	660.45	2050	13.49	403	1297	63.27
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KPRMILL	660.45	661.95	672	660.05	666.35	4615	30.69	529	3036	65.79
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KPRMILL	666.35	673.5	681	663.2	673.1	6046	40.46	674	4357	72.06


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