PREVIEW / futures_daily / 2016-09-16

all futures daily files

  file:    by_date/futures_daily/2016/2016-09-16.parquet
  size:    9 KB
  rows:    111

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-16	ES	Futures	2310.83	2311.37	2296.23	2306.5	2064530.0
2016-09-16	NQ	Futures	5668.23	5680.01	5643.77	5673.83	285889.0
2016-09-16	YM	Futures	19005.9	19017.4	18881.9	18956.5	149887.0
2016-09-16	CL	Futures	48.87	48.9	47.8	48.1	421422.0
2016-09-16	GC	Futures	1691.4	1695.5	1679.7	1681.0	138206.0
2016-09-16	ZN	Futures	126.998084	127.271688	126.830881	126.861281	936587.0
2016-09-16	A6	Futures	0.7654	0.76622	0.76101	0.76142	84410.0
2016-09-16	AD	Futures	0.77919	0.7798	0.77356	0.7756	86028.0
2016-09-16	ALI	Futures	2083.13	2083.13	2083.13	2083.13	0.0
2016-09-16	B	Futures	36.41	36.49	35.76	35.99	226321.0
2016-09-16	B6	Futures	1.3961	1.3968	1.3704	1.3709	114600.0
2016-09-16	BFX	Futures	4158.6	4159.2	4158.6	4159.2	1.0
2016-09-16	BR	Futures	0.20352	0.2054	0.20205	0.20479	107.0
2016-09-16	BZ	Futures	36.15	36.33	35.61	35.83	19165.0
2016-09-16	C	Futures	2404.0	2415.0	2387.0	2396.0	8167.0
2016-09-16	CB	Futures	250.592	250.84	250.158	250.158	40.0
2016-09-16	CC	Futures	2095.0	2106.0	2066.0	2073.0	11773.0
2016-09-16	CNH	Futures	7.2133	7.2295	7.2133	7.2295	11.0
2016-09-16	CSC	Futures	3.891	3.909	3.868	3.868	16.0
2016-09-16	CT	Futures	77.58	77.6	76.59	76.73	8.0
2016-09-16	DC	Futures	30.89	31.2	30.57	30.6	79.0
2016-09-16	DX	Futures	88.563	89.414	88.558	89.4	39415.0
2016-09-16	E1	Futures	1.28842	1.28917	1.27546	1.27633	30554.0
2016-09-16	E6	Futures	1.30843	1.30906	1.29735	1.29753	216725.0
2016-09-16	E7	Futures	1.3013	1.3018	1.2903	1.2905	4448.0
2016-09-16	EBM	Futures	186.52	187.7	185.94	187.11	10288.0
2016-09-16	ED	Futures	95.6683	95.6731	95.6442	95.6442	312823.0
2016-09-16	ER	Futures	98.283	98.293	98.283	98.288	75106.0
2016-09-16	EW	Futures	1617.7	1619.1	1608.6	1614.0	19610.0
2016-09-16	FBON	Futures	123.76	123.94	123.6	123.72	677.0
2016-09-16	FBTP	Futures	108.81	109.09	108.59	108.73	84051.0
2016-09-16	FBTS	Futures	101.194	101.23	101.176	101.194	23166.0
2016-09-16	FCE	Futures	3874.6	3885.3	3819.5	3841.3	123729.0
2016-09-16	FDAX	Futures	11083.0	11097.9	10922.5	10922.5	12877.0
2016-09-16	FDIV	Futures	137.99	137.99	137.22	137.22	48.0
2016-09-16	FDXM	Futures	10978.0	10986.5	10793.5	10816.7	37554.0
2016-09-16	FESX	Futures	2365.3	2370.1	2329.3	2336.5	1621464.0
2016-09-16	FEU3	Futures	98.966	98.971	98.966	98.966	19.0
2016-09-16	FGBL	Futures	149.48	150.0	149.35	149.7	609324.0
2016-09-16	FGBM	Futures	128.77	128.94	128.74	128.88	412013.0
2016-09-16	FGBS	Futures	111.897	111.927	111.887	111.912	156581.0
2016-09-16	FGBX	Futures	181.35	182.96	180.92	181.94	40527.0
2016-09-16	FMWO	Futures	5678.4	5678.4	5678.4	5678.4	0.0
2016-09-16	FOAT	Futures	137.29	137.78	137.18	137.48	110736.0
2016-09-16	FTDX	Futures	1728.3	1735.7	1722.0	1730.3	435.0
2016-09-16	FTI	Futures	405.82	406.88	400.96	402.47	40382.0
2016-09-16	FTUK	Futures	5644.8	5662.1	5614.8	5625.0	149949.0
2016-09-16	FVSA	Futures	1680.22	1726.69	1658.77	1719.54	14418.0
2016-09-16	FXXP	Futures	279.7	279.9	276.8	277.0	24948.0
2016-09-16	G	Futures	114.79	115.37	114.79	115.14	138680.0

> showing 50 of 111 rows — these rows as CSV

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