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)	ECLERX	2442.4	2456.9	2465.7	2429	2453.25	34343	842.05	5156	14122	41.119998931884766
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ECLERX	2453.25	2453.25	2488.85	2420	2445.75	44223	1078.77	6736	22053	49.869998931884766
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ECLERX	2445.75	2420	2466.4	2349.7	2364.6	38337	918.7	6093	13518	35.2599983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ECLERX	2364.6	2381.15	2410	2318.05	2333.75	35616	839.43	7405	15631	43.88999938964844
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ECLERX	2364.75	2355	2389.9	2349.45	2373.6	61625	1455.53	5412	43129	69.98999786376953
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ECLERX	2333.75	2357.25	2378.75	2344.7	2364.75	50130	1182.8	4948	29516	58.880001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ECLERX	2491.9	2550	2574.9	2411.15	2442.4	95608	2396.21	11615	33221	34.75
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ECLERX	568	571.95	669.9	563.15	637.2	873009	5602.15	34931	83751	9.59
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ECLERX	637.2	639.9	655	628.4	642.25	234035	1501.21	9587	50112	21.41
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ECLERX	642.25	641	709.9	634	667.05	561386	3855.14	23504	69894	12.45


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