PREVIEW / futures_daily / 2014-10-20

all futures daily files

  file:    by_date/futures_daily/2014/2014-10-20.parquet
  size:    9 KB
  rows:    107

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
2014-10-20	ES	Futures	1968.0	1989.41	1955.73	1984.71	1653127.0
2014-10-20	NQ	Futures	4417.73	4500.3	4396.29	4480.6	315481.0
2014-10-20	YM	Futures	16571.2	16657.5	16397.7	16568.2	180953.0
2014-10-20	CL	Futures	158.19	158.84	155.1	157.27	301044.0
2014-10-20	GC	Futures	1625.3	1638.6	1619.8	1632.6	96271.0
2014-10-20	ZN	Futures	119.608363	119.930521	119.38871	119.784086	1404766.0
2014-10-20	A6	Futures	0.84838	0.85197	0.84673	0.8509	51765.0
2014-10-20	AD	Futures	0.89874	0.90148	0.89813	0.89894	33932.0
2014-10-20	ALI	Futures	3007.8	3007.8	3007.8	3007.8	0.0
2014-10-20	B	Futures	89.63	89.99	87.62	88.64	247595.0
2014-10-20	B6	Futures	1.6909	1.6999	1.6893	1.6987	62879.0
2014-10-20	BFX	Futures	3619.8	3619.8	3591.3	3595.7	13.0
2014-10-20	BR	Futures	0.21922	0.21922	0.21639	0.21685	155.0
2014-10-20	BZ	Futures	90.16	90.64	88.26	89.3	20345.0
2014-10-20	C	Futures	2151.0	2169.0	2122.0	2159.0	5054.0
2014-10-20	CB	Futures	133.729	135.849	133.536	135.27	19.0
2014-10-20	CC	Futures	2287.0	2312.0	2267.0	2303.0	9406.0
2014-10-20	CNH	Futures	7.0636	7.0636	7.0559	7.0559	5.0
2014-10-20	CSC	Futures	4.969	4.98	4.946	4.946	66.0
2014-10-20	CT	Futures	80.02	80.34	78.85	78.93	11079.0
2014-10-20	DC	Futures	40.39	40.49	40.03	40.22	243.0
2014-10-20	DX	Futures	81.001	81.134	80.679	80.724	17649.0
2014-10-20	E1	Futures	1.35141	1.3587	1.34924	1.3578	25810.0
2014-10-20	E6	Futures	1.50246	1.50929	1.49917	1.50823	151059.0
2014-10-20	E7	Futures	1.4925	1.4997	1.4897	1.4987	2973.0
2014-10-20	ED	Futures	95.4326	95.4422	95.4326	95.4374	114056.0
2014-10-20	ER	Futures	97.989	97.994	97.984	97.984	30369.0
2014-10-20	EW	Futures	1374.9	1390.7	1365.7	1388.0	19656.0
2014-10-20	FBTP	Futures	94.27	94.5	93.43	93.64	79414.0
2014-10-20	FBTS	Futures	98.188	98.233	97.966	98.091	16472.0
2014-10-20	FCE	Futures	3256.1	3264.6	3193.6	3217.0	123633.0
2014-10-20	FDAX	Futures	9716.6	9733.1	9509.6	9554.0	133372.0
2014-10-20	FDIV	Futures	124.93	124.93	124.01	124.47	140.0
2014-10-20	FESX	Futures	2139.8	2146.3	2099.9	2116.6	1190879.0
2014-10-20	FEU3	Futures	98.616	98.616	98.611	98.611	1.0
2014-10-20	FGBL	Futures	132.74	133.13	132.71	132.83	695337.0
2014-10-20	FGBM	Futures	122.91	123.11	122.89	123.02	429358.0
2014-10-20	FGBS	Futures	110.918	110.948	110.908	110.938	184623.0
2014-10-20	FGBX	Futures	144.54	145.7	144.46	144.82	24397.0
2014-10-20	FMWO	Futures	5371.5	5384.0	5341.4	5384.0	2429.0
2014-10-20	FOAT	Futures	121.56	121.83	121.3	121.37	93187.0
2014-10-20	FTDX	Futures	1104.8	1107.2	1088.3	1095.4	367.0
2014-10-20	FTI	Futures	338.02	338.51	331.9	335.18	37504.0
2014-10-20	FTUK	Futures	4871.1	4882.7	4800.4	4824.7	112815.0
2014-10-20	FVSA	Futures	1874.99	1920.82	1841.65	1845.82	16310.0
2014-10-20	FXXP	Futures	241.2	241.6	238.2	240.0	26383.0
2014-10-20	G	Futures	98.98	99.64	98.95	99.34	145064.0
2014-10-20	GF	Futures	366.242	371.212	364.873	370.703	3297.0
2014-10-20	GSCI	Futures	917.08	917.08	906.21	912.66	267.0
2014-10-20	HE	Futures	121.266	121.67	119.213	119.987	14054.0

> showing 50 of 107 rows — these rows as CSV

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