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)	OFSS	3713.35	3700	3731.9	3611.2	3625.25	118473	4339.26	18508	43945	37.09000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFSS	3625.25	3625	3670	3556.05	3590.4	89772	3224.76	12432	32767	36.5
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFSS	3590.4	3618.55	3624	3511	3587.75	98169	3497.32	16482	40123	40.869998931884766
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFSS	3587.75	3585.75	3755	3580.15	3723.6	114845	4230.85	17172	45189	39.34999847412109
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFSS	3709.55	3671	3704.85	3622	3671.85	69983	2567.59	11260	29235	41.77000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFSS	3723.6	3760	3790	3686.25	3709.55	174699	6508.21	17939	81383	46.58000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFSS	3742.35	3742.35	3834	3620	3713.35	217010	8187.99	24687	73210	33.7400016784668
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	OFSS	2739.65	2739.65	2755	2730	2736.15	8229	225.96	849	6266	76.15
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	OFSS	2736.15	2737.05	2752.05	2710	2721.95	10577	288.8	2314	6944	65.65
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	OFSS	2721.95	2721.95	2750	2712	2717.1	14038	383.16	1888	7827	55.76


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