PREVIEW / futures_daily / 2016-07-27

all futures daily files

  file:    by_date/futures_daily/2016/2016-07-27.parquet
  size:    9 KB
  rows:    108

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-07-27	ES	Futures	2338.61	2342.12	2323.49	2332.67	1642569.0
2016-07-27	NQ	Futures	5529.74	5556.56	5512.65	5549.19	230410.0
2016-07-27	YM	Futures	19247.3	19293.3	19170.0	19208.7	145046.0
2016-07-27	CL	Futures	48.35	48.97	47.24	47.52	537390.0
2016-07-27	GC	Futures	1703.2	1732.1	1697.4	1712.2	170657.0
2016-07-27	ZN	Futures	127.622389	128.135474	127.320574	128.014748	1171110.0
2016-07-27	A6	Futures	0.76256	0.76999	0.75361	0.75991	114453.0
2016-07-27	AD	Futures	0.77618	0.78093	0.77224	0.77495	65764.0
2016-07-27	ALI	Futures	2087.23	2087.87	2086.59	2087.87	6.0
2016-07-27	B	Futures	35.49	35.83	34.56	34.71	349557.0
2016-07-27	B6	Futures	1.3859	1.3965	1.3791	1.3914	91844.0
2016-07-27	BR	Futures	0.2009	0.2019	0.19977	0.20147	17501.0
2016-07-27	BZ	Futures	35.39	35.64	34.4	34.53	31681.0
2016-07-27	C	Futures	2485.0	2515.0	2485.0	2504.0	12514.0
2016-07-27	CB	Futures	271.366	271.366	267.263	267.263	56.0
2016-07-27	CC	Futures	2082.0	2111.0	2082.0	2095.0	16214.0
2016-07-27	CNH	Futures	7.2335	7.2406	7.2318	7.2318	8.0
2016-07-27	CSC	Futures	3.777	3.777	3.76	3.769	19.0
2016-07-27	CT	Futures	84.43	84.96	83.06	83.63	71.0
2016-07-27	DC	Futures	30.07	30.29	30.04	30.18	98.0
2016-07-27	DX	Futures	90.374	90.718	89.946	90.255	18214.0
2016-07-27	E1	Futures	1.26553	1.27366	1.25751	1.26778	16494.0
2016-07-27	E6	Futures	1.28148	1.29097	1.27874	1.28561	150321.0
2016-07-27	E7	Futures	1.2748	1.284	1.272	1.2787	2684.0
2016-07-27	EBM	Futures	199.08	202.08	196.07	196.97	12637.0
2016-07-27	ED	Futures	95.6702	95.6846	95.646	95.675	403206.0
2016-07-27	ER	Futures	98.313	98.313	98.308	98.308	19163.0
2016-07-27	EW	Futures	1643.7	1649.3	1632.7	1638.9	16699.0
2016-07-27	FBON	Futures	123.36	123.36	123.15	123.27	213.0
2016-07-27	FBTP	Futures	109.37	109.83	109.32	109.68	66720.0
2016-07-27	FBTS	Futures	101.257	101.302	101.257	101.275	16100.0
2016-07-27	FCE	Futures	3849.4	3902.2	3847.2	3881.2	81371.0
2016-07-27	FDAX	Futures	10941.5	11009.6	10933.5	10968.6	73434.0
2016-07-27	FDXM	Futures	10662.9	10732.4	10656.7	10691.5	16710.0
2016-07-27	FESX	Futures	2336.9	2360.4	2334.5	2343.9	1020086.0
2016-07-27	FGBL	Futures	149.85	150.82	149.69	150.59	525250.0
2016-07-27	FGBM	Futures	128.7	128.96	128.67	128.92	421695.0
2016-07-27	FGBS	Futures	111.847	111.887	111.837	111.882	152215.0
2016-07-27	FGBX	Futures	187.34	190.68	186.48	190.11	31566.0
2016-07-27	FMWO	Futures	5716.0	5716.0	5697.8	5699.0	152.0
2016-07-27	FOAT	Futures	137.87	138.62	137.78	138.57	65915.0
2016-07-27	FTDX	Futures	1643.8	1657.3	1643.3	1651.0	119.0
2016-07-27	FTI	Futures	406.5	407.94	402.59	404.34	23705.0
2016-07-27	FTUK	Futures	5577.3	5611.1	5568.6	5584.4	87607.0
2016-07-27	FVSA	Futures	2220.59	2274.28	2191.31	2264.51	15181.0
2016-07-27	FXXP	Futures	276.2	277.5	275.4	276.2	27302.0
2016-07-27	G	Futures	114.57	115.52	114.54	115.43	175842.0
2016-07-27	GF	Futures	282.851	285.247	282.052	284.099	2599.0
2016-07-27	GSCI	Futures	489.91	490.2	485.75	487.04	447.0
2016-07-27	HE	Futures	88.968	89.118	85.562	85.652	11656.0

> showing 50 of 108 rows — these rows as CSV

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