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)	JKCEMENT	3348.55	3346.95	3387.1	3318.25	3337.55	38682	1299.09	8066	9876	25.530000686645508
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKCEMENT	3337.55	3285.55	3379.95	3240.05	3329.8	88072	2925.6	14905	16004	18.170000076293945
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKCEMENT	3329.8	3348.95	3356.95	3258	3305.8	41517	1373.15	5931	17563	42.29999923706055
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKCEMENT	3305.8	3341.1	3341.1	3270.85	3298.45	44152	1453.7	6293	15944	36.11000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKCEMENT	3294.8	3285	3294.15	3145.05	3196.35	105629	3375.55	12178	43935	41.59000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKCEMENT	3298.45	3310	3326.9	3275	3294.8	30151	994.84	5286	11496	38.130001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKCEMENT	3404.95	3385	3421.6	3316.65	3348.55	36291	1227.5	6400	8092	22.299999237060547
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JKCEMENT	1168.85	1175	1184.95	1162.55	1176.5	24631	289.57	1431	17807	72.3
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JKCEMENT	1176.5	1178	1226	1178	1220.2	117401	1419.59	9317	61337	52.25
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JKCEMENT	1220.2	1220.25	1305	1209	1280.05	134085	1676.02	13196	69349	51.72


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