PREVIEW / futures_daily / 2023-10-18

all futures daily files

  file:    by_date/futures_daily/2023/2023-10-18.parquet
  size:    10 KB
  rows:    129

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-10-18	ES	Futures	4707.51	4708.85	4635.53	4647.84	2271572.0
2023-10-18	NQ	Futures	16443.54	16445.43	16165.91	16215.55	853599.0
2023-10-18	YM	Futures	35906.5	35934.9	35504.5	35576.1	214223.0
2023-10-18	CL	Futures	77.35	79.28	77.21	78.12	384528.0
2023-10-18	GC	Futures	2085.2	2127.3	2084.4	2119.2	270045.0
2023-10-18	ZN	Futures	107.711791	107.965268	107.22068	107.347418	1948270.0
2023-10-18	A6	Futures	0.64312	0.64584	0.63929	0.64019	88634.0
2023-10-18	AD	Futures	0.7393	0.74097	0.73552	0.73598	76929.0
2023-10-18	ALI	Futures	2399.93	2409.51	2390.34	2391.98	4250.0
2023-10-18	B	Futures	82.1	83.68	81.52	82.33	348193.0
2023-10-18	B6	Futures	1.2193	1.222	1.2146	1.2153	87211.0
2023-10-18	BR	Futures	0.18601	0.18601	0.18493	0.18545	421.0
2023-10-18	BTC	Futures	38179.3	38887.0	37678.5	37818.7	4733.0
2023-10-18	BZ	Futures	81.61	83.47	81.34	82.15	35456.0
2023-10-18	C	Futures	2645.0	2659.0	2625.0	2643.0	6607.0
2023-10-18	CB	Futures	267.453	267.453	266.462	266.462	5.0
2023-10-18	CC	Futures	2116.0	2142.0	2109.0	2123.0	23508.0
2023-10-18	CNH	Futures	7.0813	7.0832	7.0595	7.0794	788.0
2023-10-18	CSC	Futures	2.01	2.062	2.01	2.062	274.0
2023-10-18	CT	Futures	101.57	103.03	99.99	102.71	35021.0
2023-10-18	DC	Futures	19.24	20.0	19.18	20.0	836.0
2023-10-18	DX	Futures	104.584	104.994	104.372	104.914	13440.0
2023-10-18	E1	Futures	1.17313	1.17933	1.17224	1.17471	24834.0
2023-10-18	E6	Futures	1.07892	1.08065	1.07332	1.0746	177083.0
2023-10-18	E7	Futures	1.079	1.0808	1.0735	1.0748	4362.0
2023-10-18	EBM	Futures	324.88	330.71	322.48	330.03	61415.0
2023-10-18	ER	Futures	97.746	97.751	97.741	97.746	102854.0
2023-10-18	ESG	Futures	406.71	406.71	401.49	402.24	578.0
2023-10-18	EW	Futures	2643.9	2646.8	2583.6	2585.9	13506.0
2023-10-18	FBON	Futures	117.15	117.36	116.73	116.74	132.0
2023-10-18	FBTP	Futures	107.46	107.46	106.63	106.67	205869.0
2023-10-18	FBTS	Futures	105.117	105.157	105.005	105.025	143705.0
2023-10-18	FCE	Futures	7525.6	7541.1	7419.4	7454.6	51889.0
2023-10-18	FDAX	Futures	16126.3	16213.8	15939.9	16012.5	66201.0
2023-10-18	FDIV	Futures	171.92	171.92	171.72	171.72	4.0
2023-10-18	FDXM	Futures	16130.5	16205.3	15936.7	16006.3	47865.0
2023-10-18	FDXS	Futures	16011.6	16098.4	15833.7	15901.7	26600.0
2023-10-18	FESX	Futures	4187.5	4209.6	4133.1	4152.2	931905.0
2023-10-18	FEU3	Futures	97.746	97.746	97.746	97.746	0.0
2023-10-18	FGBL	Futures	130.22	130.41	129.68	129.73	930250.0
2023-10-18	FGBM	Futures	116.76	116.9	116.61	116.62	563551.0
2023-10-18	FGBS	Futures	106.923	106.969	106.882	106.892	530021.0
2023-10-18	FGBX	Futures	124.33	124.52	122.59	122.75	96132.0
2023-10-18	FMWO	Futures	9979.6	9999.5	9845.0	9913.4	3583.0
2023-10-18	FOAT	Futures	121.14	121.3	120.54	120.59	167591.0
2023-10-18	FSMX	Futures	25700.0	25709.2	25473.0	25544.9	231.0
2023-10-18	FTDX	Futures	3057.6	3058.1	3039.9	3045.1	45.0
2023-10-18	FTI	Futures	756.85	759.68	748.35	751.25	18397.0
2023-10-18	FTUK	Futures	7762.4	7796.1	7651.1	7675.2	100028.0
2023-10-18	FVSA	Futures	26.56	28.62	26.35	27.93	28964.0

> showing 50 of 129 rows — these rows as CSV

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