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)	KALYANKJIL	67.75	68.25	68.75	66.6	66.85	1417826	959.07	13903	724573	51.09999847412109
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KALYANKJIL	66.85	66.85	67.25	65.35	65.8	1148681	758	10868	692254	60.27000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KALYANKJIL	65.8	66	66.15	64.55	65	869311	566.57	8026	446713	51.38999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KALYANKJIL	65	65.4	65.6	64.6	64.85	806503	524.61	9861	436962	54.18000030517578
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KALYANKJIL	64.85	64.7	64.75	64.1	64.3	674997	434.96	4975	352707	52.25
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KALYANKJIL	64.85	65.5	65.5	64.6	64.85	567374	368.33	6438	332548	58.61000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KALYANKJIL	69.75	70.05	71.5	67.5	67.75	4343392	3020.22	32436	1842735	42.43000030517578
Fri Mar 26 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	KALYANKJIL	87	73.95	81	72.9	75.2	51421860	39664.3	360101	18436640	35.85
Tue Mar 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	KALYANKJIL	75.2	75.95	77.9	69.65	70.85	11092972	8139.95	100487	4400158	39.67
Wed Mar 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	KALYANKJIL	70.85	71.75	71.75	67.65	68.1	4659613	3224.62	39047	2087369	44.8


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