PREVIEW / futures_daily / 2015-07-31

all futures daily files

  file:    by_date/futures_daily/2015/2015-07-31.parquet
  size:    9 KB
  rows:    105

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
2015-07-31	ES	Futures	2227.47	2235.42	2220.58	2224.03	1602805.0
2015-07-31	NQ	Futures	5358.04	5380.8	5342.86	5353.07	214679.0
2015-07-31	YM	Futures	18152.6	18199.8	18067.4	18090.0	119936.0
2015-07-31	CL	Futures	80.48	80.73	77.54	78.24	334474.0
2015-07-31	GC	Futures	1404.1	1423.8	1393.1	1413.7	174127.0
2015-07-31	ZN	Futures	121.003257	121.733539	120.794605	121.554695	1419755.0
2015-07-31	A6	Futures	0.72039	0.72801	0.71494	0.72068	126013.0
2015-07-31	AD	Futures	0.7862	0.78999	0.78017	0.78078	85443.0
2015-07-31	ALI	Futures	2214.23	2214.23	2214.23	2214.23	0.0
2015-07-31	B	Futures	49.84	50.09	48.35	48.92	121507.0
2015-07-31	B6	Futures	1.6413	1.6497	1.636	1.643	117149.0
2015-07-31	BR	Futures	0.17467	0.17707	0.17185	0.17368	1489.0
2015-07-31	BZ	Futures	50.01	50.02	48.33	48.87	15726.0
2015-07-31	C	Futures	2304.0	2304.0	2275.0	2284.0	8777.0
2015-07-31	CB	Futures	159.136	161.284	159.136	160.939	51.0
2015-07-31	CC	Futures	2369.0	2383.0	2352.0	2360.0	17477.0
2015-07-31	CSC	Futures	4.419	4.432	4.394	4.427	28.0
2015-07-31	CT	Futures	77.72	78.73	77.6	78.33	16.0
2015-07-31	DC	Futures	35.69	35.71	35.32	35.6	261.0
2015-07-31	DX	Futures	91.32	91.479	90.216	91.212	60527.0
2015-07-31	E1	Futures	1.31196	1.33176	1.31183	1.31373	28488.0
2015-07-31	E6	Futures	1.28498	1.30648	1.28369	1.28885	316797.0
2015-07-31	E7	Futures	1.2779	1.2991	1.2767	1.2817	7570.0
2015-07-31	EBM	Futures	297.99	298.4	294.71	295.94	16246.0
2015-07-31	ED	Futures	95.6079	95.651	95.5983	95.6366	393720.0
2015-07-31	ER	Futures	98.117	98.122	98.112	98.117	19351.0
2015-07-31	EW	Futures	1568.3	1579.8	1565.7	1571.6	15604.0
2015-07-31	FBTP	Futures	101.18	101.55	100.84	101.49	81478.0
2015-07-31	FBTS	Futures	100.106	100.124	100.079	100.097	11589.0
2015-07-31	FCE	Futures	4216.7	4243.7	4198.7	4239.2	69222.0
2015-07-31	FDAX	Futures	12472.4	12524.3	12348.0	12498.9	88616.0
2015-07-31	FESX	Futures	2656.9	2668.0	2630.2	2662.8	815423.0
2015-07-31	FEU3	Futures	98.754	98.759	98.754	98.759	1.0
2015-07-31	FGBL	Futures	137.77	137.83	137.1	137.75	668874.0
2015-07-31	FGBM	Futures	124.75	124.77	124.55	124.71	411675.0
2015-07-31	FGBS	Futures	111.248	111.248	111.213	111.223	188047.0
2015-07-31	FGBX	Futures	157.47	158.63	156.01	158.3	31967.0
2015-07-31	FMWO	Futures	5839.7	5860.6	5826.1	5859.3	149.0
2015-07-31	FOAT	Futures	126.18	126.28	125.5	126.18	84239.0
2015-07-31	FTDX	Futures	1661.2	1667.8	1654.6	1666.8	105.0
2015-07-31	FTI	Futures	425.99	426.51	422.1	425.21	22870.0
2015-07-31	FTUK	Futures	5264.2	5291.7	5240.8	5288.9	81578.0
2015-07-31	FVSA	Futures	1772.08	1794.01	1754.54	1758.92	5974.0
2015-07-31	FXXP	Futures	304.3	304.6	301.8	304.2	16585.0
2015-07-31	G	Futures	101.99	102.77	101.83	102.71	172811.0
2015-07-31	GF	Futures	359.718	360.993	358.018	358.273	2195.0
2015-07-31	GSCI	Futures	637.58	638.58	627.09	629.59	469.0
2015-07-31	HE	Futures	88.916	89.055	87.045	87.687	11217.0
2015-07-31	HG	Futures	2.9646	2.9902	2.9303	2.9496	47166.0
2015-07-31	HH	Futures	34.047	34.096	33.226	33.299	2214.0

> showing 50 of 105 rows — these rows as CSV

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