PREVIEW / futures_daily / 2023-01-19

all futures daily files

  file:    by_date/futures_daily/2023/2023-01-19.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-19	ES	Futures	4362.31	4366.18	4314.21	4329.42	1896890.0
2023-01-19	NQ	Futures	12873.63	12892.15	12691.81	12745.68	594769.0
2023-01-19	YM	Futures	36060.8	36085.7	35735.5	35813.3	176088.0
2023-01-19	CL	Futures	69.35	71.15	68.5	70.38	321126.0
2023-01-19	GC	Futures	2158.1	2192.0	2152.5	2177.3	214246.0
2023-01-19	ZN	Futures	119.047783	119.449158	118.630353	118.823013	1712227.0
2023-01-19	A6	Futures	0.70957	0.71019	0.70243	0.70712	86923.0
2023-01-19	AD	Futures	0.7521	0.75479	0.75063	0.75428	67590.0
2023-01-19	ALI	Futures	2911.06	2930.38	2852.82	2892.57	1903.0
2023-01-19	B	Futures	73.7	75.9	73.19	75.29	250959.0
2023-01-19	B6	Futures	1.2459	1.2511	1.2425	1.2506	77268.0
2023-01-19	BFX	Futures	4152.2	4152.2	4138.8	4138.8	10.0
2023-01-19	BR	Futures	0.16997	0.17176	0.16819	0.17136	361.0
2023-01-19	BTC	Futures	28665.9	29173.2	28425.9	29070.4	5319.0
2023-01-19	BZ	Futures	73.14	75.1	72.41	74.5	28822.0
2023-01-19	C	Futures	1586.0	1589.0	1550.0	1551.0	16679.0
2023-01-19	CB	Futures	230.019	230.019	228.061	229.04	39.0
2023-01-19	CC	Futures	1523.0	1527.0	1495.0	1500.0	29885.0
2023-01-19	CNH	Futures	6.4079	6.4317	6.4065	6.4149	719.0
2023-01-19	CSC	Futures	2.372	2.381	2.371	2.371	443.0
2023-01-19	CT	Futures	111.2	112.3	109.14	109.35	18151.0
2023-01-19	DC	Futures	22.49	22.49	22.25	22.32	424.0
2023-01-19	DX	Futures	99.361	99.424	98.933	99.002	20172.0
2023-01-19	E1	Futures	1.19307	1.19459	1.1891	1.19366	17074.0
2023-01-19	E6	Futures	1.12103	1.12589	1.11984	1.12496	175461.0
2023-01-19	E7	Futures	1.1203	1.1251	1.1191	1.1243	5997.0
2023-01-19	EBM	Futures	426.19	426.93	420.27	421.01	20868.0
2023-01-19	ED	Futures	94.5067	94.5216	94.4669	94.4868	111681.0
2023-01-19	ER	Futures	97.731	97.746	97.691	97.696	186141.0
2023-01-19	ESG	Futures	373.0	373.08	369.45	370.75	1029.0
2023-01-19	EW	Futures	2745.7	2748.5	2703.0	2716.6	9830.0
2023-01-19	FBON	Futures	126.93	126.93	125.34	125.89	541.0
2023-01-19	FBTP	Futures	115.49	115.52	113.73	114.51	183871.0
2023-01-19	FBTS	Futures	107.387	107.437	107.006	107.186	130692.0
2023-01-19	FCE	Futures	7672.8	7680.4	7559.3	7565.8	73550.0
2023-01-19	FDAX	Futures	16396.8	16422.7	16169.8	16207.6	73863.0
2023-01-19	FDIV	Futures	177.31	177.71	177.31	177.71	1.0
2023-01-19	FDXM	Futures	16295.8	16324.8	16070.2	16110.0	61285.0
2023-01-19	FDXS	Futures	16237.3	16237.3	15975.7	16012.0	25333.0
2023-01-19	FESX	Futures	4126.6	4139.6	4071.0	4077.0	1240578.0
2023-01-19	FEU3	Futures	97.766	97.766	97.766	97.766	0.0
2023-01-19	FGBL	Futures	140.55	141.01	139.4	139.83	922065.0
2023-01-19	FGBM	Futures	121.55	121.66	120.92	121.06	778045.0
2023-01-19	FGBS	Futures	108.604	108.66	108.445	108.486	562581.0
2023-01-19	FGBX	Futures	156.61	157.61	153.79	155.04	72070.0
2023-01-19	FMWO	Futures	9554.9	9576.6	9477.0	9488.5	2919.0
2023-01-19	FOAT	Futures	132.06	132.4	130.83	131.33	232979.0
2023-01-19	FSMX	Futures	30376.7	30453.0	29854.8	29903.6	2510.0
2023-01-19	FTDX	Futures	3425.9	3425.9	3356.0	3367.8	55.0
2023-01-19	FTI	Futures	772.24	772.81	760.02	761.96	15637.0

> showing 50 of 131 rows — these rows as CSV

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