PREVIEW / futures_daily / 2016-08-31

all futures daily files

  file:    by_date/futures_daily/2016/2016-08-31.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-31	ES	Futures	2349.14	2349.68	2331.59	2342.39	1864629.0
2016-08-31	NQ	Futures	5632.29	5633.47	5600.76	5626.99	198477.0
2016-08-31	YM	Futures	19274.5	19275.5	19139.7	19213.9	132594.0
2016-08-31	CL	Futures	51.4	51.58	49.47	49.68	549007.0
2016-08-31	GC	Futures	1686.8	1692.5	1676.8	1682.5	179946.0
2016-08-31	ZN	Futures	127.411119	127.562026	127.214939	127.365846	256770.0
2016-08-31	A6	Futures	0.76378	0.76602	0.76175	0.76409	103340.0
2016-08-31	AD	Futures	0.78134	0.78247	0.77858	0.78022	72250.0
2016-08-31	ALI	Futures	2102.22	2102.22	2098.13	2100.33	7.0
2016-08-31	B	Futures	38.25	38.34	36.77	36.87	295265.0
2016-08-31	B6	Futures	1.3792	1.3876	1.3775	1.3842	96365.0
2016-08-31	BFX	Futures	4095.7	4095.7	4095.1	4095.1	7.0
2016-08-31	BR	Futures	0.20705	0.20705	0.20482	0.20653	1181.0
2016-08-31	BZ	Futures	37.92	38.16	36.63	36.71	25458.0
2016-08-31	C	Futures	2509.0	2524.0	2491.0	2512.0	22892.0
2016-08-31	CB	Futures	260.387	260.387	259.147	260.387	14.0
2016-08-31	CC	Futures	2144.0	2158.0	2116.0	2143.0	27189.0
2016-08-31	CNH	Futures	7.2406	7.2426	7.2395	7.2395	47.0
2016-08-31	CSC	Futures	3.859	3.868	3.859	3.859	35.0
2016-08-31	CT	Futures	73.88	74.42	73.88	73.99	10.0
2016-08-31	DC	Futures	30.74	30.78	30.51	30.6	109.0
2016-08-31	DX	Futures	89.276	89.518	89.188	89.297	23728.0
2016-08-31	E1	Futures	1.27417	1.27642	1.27066	1.27467	21140.0
2016-08-31	E6	Futures	1.29818	1.30075	1.29586	1.29999	148992.0
2016-08-31	E7	Futures	1.291	1.2938	1.2889	1.2931	2290.0
2016-08-31	EBM	Futures	187.05	187.65	185.54	186.15	3341.0
2016-08-31	ED	Futures	95.6123	95.6171	95.605	95.6123	230377.0
2016-08-31	ER	Futures	98.303	98.308	98.298	98.303	75917.0
2016-08-31	EW	Futures	1662.6	1664.6	1648.9	1657.6	17254.0
2016-08-31	FBON	Futures	124.78	124.85	124.12	124.23	684.0
2016-08-31	FBTP	Futures	110.86	110.97	110.48	110.63	82918.0
2016-08-31	FBTS	Futures	101.347	101.365	101.32	101.338	25686.0
2016-08-31	FCE	Futures	3890.8	3919.6	3862.4	3876.8	72805.0
2016-08-31	FDAX	Futures	11327.8	11349.6	11227.7	11291.0	80075.0
2016-08-31	FDXM	Futures	11041.5	11062.3	10945.1	11005.7	21437.0
2016-08-31	FESX	Futures	2371.3	2388.6	2357.2	2372.9	1185176.0
2016-08-31	FGBL	Futures	150.93	150.95	150.49	150.61	579312.0
2016-08-31	FGBM	Futures	128.96	128.98	128.86	128.9	427370.0
2016-08-31	FGBS	Futures	111.877	111.892	111.877	111.877	290076.0
2016-08-31	FGBX	Futures	189.33	189.39	187.65	188.1	30235.0
2016-08-31	FMWO	Futures	5763.5	5776.8	5745.2	5752.5	16.0
2016-08-31	FOAT	Futures	138.67	138.69	138.23	138.31	100572.0
2016-08-31	FTDX	Futures	1667.9	1680.4	1663.5	1664.5	192.0
2016-08-31	FTI	Futures	411.28	413.27	408.8	410.06	25635.0
2016-08-31	FTUK	Futures	5693.7	5699.1	5641.1	5661.2	116383.0
2016-08-31	FVSA	Futures	1843.34	1877.95	1826.03	1851.99	18251.0
2016-08-31	FXXP	Futures	278.7	280.1	276.9	278.4	26724.0
2016-08-31	G	Futures	117.31	117.61	117.15	117.31	171950.0
2016-08-31	GF	Futures	287.901	288.253	278.695	282.77	3851.0
2016-08-31	GSCI	Futures	504.76	504.76	493.42	493.49	536.0

> showing 50 of 109 rows — these rows as CSV

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