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)	FLUOROCHEM	3144.3	3150	3198.9	3105.35	3166.25	105053	3313.54	15389	50612	48.18000030517578
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FLUOROCHEM	3166.25	3146	3159.75	3065.05	3089.85	72101	2235.27	9342	48326	67.02999877929688
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FLUOROCHEM	3089.85	3070	3120	2836	2911.05	99011	2912.78	15707	63580	64.22000122070312
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FLUOROCHEM	2911.05	2945	2988.8	2821.1	2844.95	74651	2150.51	10265	56403	75.55999755859375
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FLUOROCHEM	2937.6	2966	2985	2791	2894.2	38879	1123.23	3624
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FLUOROCHEM	2844.95	2985	2985	2815.1	2937.6	47339	1369.66	4755
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FLUOROCHEM	3125.4	3143	3160	3028	3144.3	128716	4001.12	18864	67501	52.43999862670898
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FLUOROCHEM	620.05	616.55	620	564.2	606.05	5401	32.94	400	3468	64.21
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FLUOROCHEM	606.05	607.1	625	599.25	615.65	12065	73.9	980	7653	63.43
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FLUOROCHEM	615.65	624.95	624.95	605	611.85	17417	106.53	933	12657	72.67


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