PREVIEW / futures_daily / 2014-08-27

all futures daily files

  file:    by_date/futures_daily/2014/2014-08-27.parquet
  size:    9 KB
  rows:    104

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
2014-08-27	ES	Futures	2076.81	2078.11	2070.84	2074.48	761368.0
2014-08-27	NQ	Futures	4699.92	4703.96	4688.38	4699.05	128378.0
2014-08-27	YM	Futures	17260.7	17272.8	17225.4	17246.6	71942.0
2014-08-27	CL	Futures	174.87	175.54	173.9	174.87	174908.0
2014-08-27	GC	Futures	1681.0	1689.7	1680.1	1683.4	67240.0
2014-08-27	ZN	Futures	117.64449	117.936267	117.615312	117.863322	2309338.0
2014-08-27	A6	Futures	0.89837	0.90262	0.89818	0.90156	71318.0
2014-08-27	AD	Futures	0.92677	0.93754	0.92657	0.93652	98168.0
2014-08-27	ALI	Futures	3050.01	3050.01	3050.01	3050.01	22.0
2014-08-27	B	Futures	107.91	108.42	107.43	108.1	77071.0
2014-08-27	B6	Futures	1.7387	1.7455	1.7382	1.7429	85079.0
2014-08-27	BFX	Futures	3890.4	3890.4	3885.4	3885.4	11.0
2014-08-27	BR	Futures	0.23337	0.23459	0.23235	0.2328	2493.0
2014-08-27	BZ	Futures	108.86	109.16	108.19	108.86	12895.0
2014-08-27	C	Futures	2178.0	2196.0	2150.0	2160.0	3599.0
2014-08-27	CB	Futures	142.593	144.134	141.822	144.115	14.0
2014-08-27	CC	Futures	2384.0	2436.0	2356.0	2370.0	11710.0
2014-08-27	CNH	Futures	7.0512	7.0512	7.0464	7.0464	2.0
2014-08-27	CT	Futures	86.11	86.39	85.38	86.16	10.0
2014-08-27	DC	Futures	41.57	41.57	41.16	41.36	123.0
2014-08-27	DX	Futures	78.492	78.553	78.24	78.263	19537.0
2014-08-27	E1	Futures	1.39725	1.40302	1.39584	1.40161	47424.0
2014-08-27	E6	Futures	1.55409	1.55893	1.55197	1.55716	190234.0
2014-08-27	E7	Futures	1.5438	1.5486	1.5421	1.547	2584.0
2014-08-27	ED	Futures	95.4139	95.4162	95.4115	95.4139	64598.0
2014-08-27	ER	Futures	97.945	97.95	97.935	97.94	68503.0
2014-08-27	EW	Futures	1491.0	1492.4	1485.0	1487.7	6302.0
2014-08-27	FBTP	Futures	94.93	95.26	94.82	95.04	84021.0
2014-08-27	FBTS	Futures	98.917	98.943	98.819	98.872	12775.0
2014-08-27	FCE	Futures	3493.4	3505.4	3486.6	3500.2	62600.0
2014-08-27	FDAX	Futures	10558.2	10573.7	10512.0	10539.5	65280.0
2014-08-27	FESX	Futures	2295.8	2303.7	2287.9	2296.5	687374.0
2014-08-27	FEU3	Futures	98.567	98.567	98.562	98.562	1.0
2014-08-27	FGBL	Futures	131.3	131.71	131.25	131.56	671951.0
2014-08-27	FGBM	Futures	122.41	122.56	122.39	122.5	429731.0
2014-08-27	FGBS	Futures	110.878	110.888	110.853	110.858	223203.0
2014-08-27	FGBX	Futures	142.72	143.47	142.46	143.25	25955.0
2014-08-27	FMWO	Futures	5821.7	5823.0	5812.9	5820.4	324.0
2014-08-27	FOAT	Futures	121.57	122.04	121.54	121.86	57180.0
2014-08-27	FTDX	Futures	1171.1	1179.0	1161.7	1175.7	1422.0
2014-08-27	FTI	Futures	355.48	356.39	354.79	355.96	17825.0
2014-08-27	FTUK	Futures	5238.8	5252.3	5237.7	5248.8	52812.0
2014-08-27	FVSA	Futures	1412.28	1416.56	1403.72	1408.0	6343.0
2014-08-27	FXXP	Futures	258.2	259.2	258.0	258.6	5676.0
2014-08-27	G	Futures	96.69	97.38	96.63	97.33	215140.0
2014-08-27	GF	Futures	331.984	332.915	329.735	332.721	1895.0
2014-08-27	GSCI	Futures	1015.85	1016.69	1010.66	1014.18	89.0
2014-08-27	HE	Futures	114.79	117.48	114.367	115.969	21832.0
2014-08-27	HG	Futures	4.0729	4.0786	4.0411	4.057	29261.0
2014-08-27	HH	Futures	49.127	49.127	49.004	49.041	827.0

> showing 50 of 104 rows — these rows as CSV

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