PREVIEW / futures_daily / 2012-08-01

all futures daily files

  file:    by_date/futures_daily/2012/2012-08-01.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-01	ES	Futures	1389.45	1399.07	1385.15	1387.93	1800024.0
2012-08-01	NQ	Futures	3024.07	3048.75	3005.42	3012.88	252194.0
2012-08-01	YM	Futures	12554.1	12634.6	12510.4	12537.6	109956.0
2012-08-01	CL	Futures	159.77	162.38	158.83	161.37	281204.0
2012-08-01	GC	Futures	2159.6	2165.3	2129.5	2146.0	156106.0
2012-08-01	ZN	Futures	117.502921	117.516539	116.903694	116.930931	882351.0
2012-08-01	A6	Futures	0.93965	0.94387	0.93542	0.93713	149660.0
2012-08-01	AD	Futures	0.99809	1.0012	0.99599	0.99729	80239.0
2012-08-01	B	Futures	94.15	95.85	93.49	95.05	141954.0
2012-08-01	B6	Futures	1.6381	1.6398	1.623	1.6253	111726.0
2012-08-01	BFX	Futures	2728.2	2745.0	2728.2	2745.0	6.0
2012-08-01	BR	Futures	0.23152	0.23288	0.23114	0.23234	640.0
2012-08-01	BZ	Futures	100.47	100.47	100.17	100.17	1393.0
2012-08-01	C	Futures	1683.0	1690.0	1663.0	1683.0	8931.0
2012-08-01	CB	Futures	89.077	89.534	89.077	89.077	2.0
2012-08-01	CC	Futures	1801.0	1815.0	1786.0	1809.0	16998.0
2012-08-01	CSC	Futures	3.936	3.988	3.925	3.984	11.0
2012-08-01	CT	Futures	93.01	93.62	92.29	92.29	31.0
2012-08-01	DC	Futures	29.11	29.52	28.69	29.38	632.0
2012-08-01	DX	Futures	80.348	80.823	80.115	80.734	20038.0
2012-08-01	E1	Futures	1.32318	1.32744	1.3144	1.31646	33049.0
2012-08-01	E6	Futures	1.45162	1.4561	1.44207	1.44419	211572.0
2012-08-01	E7	Futures	1.4422	1.4471	1.433	1.4352	4533.0
2012-08-01	ED	Futures	95.2038	95.2182	95.1943	95.1991	198376.0
2012-08-01	ER	Futures	97.827	97.842	97.808	97.817	116263.0
2012-08-01	EW	Futures	949.6	957.6	940.6	941.8	26254.0
2012-08-01	FBTP	Futures	65.1	65.9	64.97	65.66	20208.0
2012-08-01	FBTS	Futures	84.806	85.41	84.798	85.327	3680.0
2012-08-01	FCE	Futures	2451.8	2477.9	2448.9	2474.9	96722.0
2012-08-01	FDAX	Futures	7398.5	7427.9	7343.3	7378.3	109714.0
2012-08-01	FESX	Futures	1571.1	1583.9	1569.0	1577.8	904476.0
2012-08-01	FGBL	Futures	119.35	119.35	118.3	118.53	685079.0
2012-08-01	FGBM	Futures	116.69	116.69	116.23	116.32	523756.0
2012-08-01	FGBS	Futures	110.592	110.592	110.512	110.542	307369.0
2012-08-01	FGBX	Futures	128.59	128.72	126.26	126.73	10533.0
2012-08-01	FOAT	Futures	102.76	103.16	102.37	102.48	23678.0
2012-08-01	FTDX	Futures	724.0	730.0	724.0	728.6	79.0
2012-08-01	FTI	Futures	277.83	279.11	277.02	278.21	28249.0
2012-08-01	FTUK	Futures	4060.6	4142.1	4057.7	4126.9	93579.0
2012-08-01	FVSA	Futures	7385.61	7510.32	7233.19	7399.47	4785.0
2012-08-01	FXXP	Futures	187.6	187.9	186.7	187.7	3005.0
2012-08-01	G	Futures	100.94	100.94	100.13	100.41	145767.0
2012-08-01	GF	Futures	273.59	277.833	272.109	275.859	2973.0
2012-08-01	GSCI	Futures	1011.2	1017.4	1009.45	1009.92	743.0
2012-08-01	HE	Futures	99.362	99.61	98.065	98.528	21887.0
2012-08-01	HG	Futures	4.4027	4.4143	4.3099	4.348	50154.0
2012-08-01	HO	Futures	2.3217	2.3588	2.3144	2.3374	58775.0
2012-08-01	HRC	Futures	2509.4	2509.4	2509.4	2509.4	0.0
2012-08-01	J1	Futures	0.0160496	0.0160935	0.0159707	0.0159895	77733.0
2012-08-01	J7	Futures	0.015984	0.016029	0.015909	0.015927	307.0

> showing 50 of 98 rows — these rows as CSV

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