PREVIEW / futures_daily / 2016-08-05

all futures daily files

  file:    by_date/futures_daily/2016/2016-08-05.parquet
  size:    9 KB
  rows:    109

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-08-05	ES	Futures	2331.59	2352.11	2331.32	2350.22	1370482.0
2016-08-05	NQ	Futures	5593.1	5655.28	5590.15	5637.89	180947.0
2016-08-05	YM	Futures	19088.6	19296.4	19086.5	19275.5	122773.0
2016-08-05	CL	Futures	47.42	47.72	46.54	47.38	550189.0
2016-08-05	GC	Futures	1754.1	1759.0	1719.7	1724.9	223143.0
2016-08-05	ZN	Futures	128.46747	128.512743	127.531844	127.622389	1315208.0
2016-08-05	A6	Futures	0.77497	0.77884	0.77202	0.77497	89511.0
2016-08-05	AD	Futures	0.78605	0.78687	0.77541	0.77776	86354.0
2016-08-05	ALI	Futures	2145.79	2149.61	2145.79	2149.61	2.0
2016-08-05	B	Futures	34.92	35.16	34.39	34.99	236874.0
2016-08-05	B6	Futures	1.3837	1.3899	1.3734	1.38	104024.0
2016-08-05	BR	Futures	0.20593	0.20862	0.20593	0.20829	1177.0
2016-08-05	BZ	Futures	34.75	34.99	34.21	34.81	24997.0
2016-08-05	C	Futures	2565.0	2594.0	2554.0	2577.0	19910.0
2016-08-05	CB	Futures	271.952	274.443	271.952	274.443	7.0
2016-08-05	CC	Futures	2193.0	2218.0	2193.0	2209.0	25434.0
2016-08-05	CNH	Futures	7.2236	7.2236	7.218	7.218	7.0
2016-08-05	CSC	Futures	3.821	3.855	3.811	3.847	43.0
2016-08-05	CT	Futures	86.27	88.13	85.65	86.82	82.0
2016-08-05	DC	Futures	30.56	30.94	30.4	30.87	178.0
2016-08-05	DX	Futures	89.011	89.751	88.807	89.412	24122.0
2016-08-05	E1	Futures	1.28806	1.29032	1.27654	1.28093	20340.0
2016-08-05	E6	Futures	1.2976	1.30162	1.28806	1.29335	161721.0
2016-08-05	E7	Futures	1.2907	1.2946	1.2813	1.2865	2298.0
2016-08-05	EBM	Futures	200.28	200.88	198.48	200.28	10132.0
2016-08-05	ED	Futures	95.6605	95.6653	95.6267	95.6316	264514.0
2016-08-05	ER	Futures	98.313	98.313	98.308	98.308	12503.0
2016-08-05	EW	Futures	1635.5	1655.9	1635.3	1653.5	12836.0
2016-08-05	FBON	Futures	123.83	124.05	123.76	124.05	30.0
2016-08-05	FBTP	Futures	110.29	110.47	110.2	110.37	59462.0
2016-08-05	FBTS	Futures	101.32	101.347	101.32	101.338	14567.0
2016-08-05	FCE	Futures	3801.8	3855.9	3797.4	3849.8	71184.0
2016-08-05	FDAX	Futures	10907.4	11039.9	10863.8	11017.0	73906.0
2016-08-05	FDXM	Futures	10637.0	10757.3	10589.3	10738.7	18991.0
2016-08-05	FESX	Futures	2298.5	2332.2	2294.6	2325.9	811818.0
2016-08-05	FEU3	Futures	98.966	98.966	98.966	98.966	50.0
2016-08-05	FGBL	Futures	150.83	150.84	150.31	150.4	426661.0
2016-08-05	FGBM	Futures	128.95	129.07	128.83	128.87	238134.0
2016-08-05	FGBS	Futures	111.862	111.887	111.852	111.862	132268.0
2016-08-05	FGBX	Futures	190.56	190.6	188.16	188.59	22025.0
2016-08-05	FMWO	Futures	5711.2	5740.4	5711.2	5740.4	201.0
2016-08-05	FOAT	Futures	138.79	138.79	138.29	138.35	66732.0
2016-08-05	FTDX	Futures	1639.9	1647.2	1635.6	1646.7	48.0
2016-08-05	FTI	Futures	398.04	402.81	397.86	401.6	23719.0
2016-08-05	FTUK	Futures	5595.2	5637.8	5581.9	5623.2	112035.0
2016-08-05	FVSA	Futures	2181.55	2181.55	2010.73	2025.37	17354.0
2016-08-05	FXXP	Futures	273.1	275.8	272.8	275.3	23363.0
2016-08-05	G	Futures	116.23	116.45	115.95	116.14	233233.0
2016-08-05	GF	Futures	296.529	299.425	294.583	298.826	3652.0
2016-08-05	GSCI	Futures	488.48	490.91	486.47	489.91	1847.0

> showing 50 of 109 rows — these rows as CSV

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