PREVIEW / futures_daily / 2016-09-09

all futures daily files

  file:    by_date/futures_daily/2016/2016-09-09.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-09-09	ES	Futures	2350.76	2351.84	2288.67	2291.91	2073225.0
2016-09-09	NQ	Futures	5653.22	5655.57	5498.8	5505.87	265154.0
2016-09-09	YM	Futures	19276.6	19283.9	18818.0	18844.1	178683.0
2016-09-09	CL	Futures	52.64	52.64	50.64	51.0	688191.0
2016-09-09	GC	Futures	1721.3	1723.9	1707.9	1712.2	163931.0
2016-09-09	ZN	Futures	127.271688	127.347689	126.75488	126.815681	1279248.0
2016-09-09	A6	Futures	0.77741	0.77894	0.76622	0.76795	137068.0
2016-09-09	AD	Futures	0.79142	0.79342	0.78395	0.78554	81151.0
2016-09-09	ALI	Futures	2054.05	2054.05	2054.05	2054.05	0.0
2016-09-09	B	Futures	39.02	39.08	37.55	37.75	262147.0
2016-09-09	B6	Futures	1.4022	1.406	1.3957	1.3993	107081.0
2016-09-09	BR	Futures	0.20612	0.20629	0.20383	0.20383	14.0
2016-09-09	BZ	Futures	38.85	38.89	37.4	37.59	18847.0
2016-09-09	C	Futures	2402.0	2402.0	2329.0	2331.0	7808.0
2016-09-09	CB	Futures	254.188	254.343	254.188	254.343	15.0
2016-09-09	CC	Futures	2105.0	2119.0	2032.0	2043.0	44715.0
2016-09-09	CNH	Futures	7.2352	7.2532	7.2352	7.2488	28.0
2016-09-09	CSC	Futures	3.926	3.926	3.907	3.907	18.0
2016-09-09	CT	Futures	78.15	78.15	77.05	78.03	19.0
2016-09-09	DC	Futures	31.22	31.25	30.95	30.99	45.0
2016-09-09	DX	Futures	88.332	88.895	88.188	88.661	30817.0
2016-09-09	E1	Futures	1.28819	1.28982	1.28005	1.28431	20527.0
2016-09-09	E6	Futures	1.31181	1.31408	1.30401	1.3075	188058.0
2016-09-09	E7	Futures	1.3043	1.307	1.297	1.3005	2850.0
2016-09-09	EBM	Futures	187.7	187.7	186.23	186.23	15555.0
2016-09-09	ED	Futures	95.6171	95.6243	95.605	95.6147	316620.0
2016-09-09	ER	Futures	98.298	98.303	98.298	98.298	18947.0
2016-09-09	EW	Futures	1666.7	1667.1	1613.4	1619.1	34718.0
2016-09-09	FBON	Futures	124.26	124.39	123.51	123.51	644.0
2016-09-09	FBTP	Futures	110.19	110.38	109.42	109.44	137446.0
2016-09-09	FBTS	Futures	101.302	101.32	101.248	101.257	30643.0
2016-09-09	FCE	Futures	3964.6	3971.6	3889.5	3923.5	81934.0
2016-09-09	FDAX	Futures	11348.5	11356.0	11137.3	11245.3	114922.0
2016-09-09	FDXM	Futures	11062.3	11069.5	10854.8	10961.1	31945.0
2016-09-09	FESX	Futures	2412.1	2417.5	2367.4	2390.1	1654060.0
2016-09-09	FGBL	Futures	150.29	150.31	149.31	149.42	898026.0
2016-09-09	FGBM	Futures	128.88	128.91	128.65	128.72	553135.0
2016-09-09	FGBS	Futures	111.882	111.892	111.847	111.862	243403.0
2016-09-09	FGBX	Futures	185.71	185.91	181.74	182.08	65108.0
2016-09-09	FMWO	Futures	5820.6	5820.6	5751.3	5761.0	808.0
2016-09-09	FOAT	Futures	138.21	138.23	137.31	137.35	136383.0
2016-09-09	FTDX	Futures	1691.5	1695.3	1676.6	1685.7	128.0
2016-09-09	FTI	Futures	413.81	414.31	404.65	408.71	26453.0
2016-09-09	FTUK	Futures	5715.0	5723.3	5616.5	5652.8	178069.0
2016-09-09	FVSA	Futures	1691.89	1851.99	1639.96	1748.14	17913.0
2016-09-09	FXXP	Futures	282.7	282.7	277.9	279.5	104913.0
2016-09-09	G	Futures	115.93	116.03	114.98	115.05	251221.0
2016-09-09	GF	Futures	264.811	271.753	261.893	270.093	1953.0
2016-09-09	GSCI	Futures	506.32	506.75	500.93	501.43	2458.0
2016-09-09	HE	Futures	84.674	85.227	81.768	81.941	23418.0

> showing 50 of 108 rows — these rows as CSV

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