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)	BASF	3131.7	3147.4	3180	3114.9	3159.65	11050	348.7	2606	3897	35.27000045776367
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BASF	3159.65	3175	3200.75	3089	3103.35	13875	434.38	2828	5990	43.16999816894531
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BASF	3103.35	3116	3166	3080	3151.45	21254	666.22	4839	9157	43.08000183105469
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BASF	3151.45	3199.9	3220	2940	2958.15	133404	4049.73	20417	39731	29.780000686645508
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BASF	2858.25	2800	2888	2800	2817.05	26160	739.95	4770	10552	40.34000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BASF	2958.15	2941.95	2942	2817	2858.25	89322	2559.55	11781	30234	33.849998474121094
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BASF	3186.3	3189.7	3214.85	3113.25	3131.7	13589	429.8	3012	7810	57.470001220703125
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BASF	988.25	985.05	1014.25	985	1008	11728	117.87	2962	6863	58.52
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BASF	1008	1010	1010	997	1000.45	8085	81.1	1442	4755	58.81
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BASF	1000.45	1009	1012.95	996.55	1007.2	12326	124.3	1124	7666	62.19


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