PREVIEW / futures_daily / 2009-07-06

all futures daily files

  file:    by_date/futures_daily/2009/2009-07-06.parquet
  size:    8 KB
  rows:    85

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
2009-07-06	ES	Futures	855.82	859.9	846.23	859.18	1736323.0
2009-07-06	NQ	Futures	1624.77	1626.46	1601.68	1622.8	251049.0
2009-07-06	YM	Futures	7425.5	7473.3	7346.1	7467.9	131777.0
2009-07-06	CL	Futures	172.45	172.74	166.82	168.53	256986.0
2009-07-06	GC	Futures	1290.3	1290.7	1274.1	1279.7	79789.0
2009-07-06	ZN	Futures	92.098595	92.246347	91.901592	92.07397	531278.0
2009-07-06	A6	Futures	0.63607	0.63816	0.62988	0.63414	69687.0
2009-07-06	AD	Futures	0.85052	0.85289	0.84607	0.85022	57509.0
2009-07-06	B	Futures	62.54	62.81	60.66	61.35	67045.0
2009-07-06	B6	Futures	1.6964	1.7002	1.6761	1.6924	111809.0
2009-07-06	BFX	Futures	2305.8	2305.8	2281.9	2285.6	312.0
2009-07-06	BR	Futures	0.19675	0.19675	0.19675	0.19675	47.0
2009-07-06	C	Futures	1689.0	1705.0	1679.0	1703.0	1003.0
2009-07-06	CB	Futures	71.337	71.337	71.337	71.337	40.0
2009-07-06	CC	Futures	2197.0	2205.0	2174.0	2200.0	3547.0
2009-07-06	CT	Futures	52.27	52.27	50.58	51.57	92.0
2009-07-06	DC	Futures	19.85	19.9	19.58	19.76	271.0
2009-07-06	DX	Futures	82.502	83.075	82.354	82.594	5249.0
2009-07-06	E1	Futures	1.21815	1.22239	1.20928	1.21974	40943.0
2009-07-06	E6	Futures	1.65731	1.6617	1.64722	1.65719	227638.0
2009-07-06	E7	Futures	1.6402	1.6448	1.6304	1.6402	2211.0
2009-07-06	ED	Futures	93.8669	93.8858	93.8575	93.8669	135390.0
2009-07-06	ER	Futures	96.988	97.017	96.988	97.002	95480.0
2009-07-06	EW	Futures	546.5	546.5	533.8	542.9	24583.0
2009-07-06	FCE	Futures	2024.8	2026.8	1995.5	2011.5	108882.0
2009-07-06	FDAX	Futures	5122.1	5149.6	5057.4	5115.0	138156.0
2009-07-06	FESX	Futures	1404.0	1406.9	1383.7	1398.0	959297.0
2009-07-06	FEU3	Futures	97.584	97.584	97.579	97.579	106.0
2009-07-06	FGBL	Futures	92.49	92.73	92.43	92.7	426470.0
2009-07-06	FGBM	Futures	98.35	98.48	98.31	98.47	249937.0
2009-07-06	FGBS	Futures	104.205	104.273	104.196	104.244	307487.0
2009-07-06	FGBX	Futures	84.18	84.53	84.17	84.36	1592.0
2009-07-06	FTDX	Futures	549.6	550.5	539.8	544.3	705.0
2009-07-06	FTI	Futures	204.56	204.92	201.35	202.61	25188.0
2009-07-06	FTUK	Futures	2768.5	2787.0	2745.2	2765.1	88495.0
2009-07-06	G	Futures	75.63	76.08	75.63	75.92	69657.0
2009-07-06	GF	Futures	285.622	287.758	285.277	286.104	2676.0
2009-07-06	GSCI	Futures	879.76	885.6	874.54	878.09	553.0
2009-07-06	HE	Futures	88.094	90.397	87.554	89.317	11991.0
2009-07-06	HG	Futures	3.1881	3.1909	3.0968	3.1768	16050.0
2009-07-06	HO	Futures	1.7255	1.7376	1.6899	1.6953	12522.0
2009-07-06	HRC	Futures	2382.2	2382.2	2382.2	2382.2	0.0
2009-07-06	J1	Futures	0.0131129	0.0133118	0.0131129	0.0132312	120083.0
2009-07-06	J7	Futures	0.013014	0.013121	0.012998	0.013049	249.0
2009-07-06	JB	Futures	116.57	116.73	116.52	116.71	828.0
2009-07-06	KC	Futures	319.91	326.15	316.52	320.45	7293.0
2009-07-06	KE	Futures	2705.14	2712.34	2642.79	2642.79	11055.0
2009-07-06	L	Futures	97.2	97.229	97.2	97.209	31772.0
2009-07-06	LBS	Futures	858.8	879.8	839.7	842.9	186.0
2009-07-06	LE	Futures	149.576	150.458	148.299	148.783	11755.0

> showing 50 of 85 rows — these rows as CSV

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