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)	CANFINHOME	658.3	658.9	661.45	640	642.05	612782	3976.15	15119	206894	33.7599983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CANFINHOME	642.05	642	643.9	627.35	632.5	403952	2565.17	12467	93258	23.09000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CANFINHOME	632.5	632	637.5	614	629.15	426956	2673.16	13382	82010	19.209999084472656
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CANFINHOME	629.15	632.2	636.15	623.95	628.85	410572	2583.79	9396	62651	15.260000228881836
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CANFINHOME	640.55	631	636.85	617.2	621.55	450527	2825.83	14360	140424	31.170000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CANFINHOME	628.85	631	653.4	627.3	640.55	542867	3480.57	16036	74681	13.760000228881836
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CANFINHOME	667.55	667.55	668	654	658.3	786241	5207.08	20522	243476	30.96999931335449
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CANFINHOME	393.05	395	396.35	393.9	395.35	53092	209.97	1588	30631	57.69
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CANFINHOME	395.35	396	404.7	395.5	400.3	178064	713.52	4157	71356	40.07
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CANFINHOME	400.3	400.5	402.35	392.85	395.25	121673	481.46	3500	39946	32.83


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