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)	CONCOR	660.95	660	662.8	641.5	643.2	739708	4803.1	20477	452553	61.18000030517578
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CONCOR	643.2	637	647.25	627.1	629.55	437862	2773.04	13226	153055	34.959999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CONCOR	629.55	630	632.9	613.05	615.6	1182518	7327.29	45893	634345	53.63999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CONCOR	615.6	617.4	619.95	612.4	616.7	582303	3586.78	19146	337672	57.9900016784668
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CONCOR	621.2	610	618.55	608.2	611.4	653640	4005.62	18967	328519	50.2599983215332
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CONCOR	616.7	618	629.35	615.1	621.2	1241177	7748.61	43561	640622	51.61000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CONCOR	664.2	664.2	664.2	655.5	660.95	818006	5392.37	19073	397831	48.630001068115234
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CONCOR	571.9	573.8	576.4	571	573	615465	3527.32	12462	309167	50.23
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CONCOR	573	575.95	575.95	568.45	572	835523	4778.33	13267	244705	29.29
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CONCOR	572	574.05	575.65	566.65	569.7	1086282	6203.37	17929	481813	44.35


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