PREVIEW / futures_daily / 2011-09-28

all futures daily files

  file:    by_date/futures_daily/2011/2011-09-28.parquet
  size:    9 KB
  rows:    95

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-28	ES	Futures	1166.95	1179.68	1141.5	1146.74	2802438.0
2011-09-28	NQ	Futures	2570.85	2597.67	2524.9	2532.32	325688.0
2011-09-28	YM	Futures	10682.5	10799.7	10489.4	10544.2	155589.0
2011-09-28	CL	Futures	157.94	159.56	151.77	153.13	282850.0
2011-09-28	GC	Futures	2231.9	2257.5	2160.9	2184.7	218351.0
2011-09-28	ZN	Futures	111.442346	111.63005	110.865828	111.26805	1311012.0
2011-09-28	A6	Futures	0.86258	0.86698	0.85124	0.85537	138438.0
2011-09-28	AD	Futures	0.97954	0.97964	0.96613	0.97074	105439.0
2011-09-28	B	Futures	91.95	92.67	89.19	89.67	157318.0
2011-09-28	B6	Futures	1.6307	1.6351	1.6233	1.627	99637.0
2011-09-28	BFX	Futures	2573.9	2574.5	2573.6	2574.5	10.0
2011-09-28	BR	Futures	0.2478	0.2478	0.24139	0.24433	23.0
2011-09-28	BZ	Futures	96.85	97.82	94.38	94.77	811.0
2011-09-28	C	Futures	1844.0	1850.0	1815.0	1831.0	14761.0
2011-09-28	CB	Futures	93.286	93.286	93.286	93.286	1.0
2011-09-28	CC	Futures	2123.0	2123.0	2062.0	2089.0	9276.0
2011-09-28	CSC	Futures	4.093	4.093	4.056	4.056	23.0
2011-09-28	CT	Futures	129.1	130.21	127.84	128.32	6907.0
2011-09-28	DC	Futures	28.24	28.36	27.84	27.92	312.0
2011-09-28	DX	Futures	76.888	77.222	76.412	76.995	32957.0
2011-09-28	E1	Futures	1.46488	1.47275	1.46002	1.46462	18717.0
2011-09-28	E6	Futures	1.62334	1.63553	1.61652	1.62202	307418.0
2011-09-28	E7	Futures	1.6092	1.6214	1.6027	1.6082	5130.0
2011-09-28	ED	Futures	94.9936	94.9984	94.9746	94.9841	162298.0
2011-09-28	ER	Futures	97.406	97.435	97.307	97.317	291649.0
2011-09-28	EW	Futures	825.4	835.6	795.2	798.8	40423.0
2011-09-28	FBTP	Futures	61.61	62.01	61.56	61.73	5380.0
2011-09-28	FBTS	Futures	81.807	81.855	81.687	81.751	1301.0
2011-09-28	FCE	Futures	2121.3	2184.9	2106.7	2139.2	135334.0
2011-09-28	FDAX	Futures	6037.7	6201.6	5967.6	6071.3	194086.0
2011-09-28	FESX	Futures	1427.4	1471.3	1418.1	1440.1	1516154.0
2011-09-28	FEU3	Futures	97.89	97.89	97.876	97.876	8.0
2011-09-28	FGBL	Futures	110.14	110.27	109.23	109.76	1046082.0
2011-09-28	FGBM	Futures	110.52	110.65	110.04	110.31	610980.0
2011-09-28	FGBS	Futures	109.024	109.084	108.84	108.94	700273.0
2011-09-28	FGBX	Futures	112.56	112.67	110.97	111.81	5679.0
2011-09-28	FTDX	Futures	625.6	639.4	624.7	628.8	357.0
2011-09-28	FTI	Futures	230.47	235.58	228.23	231.34	48732.0
2011-09-28	FTUK	Futures	3742.4	3797.3	3674.6	3730.2	126051.0
2011-09-28	FVSA	Futures	17560.76	18406.04	17518.49	18258.12	4043.0
2011-09-28	FXXP	Futures	158.9	160.5	157.0	157.9	2075.0
2011-09-28	G	Futures	91.47	91.74	91.07	91.4	164139.0
2011-09-28	GF	Futures	315.397	317.492	314.888	316.133	2279.0
2011-09-28	GSCI	Futures	977.59	977.59	948.6	952.48	230.0
2011-09-28	HE	Futures	107.169	108.166	105.241	107.298	18085.0
2011-09-28	HG	Futures	4.5276	4.5316	4.1882	4.296	63305.0
2011-09-28	HO	Futures	2.3186	2.329	2.2679	2.2727	27840.0
2011-09-28	HRC	Futures	2706.8	2706.8	2706.8	2706.8	0.0
2011-09-28	J1	Futures	0.0163851	0.0164768	0.0163612	0.0164366	86545.0
2011-09-28	J7	Futures	0.016288	0.016378	0.016264	0.016337	399.0

> showing 50 of 95 rows — these rows as CSV

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