PREVIEW / futures_daily / 2011-06-29

all futures daily files

  file:    by_date/futures_daily/2011/2011-06-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-06-29	ES	Futures	1284.62	1296.54	1282.63	1295.3	2489063.0
2011-06-29	NQ	Futures	2599.78	2619.71	2590.39	2612.31	237750.0
2011-06-29	YM	Futures	11472.5	11555.7	11446.0	11551.0	124529.0
2011-06-29	CL	Futures	179.16	183.9	177.8	181.84	348790.0
2011-06-29	GC	Futures	2033.5	2048.8	2031.2	2044.2	101480.0
2011-06-29	ZN	Futures	105.109282	105.202417	104.390813	104.603693	1726586.0
2011-06-29	A6	Futures	0.90682	0.92013	0.90569	0.919	141211.0
2011-06-29	AD	Futures	1.01523	1.028	1.01373	1.0261	124442.0
2011-06-29	B	Futures	92.62	96.03	92.15	95.81	101360.0
2011-06-29	B6	Futures	1.6624	1.6706	1.6597	1.6684	116738.0
2011-06-29	BFX	Futures	3018.4	3018.4	3018.4	3018.4	1.0
2011-06-29	BR	Futures	0.27907	0.27907	0.27907	0.27907	93.0
2011-06-29	BZ	Futures	95.57	99.56	95.56	99.51	678.0
2011-06-29	C	Futures	2086.0	2109.0	2072.0	2104.0	2734.0
2011-06-29	CB	Futures	111.231	112.874	111.231	112.326	5.0
2011-06-29	CC	Futures	2420.0	2477.0	2415.0	2473.0	13036.0
2011-06-29	CSC	Futures	4.595	4.595	4.595	4.595	1.0
2011-06-29	CT	Futures	165.29	169.22	164.97	165.12	33.0
2011-06-29	DC	Futures	31.07	31.4	31.03	31.13	251.0
2011-06-29	DX	Futures	74.752	74.811	74.271	74.35	35825.0
2011-06-29	E1	Futures	1.57282	1.57714	1.56367	1.56785	46935.0
2011-06-29	E6	Futures	1.7029	1.71217	1.69744	1.70955	344987.0
2011-06-29	E7	Futures	1.6907	1.6998	1.685	1.6971	6022.0
2011-06-29	ED	Futures	94.9049	94.943	94.9001	94.9382	373930.0
2011-06-29	ER	Futures	97.306	97.316	97.276	97.296	177330.0
2011-06-29	EW	Futures	955.6	964.8	952.6	962.4	22374.0
2011-06-29	FBTP	Futures	64.24	64.59	64.24	64.43	9257.0
2011-06-29	FCE	Futures	2684.7	2734.4	2682.9	2723.6	155540.0
2011-06-29	FDAX	Futures	7718.9	7848.2	7718.4	7824.2	155464.0
2011-06-29	FESX	Futures	1772.9	1808.1	1771.6	1798.5	1843453.0
2011-06-29	FEU3	Futures	97.84	97.84	97.835	97.835	2.0
2011-06-29	FGBL	Futures	101.29	101.34	100.76	101.0	1311898.0
2011-06-29	FGBM	Futures	105.51	105.55	105.03	105.22	876778.0
2011-06-29	FGBS	Futures	107.239	107.254	107.04	107.099	831935.0
2011-06-29	FGBX	Futures	95.01	95.21	94.22	94.53	9598.0
2011-06-29	FTDX	Futures	772.5	790.4	771.6	789.5	521.0
2011-06-29	FTI	Futures	272.0	275.9	271.51	275.33	43744.0
2011-06-29	FTUK	Futures	4064.8	4121.9	4058.8	4111.4	108211.0
2011-06-29	FXXP	Futures	180.6	182.7	180.4	182.6	3482.0
2011-06-29	G	Futures	84.65	84.65	84.07	84.3	193396.0
2011-06-29	GF	Futures	320.948	320.948	317.462	320.193	2294.0
2011-06-29	GSCI	Futures	1036.37	1061.92	1036.37	1058.45	235.0
2011-06-29	HE	Futures	100.238	101.998	99.838	101.598	5515.0
2011-06-29	HG	Futures	5.4398	5.5971	5.4365	5.5839	51547.0
2011-06-29	HO	Futures	2.3176	2.3999	2.3076	2.3909	15469.0
2011-06-29	HRC	Futures	3031.0	3031.0	3031.0	3031.0	10.0
2011-06-29	J1	Futures	0.0155153	0.0156234	0.0154889	0.0155443	107221.0
2011-06-29	J7	Futures	0.015403	0.015513	0.015385	0.01544	312.0
2011-06-29	JB	Futures	123.28	123.29	122.95	123.07	38.0
2011-06-29	KC	Futures	611.55	621.96	596.17	616.75	12059.0

> showing 50 of 96 rows — these rows as CSV

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