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)	APLLTD	761.55	761	765.35	745.9	747.55	120448	905.7	5373	51831	43.02999877929688
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APLLTD	747.55	747.55	762	731.25	732.75	146293	1079.17	5318	65457	44.7400016784668
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APLLTD	732.75	740.75	742.3	723.4	731.5	502455	3680.94	15241	219138	43.61000061035156
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APLLTD	731.5	730.1	756.7	730.1	753.65	130943	975.12	5659	44270	33.810001373291016
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APLLTD	758.45	750	762.3	746.45	752.4	158556	1196.57	6084	39611	24.979999542236328
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APLLTD	753.65	760	772.5	743	758.45	949804	7178.01	24250	238792	25.13999938964844
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APLLTD	773.25	773.25	774.95	756.75	761.55	116034	889.7	3061	76926	66.30000305175781
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	APLLTD	571.3	575.8	575.8	547.45	550.7	35709	198.64	2370	24400	68.33
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	APLLTD	550.7	552.5	563.1	551.6	561.85	37424	209.57	2027	19831	52.99
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	APLLTD	561.85	563.9	569	558.2	563.65	17141	96.59	1327	10439	60.9


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