PREVIEW / futures_daily / 2012-07-03

all futures daily files

  file:    by_date/futures_daily/2012/2012-07-03.parquet
  size:    9 KB
  rows:    99

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
2012-07-03	ES	Futures	1375.53	1386.92	1372.49	1385.4	1047073.0
2012-07-03	NQ	Futures	3001.4	3032.96	2999.68	3031.82	105725.0
2012-07-03	YM	Futures	12398.8	12492.9	12369.7	12483.2	62503.0
2012-07-03	CL	Futures	152.59	160.56	151.97	159.87	336186.0
2012-07-03	GC	Futures	2135.5	2173.2	2132.6	2168.0	112150.0
2012-07-03	ZN	Futures	116.740268	116.821981	116.427036	116.481511	537872.0
2012-07-03	A6	Futures	0.91564	0.91933	0.91348	0.91852	82503.0
2012-07-03	AD	Futures	0.98446	0.98907	0.98386	0.98817	63708.0
2012-07-03	B	Futures	87.14	91.0	87.05	90.26	197758.0
2012-07-03	B6	Futures	1.6398	1.642	1.6363	1.6401	74423.0
2012-07-03	BFX	Futures	2714.1	2719.5	2706.8	2718.3	65.0
2012-07-03	BR	Futures	0.23807	0.23847	0.2342	0.23651	80.0
2012-07-03	BZ	Futures	95.29	97.43	95.29	96.71	884.0
2012-07-03	C	Futures	1631.0	1658.0	1622.0	1650.0	2297.0
2012-07-03	CB	Futures	83.964	83.964	83.829	83.829	6.0
2012-07-03	CC	Futures	1730.0	1777.0	1730.0	1771.0	15903.0
2012-07-03	CSC	Futures	3.806	3.814	3.797	3.814	5.0
2012-07-03	CT	Futures	95.41	96.08	94.85	96.03	95.0
2012-07-03	DC	Futures	27.93	27.99	27.79	27.96	51.0
2012-07-03	DX	Futures	79.615	79.731	79.411	79.466	14993.0
2012-07-03	E1	Futures	1.3552	1.35998	1.35262	1.35856	21742.0
2012-07-03	E6	Futures	1.48583	1.4909	1.48276	1.4889	184384.0
2012-07-03	E7	Futures	1.4766	1.4815	1.4737	1.4796	2415.0
2012-07-03	ED	Futures	95.1083	95.1178	95.1083	95.1131	103504.0
2012-07-03	ER	Futures	97.621	97.646	97.616	97.636	136744.0
2012-07-03	EW	Futures	956.2	971.2	955.8	970.8	16105.0
2012-07-03	FBTP	Futures	66.61	66.9	66.19	66.81	13226.0
2012-07-03	FBTS	Futures	85.418	85.923	85.352	85.79	2735.0
2012-07-03	FCE	Futures	2409.8	2426.8	2399.8	2420.9	95300.0
2012-07-03	FDAX	Futures	7120.6	7202.5	7104.8	7180.6	111937.0
2012-07-03	FESX	Futures	1553.5	1570.4	1548.1	1563.6	1063267.0
2012-07-03	FEU3	Futures	98.206	98.216	98.206	98.216	200.0
2012-07-03	FGBL	Futures	116.93	117.07	116.67	116.84	526839.0
2012-07-03	FGBM	Futures	115.29	115.4	115.18	115.31	379327.0
2012-07-03	FGBS	Futures	110.198	110.248	110.183	110.213	222635.0
2012-07-03	FGBX	Futures	123.71	123.71	121.51	122.56	17157.0
2012-07-03	FOAT	Futures	98.8	99.19	98.8	99.1	13142.0
2012-07-03	FTDX	Futures	705.4	714.2	704.9	712.8	133.0
2012-07-03	FTI	Futures	265.34	268.02	264.28	267.43	27972.0
2012-07-03	FTUK	Futures	4080.6	4120.3	4071.9	4110.1	72850.0
2012-07-03	FVSA	Futures	7491.59	7491.59	7265.49	7265.49	1617.0
2012-07-03	FXXP	Futures	182.3	183.9	182.3	183.6	2407.0
2012-07-03	G	Futures	98.88	98.88	98.21	98.38	145300.0
2012-07-03	GF	Futures	295.052	295.052	290.71	290.908	4617.0
2012-07-03	GSCI	Futures	967.62	979.26	967.62	977.99	339.0
2012-07-03	HE	Futures	101.019	101.607	100.779	101.42	13911.0
2012-07-03	HG	Futures	4.4665	4.5818	4.4613	4.5605	53751.0
2012-07-03	HO	Futures	2.1883	2.2594	2.1883	2.2568	25878.0
2012-07-03	HRC	Futures	2450.1	2450.1	2429.9	2450.1	5.0
2012-07-03	J1	Futures	0.0157777	0.0157977	0.0156937	0.0157075	51772.0

> showing 50 of 99 rows — these rows as CSV

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