PREVIEW / futures_daily / 2017-01-31

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-31.parquet
  size:    9 KB
  rows:    110

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
2017-01-31	ES	Futures	2467.14	2469.85	2452.5	2465.78	1628810.0
2017-01-31	NQ	Futures	6038.6	6052.15	5991.16	6025.93	214696.0
2017-01-31	YM	Futures	20942.7	20951.1	20763.7	20846.9	149470.0
2017-01-31	CL	Futures	56.29	57.32	55.9	56.51	586676.0
2017-01-31	GC	Futures	1530.0	1555.2	1527.4	1547.5	246904.0
2017-01-31	ZN	Futures	121.415748	121.935337	121.339338	121.736671	2121500.0
2017-01-31	A6	Futures	0.77331	0.77812	0.77167	0.77607	96492.0
2017-01-31	AD	Futures	0.77919	0.78797	0.77868	0.7847	80974.0
2017-01-31	ALI	Futures	2451.07	2468.4	2451.07	2468.4	1.0
2017-01-31	B	Futures	40.81	41.62	40.53	40.99	363170.0
2017-01-31	B6	Futures	1.3114	1.3223	1.3029	1.3207	120624.0
2017-01-31	BFX	Futures	4331.7	4331.7	4295.4	4295.4	1.0
2017-01-31	BR	Futures	0.22607	0.22752	0.22379	0.2239	2001.0
2017-01-31	BZ	Futures	40.62	41.4	40.34	40.78	34977.0
2017-01-31	C	Futures	1753.0	1781.0	1745.0	1748.0	9630.0
2017-01-31	CB	Futures	275.85	277.071	275.85	277.071	15.0
2017-01-31	CC	Futures	1577.0	1637.0	1577.0	1601.0	26638.0
2017-01-31	CNH	Futures	7.2672	7.2683	7.2448	7.2448	18.0
2017-01-31	CSC	Futures	3.942	3.969	3.923	3.969	44.0
2017-01-31	CT	Futures	85.19	86.31	85.12	86.09	15520.0
2017-01-31	DC	Futures	32.71	32.94	32.44	32.82	303.0
2017-01-31	DX	Futures	93.472	93.579	92.55	92.626	57721.0
2017-01-31	E1	Futures	1.24855	1.25971	1.24632	1.25636	34273.0
2017-01-31	E6	Futures	1.23789	1.25083	1.2361	1.24991	294460.0
2017-01-31	E7	Futures	1.2317	1.2445	1.2298	1.2435	7198.0
2017-01-31	EBM	Futures	190.28	190.57	188.58	188.58	26712.0
2017-01-31	ED	Futures	95.5617	95.5713	95.5568	95.5665	219492.0
2017-01-31	ER	Futures	98.303	98.308	98.298	98.303	93745.0
2017-01-31	EW	Futures	1789.5	1798.3	1778.5	1794.7	22779.0
2017-01-31	FBON	Futures	120.4	120.87	120.29	120.7	1622.0
2017-01-31	FBTP	Futures	103.22	103.8	103.18	103.55	138619.0
2017-01-31	FBTS	Futures	101.394	101.503	101.376	101.485	48318.0
2017-01-31	FCE	Futures	4215.8	4238.2	4179.6	4181.8	127567.0
2017-01-31	FDAX	Futures	12326.5	12387.7	12176.6	12208.2	100767.0
2017-01-31	FDXM	Futures	12274.7	12337.8	12127.5	12159.1	31868.0
2017-01-31	FESX	Futures	2603.9	2621.5	2578.3	2587.1	1229999.0
2017-01-31	FEU3	Futures	98.971	98.971	98.971	98.971	1.0
2017-01-31	FGBL	Futures	146.16	146.36	145.64	146.22	1000857.0
2017-01-31	FGBM	Futures	128.42	128.54	128.26	128.5	639434.0
2017-01-31	FGBS	Futures	112.042	112.097	112.032	112.092	309583.0
2017-01-31	FGBX	Futures	165.05	165.62	163.53	165.28	70911.0
2017-01-31	FMWO	Futures	5969.6	5987.7	5962.4	5967.2	182.0
2017-01-31	FOAT	Futures	130.27	130.64	129.89	130.41	187071.0
2017-01-31	FTDX	Futures	1810.7	1810.7	1785.2	1792.6	60.0
2017-01-31	FTI	Futures	435.94	439.19	433.16	433.48	36074.0
2017-01-31	FTUK	Futures	5988.0	6018.6	5961.8	5974.1	116476.0
2017-01-31	FVSA	Futures	869.21	878.69	840.79	859.74	22229.0
2017-01-31	FXXP	Futures	299.5	300.7	297.1	297.8	34569.0
2017-01-31	G	Futures	110.59	110.8	110.15	110.75	247990.0
2017-01-31	GF	Futures	282.231	283.884	278.869	279.895	6169.0

> showing 50 of 110 rows — these rows as CSV

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