PREVIEW / futures_daily / 2016-06-29

all futures daily files

  file:    by_date/futures_daily/2016/2016-06-29.parquet
  size:    9 KB
  rows:    110

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
2016-06-29	ES	Futures	2189.88	2240.09	2183.94	2231.45	2065151.0
2016-06-29	NQ	Futures	5046.46	5162.86	5031.14	5142.53	260013.0
2016-06-29	YM	Futures	18072.2	18481.7	18023.2	18408.6	170563.0
2016-06-29	CL	Futures	55.83	58.08	55.73	57.94	511476.0
2016-06-29	GC	Futures	1690.3	1712.3	1689.6	1707.1	176817.0
2016-06-29	ZN	Futures	128.633469	128.754194	128.150565	128.512743	1098012.0
2016-06-29	A6	Futures	0.74954	0.75656	0.74882	0.75473	96481.0
2016-06-29	AD	Futures	0.78574	0.79148	0.78472	0.78841	51529.0
2016-06-29	ALI	Futures	2137.63	2149.05	2137.63	2148.1	7.0
2016-06-29	B	Futures	39.51	41.07	39.38	40.97	317841.0
2016-06-29	B6	Futures	1.4063	1.4274	1.4011	1.416	134756.0
2016-06-29	BFX	Futures	3872.0	3875.5	3872.0	3875.5	10.0
2016-06-29	BR	Futures	0.1997	0.2027	0.19947	0.20153	259.0
2016-06-29	BZ	Futures	39.33	40.91	39.26	40.82	31038.0
2016-06-29	C	Futures	2505.0	2511.0	2474.0	2500.0	11119.0
2016-06-29	CB	Futures	276.348	279.073	276.348	278.956	17.0
2016-06-29	CC	Futures	2214.0	2227.0	2201.0	2224.0	13020.0
2016-06-29	CNH	Futures	7.2315	7.2315	7.214	7.214	3.0
2016-06-29	CSC	Futures	3.716	3.824	3.716	3.766	193.0
2016-06-29	CT	Futures	75.02	75.5	74.88	75.01	21.0
2016-06-29	DC	Futures	29.95	30.79	29.88	30.33	510.0
2016-06-29	DX	Futures	89.416	89.537	88.937	89.106	20235.0
2016-06-29	E1	Futures	1.28255	1.28619	1.28055	1.28306	14085.0
2016-06-29	E6	Futures	1.29376	1.29946	1.29003	1.29667	156177.0
2016-06-29	E7	Futures	1.286	1.2925	1.2833	1.2897	2679.0
2016-06-29	EBM	Futures	191.86	191.86	188.25	188.55	15533.0
2016-06-29	ED	Futures	95.8583	95.8631	95.8341	95.839	202533.0
2016-06-29	ER	Futures	98.308	98.318	98.303	98.308	71132.0
2016-06-29	EW	Futures	1527.0	1559.3	1523.3	1552.3	27907.0
2016-06-29	FBON	Futures	121.55	122.03	121.15	121.62	650.0
2016-06-29	FBTP	Futures	107.78	108.44	107.64	107.99	140928.0
2016-06-29	FBTS	Futures	101.15	101.221	101.15	101.185	41533.0
2016-06-29	FCE	Futures	3597.3	3662.7	3589.9	3652.2	106985.0
2016-06-29	FDAX	Futures	10149.8	10249.2	10101.9	10202.4	96912.0
2016-06-29	FDXM	Futures	9892.3	9990.8	9845.6	9944.6	27086.0
2016-06-29	FESX	Futures	2177.9	2214.7	2173.2	2207.7	1665255.0
2016-06-29	FEU3	Futures	98.956	98.961	98.956	98.956	16.0
2016-06-29	FGBL	Futures	150.04	150.38	149.94	150.2	522740.0
2016-06-29	FGBM	Futures	128.89	128.97	128.82	128.88	437492.0
2016-06-29	FGBS	Futures	111.942	111.967	111.922	111.927	183858.0
2016-06-29	FGBX	Futures	189.16	190.64	188.49	190.25	36394.0
2016-06-29	FMWO	Futures	5380.5	5440.0	5371.9	5438.8	646.0
2016-06-29	FOAT	Futures	137.31	137.71	137.3	137.52	83653.0
2016-06-29	FTDX	Futures	1503.1	1526.2	1503.1	1524.3	131.0
2016-06-29	FTI	Futures	379.33	386.89	378.88	386.48	38778.0
2016-06-29	FTUK	Futures	5119.7	5274.1	5092.2	5241.1	190189.0
2016-06-29	FVSA	Futures	2791.23	2791.23	2629.42	2690.1	27525.0
2016-06-29	FXXP	Futures	256.9	263.3	256.9	262.2	50048.0
2016-06-29	G	Futures	113.27	113.44	112.97	113.34	128996.0
2016-06-29	GF	Futures	282.402	288.243	281.553	285.647	5599.0

> showing 50 of 110 rows — these rows as CSV

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