PREVIEW / futures_daily / 2023-07-19

all futures daily files

  file:    by_date/futures_daily/2023/2023-07-19.parquet
  size:    10 KB
  rows:    130

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2023-07-19	ES	Futures	4962.89	4991.59	4962.35	4978.32	1538747.0
2023-07-19	NQ	Futures	17451.22	17575.41	17409.64	17462.16	682279.0
2023-07-19	YM	Futures	37324.1	37639.7	37313.5	37465.4	167588.0
2023-07-19	CL	Futures	65.63	66.6	65.0	65.23	385595.0
2023-07-19	GC	Futures	2179.4	2181.7	2169.3	2177.6	159409.0
2023-07-19	ZN	Futures	114.710318	115.219223	114.662608	115.01248	1349143.0
2023-07-19	A6	Futures	0.69148	0.69229	0.68519	0.68778	81515.0
2023-07-19	AD	Futures	0.76785	0.76871	0.76648	0.7684	47862.0
2023-07-19	ALI	Futures	2466.42	2466.42	2425.34	2438.75	2026.0
2023-07-19	B	Futures	69.95	70.9	69.36	69.61	311439.0
2023-07-19	B6	Futures	1.3064	1.3069	1.2894	1.2955	134937.0
2023-07-19	BFX	Futures	4139.9	4139.9	4139.9	4139.9	0.0
2023-07-19	BR	Futures	0.19198	0.19324	0.19156	0.19324	158.0
2023-07-19	BTC	Futures	39982.9	40606.5	39935.9	40378.5	5138.0
2023-07-19	BZ	Futures	69.79	70.79	69.25	69.49	33372.0
2023-07-19	C	Futures	2120.0	2166.0	2116.0	2164.0	7636.0
2023-07-19	CB	Futures	239.117	240.022	236.974	237.164	22.0
2023-07-19	CC	Futures	1971.0	1994.0	1961.0	1990.0	21683.0
2023-07-19	CNH	Futures	6.892	6.933	6.8906	6.9283	825.0
2023-07-19	CSC	Futures	1.867	1.879	1.845	1.855	290.0
2023-07-19	CT	Futures	104.94	107.27	104.94	106.71	22.0
2023-07-19	DC	Futures	17.28	17.33	17.01	17.08	613.0
2023-07-19	DX	Futures	97.762	98.345	97.717	98.093	13466.0
2023-07-19	E1	Futures	1.24484	1.24622	1.23948	1.24314	16669.0
2023-07-19	E6	Futures	1.15251	1.15379	1.14698	1.1498	189013.0
2023-07-19	E7	Futures	1.1526	1.1538	1.147	1.1499	4729.0
2023-07-19	EBM	Futures	351.47	375.63	348.54	371.61	61513.0
2023-07-19	ER	Futures	97.822	97.843	97.812	97.828	110615.0
2023-07-19	ESG	Futures	431.91	433.86	431.72	432.84	616.0
2023-07-19	EW	Futures	2888.3	2908.2	2883.5	2901.0	9879.0
2023-07-19	FBON	Futures	124.03	124.03	122.64	122.85	974.0
2023-07-19	FBTP	Futures	115.52	115.55	114.19	114.36	139572.0
2023-07-19	FBTS	Futures	106.35	106.461	106.179	106.229	96374.0
2023-07-19	FCE	Futures	7960.9	8015.5	7941.9	7952.8	47765.0
2023-07-19	FDAX	Futures	17187.5	17297.6	17114.4	17173.7	49839.0
2023-07-19	FDIV	Futures	187.45	187.45	187.45	187.45	0.0
2023-07-19	FDXM	Futures	17273.8	17367.3	17184.5	17244.0	42328.0
2023-07-19	FDXS	Futures	17137.8	17258.2	17073.4	17133.6	16397.0
2023-07-19	FESX	Futures	4460.3	4484.6	4436.0	4444.1	638442.0
2023-07-19	FEU3	Futures	97.817	97.817	97.817	97.817	0.0
2023-07-19	FGBL	Futures	135.71	136.57	135.17	135.38	876392.0
2023-07-19	FGBM	Futures	118.76	119.28	118.59	118.69	679575.0
2023-07-19	FGBS	Futures	107.427	107.612	107.402	107.443	443397.0
2023-07-19	FGBX	Futures	142.11	143.59	140.6	141.13	101943.0
2023-07-19	FMWO	Futures	10633.9	10687.6	10633.9	10675.3	2302.0
2023-07-19	FOAT	Futures	126.91	127.75	126.36	126.56	150382.0
2023-07-19	FSMX	Futures	29612.0	29738.9	29455.9	29709.7	427.0
2023-07-19	FTDX	Futures	3409.7	3420.3	3403.4	3414.5	75.0
2023-07-19	FTI	Futures	816.37	819.94	811.32	813.09	15016.0
2023-07-19	FTUK	Futures	7572.7	7746.0	7569.1	7717.5	134014.0

> showing 50 of 130 rows — these rows as CSV

> unlock the full archive -- $79 one-time