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)	ASHOKLEY	136.15	136.4	138.9	135.55	136.2	17293411	23659.55	80808	4877514	28.200000762939453
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKLEY	136.2	135.95	137.5	134.8	135.6	9396830	12784.75	49872	3068327	32.650001525878906
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKLEY	135.6	136.2	137.3	133.4	134	12272921	16576.94	41212	2120302	17.280000686645508
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKLEY	134	135.15	138.25	134.9	137.8	11923027	16321.2	46954	2586042	21.690000534057617
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKLEY	136.2	135.75	135.75	132.35	133	8928520	11923.94	43206	2762786	30.940000534057617
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKLEY	137.8	138.6	138.85	135.2	136.2	8215230	11265.99	34304	2366059	28.799999237060547
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKLEY	134.05	134	137.85	133	136.15	19122008	26091.13	91518	7259491	37.959999084472656
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKLEY	81.5	81.95	81.95	80.8	81.05	7797743	6335.16	22282	1370056	17.57
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKLEY	81.05	81	84.5	80.8	84	22915441	19061.89	74820	5639252	24.61
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASHOKLEY	84	84.25	84.95	82.9	83.7	16113767	13507.28	55531	2791972	17.33


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