PREVIEW / futures_daily / 2023-01-20

all futures daily files

  file:    by_date/futures_daily/2023/2023-01-20.parquet
  size:    10 KB
  rows:    131

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-01-20	ES	Futures	4339.92	4412.34	4325.27	4410.13	1620355.0
2023-01-20	NQ	Futures	12795.63	13116.33	12755.5	13105.39	577769.0
2023-01-20	YM	Futures	35865.2	36184.0	35696.6	36175.4	165276.0
2023-01-20	CL	Futures	70.58	71.52	69.77	71.28	300145.0
2023-01-20	GC	Futures	2188.4	2194.4	2175.1	2182.1	165272.0
2023-01-20	ZN	Futures	118.823013	118.839068	118.020263	118.228978	1364331.0
2023-01-20	A6	Futures	0.70641	0.71279	0.70595	0.71243	57149.0
2023-01-20	AD	Futures	0.75367	0.7589	0.75189	0.75824	54322.0
2023-01-20	ALI	Futures	2913.82	2934.8	2894.22	2915.75	2581.0
2023-01-20	B	Futures	75.52	76.72	74.79	76.58	212917.0
2023-01-20	B6	Futures	1.2504	1.252	1.2448	1.251	60490.0
2023-01-20	BFX	Futures	4150.6	4150.6	4150.6	4150.6	0.0
2023-01-20	BR	Futures	0.17109	0.17109	0.17029	0.17082	27.0
2023-01-20	BTC	Futures	29008.7	30887.3	28707.0	30702.1	9472.0
2023-01-20	BZ	Futures	74.67	75.89	74.0	75.77	24374.0
2023-01-20	C	Futures	1548.0	1554.0	1524.0	1548.0	19127.0
2023-01-20	CB	Futures	229.481	230.998	229.481	230.998	8.0
2023-01-20	CC	Futures	1492.0	1503.0	1463.0	1499.0	43770.0
2023-01-20	CNH	Futures	6.4089	6.4328	6.4015	6.4243	2864.0
2023-01-20	CSC	Futures	2.376	2.384	2.364	2.366	266.0
2023-01-20	CT	Futures	109.6	113.81	109.59	113.69	19412.0
2023-01-20	DC	Futures	22.45	22.45	22.26	22.31	243.0
2023-01-20	DX	Futures	99.026	99.478	98.875	98.954	16661.0
2023-01-20	E1	Futures	1.1929	1.19513	1.18301	1.18693	18448.0
2023-01-20	E6	Futures	1.1248	1.12775	1.12185	1.12724	143187.0
2023-01-20	E7	Futures	1.124	1.127	1.1212	1.1265	5836.0
2023-01-20	EBM	Futures	418.06	422.86	416.95	421.01	17047.0
2023-01-20	ED	Futures	94.4918	94.4918	94.4719	94.4868	89381.0
2023-01-20	ER	Futures	97.696	97.701	97.675	97.685	101610.0
2023-01-20	ESG	Futures	371.42	377.92	370.73	377.88	1853.0
2023-01-20	EW	Futures	2716.7	2762.4	2707.0	2761.6	11105.0
2023-01-20	FBON	Futures	125.63	125.89	124.28	124.53	200.0
2023-01-20	FBTP	Futures	114.34	114.51	112.54	112.73	184190.0
2023-01-20	FBTS	Futures	107.176	107.176	106.765	106.835	109492.0
2023-01-20	FCE	Futures	7611.4	7644.0	7578.3	7613.1	54403.0
2023-01-20	FDAX	Futures	16268.2	16381.7	16206.6	16299.5	51383.0
2023-01-20	FDIV	Futures	178.79	178.79	178.65	178.65	1.0
2023-01-20	FDXM	Futures	16170.1	16284.0	16110.0	16201.3	48161.0
2023-01-20	FDXS	Futures	16070.8	16186.1	16011.0	16102.8	16801.0
2023-01-20	FESX	Futures	4092.9	4121.7	4077.9	4097.8	904763.0
2023-01-20	FEU3	Futures	97.751	97.751	97.751	97.751	0.0
2023-01-20	FGBL	Futures	139.63	139.83	138.4	138.55	716629.0
2023-01-20	FGBM	Futures	120.94	121.01	120.49	120.56	494214.0
2023-01-20	FGBS	Futures	108.486	108.486	108.353	108.379	388888.0
2023-01-20	FGBX	Futures	154.5	155.06	150.35	150.66	65900.0
2023-01-20	FMWO	Futures	9530.8	9668.2	9502.2	9590.4	3026.0
2023-01-20	FOAT	Futures	131.19	131.38	129.71	129.89	159745.0
2023-01-20	FSMX	Futures	30018.1	30333.2	30014.9	30333.2	113.0
2023-01-20	FTDX	Futures	3364.6	3380.0	3364.6	3372.0	15.0
2023-01-20	FTI	Futures	763.23	770.07	761.42	764.93	18574.0

> showing 50 of 131 rows — these rows as CSV

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