PREVIEW / futures_daily / 2016-07-21

all futures daily files

  file:    by_date/futures_daily/2016/2016-07-21.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-07-21	ES	Futures	2341.04	2343.2	2325.11	2329.97	1300678.0
2016-07-21	NQ	Futures	5485.83	5495.56	5453.71	5467.27	181960.0
2016-07-21	YM	Futures	19354.9	19373.7	19212.9	19256.7	109859.0
2016-07-21	CL	Futures	51.74	52.24	50.46	50.72	432972.0
2016-07-21	GC	Futures	1693.3	1716.2	1686.2	1712.3	253464.0
2016-07-21	ZN	Futures	127.456391	127.818569	127.109304	127.712933	1282566.0
2016-07-21	A6	Futures	0.7591	0.76297	0.75717	0.76032	72562.0
2016-07-21	AD	Futures	0.78298	0.78595	0.78124	0.7818	44900.0
2016-07-21	ALI	Futures	2091.05	2093.28	2091.05	2093.28	3.0
2016-07-21	B	Futures	37.66	37.97	36.76	36.88	237479.0
2016-07-21	B6	Futures	1.3961	1.4004	1.3879	1.3928	97108.0
2016-07-21	BR	Futures	0.2027	0.2027	0.19984	0.2001	94.0
2016-07-21	BZ	Futures	37.51	37.82	36.62	36.75	22328.0
2016-07-21	C	Futures	2566.0	2569.0	2508.0	2515.0	16656.0
2016-07-21	CB	Futures	278.106	278.604	276.641	276.699	11.0
2016-07-21	CC	Futures	2169.0	2179.0	2123.0	2128.0	27236.0
2016-07-21	CNH	Futures	7.2398	7.2439	7.239	7.239	17.0
2016-07-21	CSC	Futures	3.705	3.705	3.678	3.686	49.0
2016-07-21	CT	Futures	81.42	83.23	81.31	82.31	30.0
2016-07-21	DC	Futures	29.8	29.86	29.41	29.66	98.0
2016-07-21	DX	Futures	90.355	90.471	89.997	90.258	24805.0
2016-07-21	E1	Futures	1.27204	1.27617	1.26753	1.27266	14568.0
2016-07-21	E6	Futures	1.28474	1.29056	1.28113	1.28509	171902.0
2016-07-21	E7	Futures	1.2779	1.2836	1.2743	1.2783	4668.0
2016-07-21	EBM	Futures	194.27	201.78	193.66	200.88	23327.0
2016-07-21	ED	Futures	95.7087	95.7184	95.6798	95.6846	420659.0
2016-07-21	ER	Futures	98.308	98.313	98.303	98.313	89417.0
2016-07-21	EW	Futures	1640.0	1643.4	1628.3	1631.4	13347.0
2016-07-21	FBON	Futures	122.57	123.17	122.44	123.04	621.0
2016-07-21	FBTP	Futures	109.37	109.45	108.93	109.34	96349.0
2016-07-21	FBTS	Futures	101.32	101.32	101.23	101.284	22502.0
2016-07-21	FCE	Futures	3816.6	3832.3	3787.4	3822.3	70641.0
2016-07-21	FDAX	Futures	10779.7	10842.5	10724.9	10815.4	81596.0
2016-07-21	FDXM	Futures	10498.0	10571.7	10454.4	10542.1	22261.0
2016-07-21	FESX	Futures	2317.3	2329.0	2299.3	2323.6	964039.0
2016-07-21	FEU3	Futures	98.966	98.966	98.961	98.966	22.0
2016-07-21	FGBL	Futures	149.65	149.77	149.04	149.52	682343.0
2016-07-21	FGBM	Futures	128.82	128.82	128.53	128.73	481420.0
2016-07-21	FGBS	Futures	111.882	111.887	111.832	111.877	325585.0
2016-07-21	FGBX	Futures	184.61	186.09	183.23	184.91	40090.0
2016-07-21	FMWO	Futures	5702.7	5702.7	5690.5	5700.2	149.0
2016-07-21	FOAT	Futures	137.67	137.74	137.06	137.58	96803.0
2016-07-21	FTDX	Futures	1611.5	1611.5	1595.1	1610.1	142.0
2016-07-21	FTI	Futures	403.4	405.87	400.56	403.4	25474.0
2016-07-21	FTUK	Futures	5548.9	5571.9	5525.6	5552.7	83720.0
2016-07-21	FVSA	Futures	2244.99	2327.96	2210.83	2215.71	12692.0
2016-07-21	FXXP	Futures	274.6	275.7	272.7	274.8	26403.0
2016-07-21	G	Futures	114.33	114.56	114.01	114.39	139447.0
2016-07-21	GF	Futures	277.26	277.709	267.825	268.374	5639.0
2016-07-21	GSCI	Futures	509.28	509.35	502.75	503.18	323.0

> showing 50 of 109 rows — these rows as CSV

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