PREVIEW / futures_daily / 2012-08-02

all futures daily files

  file:    by_date/futures_daily/2012/2012-08-02.parquet
  size:    9 KB
  rows:    98

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-08-02	ES	Futures	1387.43	1400.59	1366.41	1379.32	2835526.0
2012-08-02	NQ	Futures	3013.17	3040.14	2984.18	3005.42	303243.0
2012-08-02	YM	Futures	12531.8	12641.4	12341.6	12448.3	161519.0
2012-08-02	CL	Futures	161.29	162.67	157.76	158.14	302698.0
2012-08-02	GC	Futures	2140.0	2161.3	2117.9	2123.8	158560.0
2012-08-02	ZN	Futures	117.012644	117.598252	116.72665	117.339495	1192001.0
2012-08-02	A6	Futures	0.93668	0.94783	0.93479	0.93596	212278.0
2012-08-02	AD	Futures	0.99629	1.0015	0.99318	0.99378	146483.0
2012-08-02	B	Futures	94.68	96.06	93.98	94.78	178474.0
2012-08-02	B6	Futures	1.6241	1.6389	1.6187	1.62	180390.0
2012-08-02	BFX	Futures	2744.7	2744.7	2686.3	2691.6	60.0
2012-08-02	BR	Futures	0.23291	0.23336	0.23133	0.23174	340.0
2012-08-02	BZ	Futures	100.65	101.05	99.88	99.88	3026.0
2012-08-02	C	Futures	1680.0	1690.0	1665.0	1678.0	7332.0
2012-08-02	CB	Futures	89.615	89.615	89.615	89.615	5.0
2012-08-02	CC	Futures	1796.0	1811.0	1776.0	1785.0	17606.0
2012-08-02	CT	Futures	92.36	92.83	92.03	92.79	26.0
2012-08-02	DC	Futures	29.33	29.45	29.14	29.23	89.0
2012-08-02	DX	Futures	80.726	81.153	79.809	80.999	37917.0
2012-08-02	E1	Futures	1.31556	1.3348	1.30562	1.30949	85782.0
2012-08-02	E6	Futures	1.44337	1.46424	1.43204	1.43676	478120.0
2012-08-02	E7	Futures	1.4345	1.4551	1.423	1.4278	9032.0
2012-08-02	ED	Futures	95.1943	95.1991	95.1847	95.1895	157521.0
2012-08-02	ER	Futures	97.827	97.837	97.793	97.803	233282.0
2012-08-02	EW	Futures	941.9	950.5	929.6	938.0	33094.0
2012-08-02	FBTP	Futures	65.93	67.07	63.67	64.24	48387.0
2012-08-02	FBTS	Futures	85.385	86.146	85.129	85.427	8140.0
2012-08-02	FCE	Futures	2474.9	2514.4	2386.3	2407.2	233866.0
2012-08-02	FDAX	Futures	7387.5	7494.0	7153.3	7219.9	216781.0
2012-08-02	FESX	Futures	1579.9	1609.6	1517.0	1532.5	1968305.0
2012-08-02	FEU3	Futures	98.413	98.413	98.384	98.384	150.0
2012-08-02	FGBL	Futures	118.49	119.91	117.97	119.67	920835.0
2012-08-02	FGBM	Futures	116.32	116.91	116.09	116.82	529693.0
2012-08-02	FGBS	Futures	110.522	110.627	110.497	110.582	406092.0
2012-08-02	FGBX	Futures	126.49	130.25	126.13	129.57	10534.0
2012-08-02	FOAT	Futures	102.55	102.99	102.36	102.85	19890.0
2012-08-02	FTDX	Futures	725.9	728.6	711.0	718.9	48.0
2012-08-02	FTI	Futures	278.38	281.24	271.74	273.27	63333.0
2012-08-02	FTUK	Futures	4131.6	4175.6	4065.3	4094.8	134959.0
2012-08-02	FVSA	Futures	7482.61	7579.6	7094.62	7399.47	8616.0
2012-08-02	FXXP	Futures	188.0	189.7	184.2	185.4	2136.0
2012-08-02	G	Futures	100.49	101.07	100.04	100.98	139978.0
2012-08-02	GF	Futures	274.922	277.734	274.872	275.81	2363.0
2012-08-02	GSCI	Futures	1017.88	1019.47	1000.93	1001.97	375.0
2012-08-02	HE	Futures	98.775	98.899	96.674	96.674	18979.0
2012-08-02	HG	Futures	4.3293	4.3595	4.2365	4.2391	80135.0
2012-08-02	HO	Futures	2.3351	2.3576	2.3124	2.3239	65773.0
2012-08-02	HRC	Futures	2529.1	2529.1	2529.1	2529.1	0.0
2012-08-02	J1	Futures	0.0159857	0.0160509	0.0159644	0.0160246	91412.0
2012-08-02	J7	Futures	0.015924	0.015985	0.015903	0.015962	237.0

> showing 50 of 98 rows — these rows as CSV

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