PREVIEW / futures_daily / 2009-06-16

all futures daily files

  file:    by_date/futures_daily/2009/2009-06-16.parquet
  size:    8 KB
  rows:    86

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-06-16	ES	Futures	882.45	887.24	869.73	870.93	2267554.0
2009-06-16	NQ	Futures	1640.54	1653.49	1623.08	1626.46	316703.0
2009-06-16	YM	Futures	7726.9	7762.1	7618.6	7632.1	125638.0
2009-06-16	CL	Futures	186.81	193.18	185.52	187.23	116773.0
2009-06-16	GC	Futures	1285.9	1302.2	1284.4	1290.6	76594.0
2009-06-16	ZN	Futures	90.424075	90.855018	90.067008	90.68264	708024.0
2009-06-16	A6	Futures	0.63446	0.64419	0.62723	0.63551	59240.0
2009-06-16	AD	Futures	0.87264	0.88064	0.8685	0.87077	49126.0
2009-06-16	B	Futures	66.85	69.26	66.53	67.19	104121.0
2009-06-16	B6	Futures	1.6979	1.7194	1.6884	1.7116	94313.0
2009-06-16	BFX	Futures	2284.6	2297.5	2255.7	2279.2	905.0
2009-06-16	BR	Futures	0.19617	0.19617	0.19617	0.19617	5.0
2009-06-16	BZ	Futures	75.26	75.51	73.32	73.32	25.0
2009-06-16	C	Futures	1827.0	1827.0	1799.0	1804.0	1975.0
2009-06-16	CB	Futures	73.61	73.61	72.9	73.042	6.0
2009-06-16	CC	Futures	2371.0	2396.0	2355.0	2362.0	7072.0
2009-06-16	CT	Futures	49.11	49.93	48.38	48.51	14515.0
2009-06-16	DC	Futures	21.84	21.98	21.61	21.65	221.0
2009-06-16	DX	Futures	83.495	83.72	82.605	83.04	4555.0
2009-06-16	E1	Futures	1.21312	1.22477	1.20928	1.21762	36791.0
2009-06-16	E6	Futures	1.63547	1.65268	1.6306	1.64223	198960.0
2009-06-16	E7	Futures	1.619	1.6357	1.6141	1.6254	3478.0
2009-06-16	ED	Futures	93.73	93.7441	93.6969	93.7253	202973.0
2009-06-16	ER	Futures	96.777	96.792	96.748	96.777	128426.0
2009-06-16	EW	Futures	562.3	576.1	549.3	550.9	42212.0
2009-06-16	FCE	Futures	2100.9	2117.8	2070.5	2096.6	148821.0
2009-06-16	FDAX	Futures	5325.8	5374.2	5275.7	5337.2	161856.0
2009-06-16	FESX	Futures	1448.1	1459.5	1426.0	1445.1	1153860.0
2009-06-16	FEU3	Futures	97.347	97.352	97.337	97.352	2416.0
2009-06-16	FGBL	Futures	90.88	90.97	90.65	90.74	642709.0
2009-06-16	FGBM	Futures	96.89	97.03	96.76	96.89	306661.0
2009-06-16	FGBS	Futures	103.468	103.536	103.415	103.497	508119.0
2009-06-16	FGBX	Futures	81.94	82.08	81.41	81.47	903.0
2009-06-16	FTDX	Futures	557.7	561.2	549.6	560.3	3674.0
2009-06-16	FTI	Futures	210.98	211.31	207.69	208.75	17579.0
2009-06-16	FTUK	Futures	2860.7	2881.0	2821.9	2855.1	213516.0
2009-06-16	G	Futures	74.6	74.88	74.38	74.44	120234.0
2009-06-16	GF	Futures	267.568	270.118	264.467	266.121	793.0
2009-06-16	GSCI	Futures	985.74	992.31	960.08	966.34	362.0
2009-06-16	HE	Futures	85.243	86.12	84.95	85.206	4928.0
2009-06-16	HG	Futures	3.2232	3.2598	3.1416	3.1733	18733.0
2009-06-16	HO	Futures	1.921	1.9735	1.9014	1.9201	6295.0
2009-06-16	HRC	Futures	2495.0	2495.0	2291.7	2291.7	10.0
2009-06-16	J1	Futures	0.0128825	0.0131154	0.0128774	0.0130537	101333.0
2009-06-16	J7	Futures	0.012705	0.012929	0.012705	0.012874	114.0
2009-06-16	JB	Futures	114.76	115.03	114.71	114.9	1805.0
2009-06-16	KC	Futures	338.32	342.06	336.66	339.15	7406.0
2009-06-16	KE	Futures	3083.92	3110.74	3027.85	3037.6	9636.0
2009-06-16	L	Futures	97.003	97.023	96.974	97.013	58349.0
2009-06-16	LBS	Futures	928.7	972.9	928.7	972.9	376.0

> showing 50 of 86 rows — these rows as CSV

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