PREVIEW / futures_daily / 2011-07-29

all futures daily files

  file:    by_date/futures_daily/2011/2011-07-29.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-07-29	ES	Futures	1288.84	1291.82	1269.72	1279.65	2889931.0
2011-07-29	NQ	Futures	2699.71	2716.22	2662.42	2686.61	335802.0
2011-07-29	YM	Futures	11534.9	11544.3	11372.3	11428.1	148538.0
2011-07-29	CL	Futures	186.2	186.64	181.97	183.4	284385.0
2011-07-29	GC	Futures	2186.6	2210.9	2177.8	2202.4	153054.0
2011-07-29	ZN	Futures	106.04063	107.238078	105.90758	107.025198	1521613.0
2011-07-29	A6	Futures	0.95119	0.95267	0.9431	0.95084	125203.0
2011-07-29	AD	Futures	1.05036	1.05086	1.03948	1.04357	107755.0
2011-07-29	B	Futures	100.29	100.54	98.84	99.68	74984.0
2011-07-29	B6	Futures	1.7021	1.7127	1.6905	1.7084	115279.0
2011-07-29	BFX	Futures	2927.1	2939.2	2925.4	2925.4	21.0
2011-07-29	BR	Futures	0.28129	0.28606	0.28085	0.28497	180.0
2011-07-29	BZ	Futures	102.95	102.95	102.95	102.95	508.0
2011-07-29	C	Futures	2021.0	2027.0	1997.0	2005.0	5754.0
2011-07-29	CB	Futures	113.97	114.518	113.97	114.518	6.0
2011-07-29	CC	Futures	2356.0	2381.0	2343.0	2358.0	8313.0
2011-07-29	CSC	Futures	5.012	5.012	5.012	5.012	2.0
2011-07-29	CT	Futures	133.86	134.16	128.23	132.47	99.0
2011-07-29	DC	Futures	34.54	34.64	34.26	34.34	219.0
2011-07-29	DX	Futures	73.613	73.964	73.147	73.322	28758.0
2011-07-29	E1	Futures	1.63351	1.66699	1.62893	1.65862	70900.0
2011-07-29	E6	Futures	1.69934	1.71003	1.68794	1.70409	360049.0
2011-07-29	E7	Futures	1.688	1.6974	1.6757	1.6916	5721.0
2011-07-29	ED	Futures	94.9334	94.9334	94.9144	94.9287	266547.0
2011-07-29	ER	Futures	97.366	97.395	97.366	97.385	84256.0
2011-07-29	EW	Futures	936.2	939.0	917.8	933.2	34097.0
2011-07-29	FBTP	Futures	60.11	60.24	59.59	60.1	8578.0
2011-07-29	FCE	Futures	2573.1	2604.5	2554.4	2589.7	152170.0
2011-07-29	FDAX	Futures	7576.3	7700.2	7563.4	7673.0	152894.0
2011-07-29	FESX	Futures	1695.9	1722.8	1687.5	1715.1	1584664.0
2011-07-29	FEU3	Futures	97.91	97.925	97.91	97.925	102.0
2011-07-29	FGBL	Futures	104.17	104.85	104.01	104.58	1022585.0
2011-07-29	FGBM	Futures	107.24	107.67	107.11	107.53	515977.0
2011-07-29	FGBS	Futures	107.776	107.895	107.726	107.85	584957.0
2011-07-29	FGBX	Futures	100.54	101.76	100.19	101.3	3758.0
2011-07-29	FTDX	Futures	727.9	735.9	723.0	732.8	566.0
2011-07-29	FTI	Futures	270.63	273.2	268.85	271.5	46102.0
2011-07-29	FTUK	Futures	4088.8	4102.9	4045.0	4080.7	147245.0
2011-07-29	FXXP	Futures	178.9	180.2	177.5	179.4	1521.0
2011-07-29	G	Futures	86.92	87.46	86.79	87.37	132365.0
2011-07-29	GF	Futures	316.067	320.715	314.324	318.508	2534.0
2011-07-29	GSCI	Futures	1099.41	1102.3	1092.21	1099.57	509.0
2011-07-29	HE	Futures	112.891	113.277	111.845	113.222	5181.0
2011-07-29	HG	Futures	5.9184	5.9514	5.8318	5.9217	39530.0
2011-07-29	HO	Futures	2.5198	2.5244	2.4895	2.5093	65483.0
2011-07-29	HRC	Futures	2933.1	2933.1	2933.1	2933.1	50.0
2011-07-29	J1	Futures	0.0161853	0.0163939	0.0161463	0.0163173	129947.0
2011-07-29	J7	Futures	0.016081	0.016277	0.016041	0.016208	600.0
2011-07-29	JB	Futures	123.44	123.53	123.24	123.46	62.0
2011-07-29	KC	Futures	564.59	573.46	563.76	566.72	9261.0

> showing 50 of 96 rows — these rows as CSV

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