PREVIEW / futures_daily / 2016-06-09

all futures daily files

  file:    by_date/futures_daily/2016/2016-06-09.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-06-09	ES	Futures	2273.87	2274.67	2261.52	2270.11	1644419.0
2016-06-09	NQ	Futures	5308.98	5313.97	5279.89	5301.63	236706.0
2016-06-09	YM	Futures	18706.2	18715.5	18617.8	18687.5	123852.0
2016-06-09	CL	Futures	60.31	60.57	58.88	59.27	560723.0
2016-06-09	GC	Futures	1626.9	1639.5	1620.2	1637.3	153261.0
2016-06-09	ZN	Futures	126.475493	126.792398	126.41513	126.611309	1024783.0
2016-06-09	A6	Futures	0.75745	0.75948	0.75097	0.7535	122582.0
2016-06-09	AD	Futures	0.8057	0.80693	0.80089	0.80447	98261.0
2016-06-09	ALI	Futures	2112.64	2112.64	2109.1	2109.1	3.0
2016-06-09	B	Futures	42.75	42.85	41.77	42.11	213124.0
2016-06-09	B6	Futures	1.5278	1.5297	1.5211	1.525	123600.0
2016-06-09	BFX	Futures	4135.9	4135.9	4131.2	4135.3	17.0
2016-06-09	BR	Futures	0.19238	0.19368	0.19075	0.19135	236.0
2016-06-09	BZ	Futures	42.58	42.73	41.66	42.0	19759.0
2016-06-09	C	Futures	2360.0	2371.0	2346.0	2362.0	4223.0
2016-06-09	CB	Futures	267.878	269.812	267.878	269.812	8.0
2016-06-09	CC	Futures	2261.0	2274.0	2254.0	2268.0	18186.0
2016-06-09	CNH	Futures	7.1351	7.1499	7.1351	7.1499	12.0
2016-06-09	CSC	Futures	3.498	3.625	3.498	3.625	132.0
2016-06-09	CT	Futures	74.7	74.7	73.32	73.89	17742.0
2016-06-09	DC	Futures	27.79	29.01	27.79	29.01	507.0
2016-06-09	DX	Futures	87.199	87.735	87.111	87.593	22649.0
2016-06-09	E1	Futures	1.31062	1.31188	1.30132	1.30497	32747.0
2016-06-09	E6	Futures	1.32946	1.33144	1.31855	1.32158	270804.0
2016-06-09	E7	Futures	1.3252	1.3252	1.3115	1.3144	6308.0
2016-06-09	EBM	Futures	205.09	206.29	204.19	205.69	10212.0
2016-06-09	ED	Futures	95.7473	95.7497	95.7473	95.7473	112960.0
2016-06-09	ER	Futures	98.264	98.269	98.264	98.269	16952.0
2016-06-09	EW	Futures	1610.9	1610.9	1599.5	1606.7	27990.0
2016-06-09	FBON	Futures	120.21	120.55	120.11	120.17	404.0
2016-06-09	FBTP	Futures	107.88	108.19	107.82	107.89	101918.0
2016-06-09	FBTS	Futures	101.185	101.203	101.167	101.176	16454.0
2016-06-09	FCE	Futures	3822.0	3822.8	3777.6	3788.8	86518.0
2016-06-09	FDAX	Futures	10962.2	10969.8	10788.2	10835.5	101533.0
2016-06-09	FDXM	Futures	10554.7	10562.0	10391.3	10433.7	17894.0
2016-06-09	FESX	Futures	2348.6	2352.5	2322.0	2330.6	1532446.0
2016-06-09	FGBL	Futures	148.05	148.3	147.96	148.06	561869.0
2016-06-09	FGBM	Futures	127.96	128.03	127.92	127.99	460240.0
2016-06-09	FGBS	Futures	111.698	111.723	111.698	111.718	206459.0
2016-06-09	FGBX	Futures	179.6	181.53	179.51	180.79	48009.0
2016-06-09	FMWO	Futures	5754.7	5758.4	5743.5	5743.5	99.0
2016-06-09	FOAT	Futures	135.42	135.76	135.37	135.5	84617.0
2016-06-09	FTDX	Futures	1610.9	1610.9	1596.1	1599.9	124.0
2016-06-09	FTI	Futures	403.35	404.21	399.22	400.75	25175.0
2016-06-09	FTUK	Futures	5188.5	5196.7	5131.1	5140.6	127178.0
2016-06-09	FVSA	Futures	2452.84	2569.2	2452.84	2555.23	14652.0
2016-06-09	FXXP	Futures	275.6	275.7	273.2	273.7	44103.0
2016-06-09	G	Futures	110.54	110.73	110.42	110.5	171089.0
2016-06-09	GF	Futures	293.784	295.531	291.837	294.133	3192.0
2016-06-09	GSCI	Futures	556.47	557.99	555.02	557.99	1599.0

> showing 50 of 109 rows — these rows as CSV

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