PREVIEW / futures_daily / 2011-09-02

all futures daily files

  file:    by_date/futures_daily/2011/2011-09-02.parquet
  size:    9 KB
  rows:    96

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
2011-09-02	ES	Futures	1192.75	1194.99	1160.48	1161.22	2427798.0
2011-09-02	NQ	Futures	2524.63	2530.04	2454.88	2465.13	271645.0
2011-09-02	YM	Futures	10841.9	10889.2	10587.6	10596.1	119450.0
2011-09-02	CL	Futures	169.11	169.51	162.71	164.67	307284.0
2011-09-02	GC	Futures	2468.0	2548.3	2466.6	2534.1	180277.0
2011-09-02	ZN	Futures	111.256179	111.841598	111.003385	111.801683	134286.0
2011-09-02	A6	Futures	0.93101	0.93196	0.92257	0.9237	103149.0
2011-09-02	AD	Futures	1.02191	1.02261	1.01313	1.01343	80677.0
2011-09-02	B	Futures	97.41	97.59	94.84	95.53	124282.0
2011-09-02	B6	Futures	1.6833	1.6907	1.682	1.6858	70866.0
2011-09-02	BFX	Futures	2706.5	2706.5	2670.1	2670.1	4.0
2011-09-02	BR	Futures	0.27355	0.27355	0.2703	0.27034	392.0
2011-09-02	BZ	Futures	100.17	100.26	98.29	98.95	1258.0
2011-09-02	C	Futures	2096.0	2100.0	2068.0	2089.0	1129.0
2011-09-02	CC	Futures	2418.0	2450.0	2406.0	2429.0	7707.0
2011-09-02	CSC	Futures	4.434	4.434	4.434	4.434	4.0
2011-09-02	CT	Futures	138.86	138.86	137.34	138.33	37.0
2011-09-02	DC	Futures	30.46	30.6	30.4	30.6	168.0
2011-09-02	DX	Futures	73.87	74.138	73.628	74.117	24485.0
2011-09-02	E1	Futures	1.64645	1.69733	1.64384	1.65966	37969.0
2011-09-02	E6	Futures	1.69352	1.69685	1.68414	1.68461	262475.0
2011-09-02	E7	Futures	1.6812	1.6842	1.672	1.6723	3398.0
2011-09-02	ED	Futures	94.9311	94.9382	94.912	94.9239	211022.0
2011-09-02	ER	Futures	97.499	97.524	97.489	97.514	132427.0
2011-09-02	EW	Futures	851.8	852.7	821.5	822.5	37086.0
2011-09-02	FBTP	Futures	64.03	64.15	63.4	63.51	7989.0
2011-09-02	FCE	Futures	2253.1	2265.3	2186.0	2207.8	101139.0
2011-09-02	FDAX	Futures	6024.8	6037.1	5869.3	5921.1	164566.0
2011-09-02	FESX	Futures	1452.8	1458.6	1408.5	1422.6	1400259.0
2011-09-02	FEU3	Futures	98.049	98.059	98.044	98.054	13.0
2011-09-02	FGBL	Futures	108.72	109.88	108.71	109.61	964829.0
2011-09-02	FGBM	Futures	110.07	110.73	110.07	110.56	616721.0
2011-09-02	FGBS	Futures	108.959	109.188	108.954	109.109	712303.0
2011-09-02	FGBX	Futures	106.61	108.27	106.4	107.86	7136.0
2011-09-02	FTDX	Futures	660.0	662.7	643.5	649.3	329.0
2011-09-02	FTI	Futures	236.91	237.72	231.77	233.68	37459.0
2011-09-02	FTUK	Futures	3768.5	3787.9	3694.4	3726.5	115730.0
2011-09-02	FVSA	Futures	13777.26	14669.88	13777.26	14437.02	2913.0
2011-09-02	FXXP	Futures	160.0	160.0	156.6	157.3	1495.0
2011-09-02	G	Futures	90.05	90.79	90.01	90.62	139171.0
2011-09-02	GF	Futures	304.18	305.783	302.578	303.722	613.0
2011-09-02	GSCI	Futures	1033.07	1043.88	1027.51	1037.69	187.0
2011-09-02	HE	Futures	103.756	105.313	103.267	104.794	14355.0
2011-09-02	HG	Futures	5.4817	5.5068	5.4122	5.4579	27572.0
2011-09-02	HO	Futures	2.4706	2.4714	2.4095	2.4212	14516.0
2011-09-02	HRC	Futures	2910.3	2910.3	2910.3	2910.3	0.0
2011-09-02	J1	Futures	0.0163424	0.0164253	0.0163311	0.0163801	75883.0
2011-09-02	J7	Futures	0.016243	0.016316	0.016223	0.016271	298.0
2011-09-02	JB	Futures	123.81	123.96	123.77	123.95	5727.0
2011-09-02	KC	Futures	681.02	684.43	670.88	678.78	9627.0

> showing 50 of 96 rows — these rows as CSV

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