PREVIEW / futures_daily / 2016-09-02

all futures daily files

  file:    by_date/futures_daily/2016/2016-09-02.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-09-02	ES	Futures	2338.88	2357.77	2336.72	2351.57	1700143.0
2016-09-02	NQ	Futures	5631.41	5678.85	5627.58	5652.33	227919.0
2016-09-02	YM	Futures	19213.9	19364.3	19196.2	19302.7	158496.0
2016-09-02	CL	Futures	48.41	49.65	47.97	49.39	576915.0
2016-09-02	GC	Futures	1691.0	1711.5	1677.4	1702.2	234252.0
2016-09-02	ZN	Futures	127.320574	127.728024	126.973487	127.214939	51220.0
2016-09-02	A6	Futures	0.76795	0.77457	0.76643	0.76958	120179.0
2016-09-02	AD	Futures	0.78145	0.78835	0.78032	0.78754	81503.0
2016-09-02	ALI	Futures	2091.2	2091.2	2083.96	2083.96	20.0
2016-09-02	B	Futures	36.0	36.97	35.7	36.82	279344.0
2016-09-02	B6	Futures	1.4	1.408	1.3973	1.4019	104249.0
2016-09-02	BR	Futures	0.2052	0.20599	0.2052	0.20599	10.0
2016-09-02	BZ	Futures	35.83	36.8	35.56	36.66	22597.0
2016-09-02	C	Futures	2451.0	2456.0	2438.0	2438.0	6310.0
2016-09-02	CB	Futures	257.287	257.287	256.667	257.287	31.0
2016-09-02	CC	Futures	2130.0	2172.0	2130.0	2145.0	16226.0
2016-09-02	CNH	Futures	7.2427	7.2476	7.2427	7.2476	2.0
2016-09-02	CSC	Futures	3.907	3.907	3.907	3.907	1.0
2016-09-02	CT	Futures	76.92	77.06	76.01	76.47	22.0
2016-09-02	DC	Futures	30.97	31.14	30.85	31.14	102.0
2016-09-02	DX	Futures	88.96	89.253	88.518	89.14	34951.0
2016-09-02	E1	Futures	1.27855	1.28669	1.27554	1.27805	21136.0
2016-09-02	E6	Futures	1.30418	1.31093	1.29865	1.29981	203258.0
2016-09-02	E7	Futures	1.2972	1.3038	1.2918	1.2929	3310.0
2016-09-02	EBM	Futures	189.75	190.66	189.45	190.06	5025.0
2016-09-02	ED	Futures	95.6243	95.6653	95.6195	95.634	384177.0
2016-09-02	ER	Futures	98.303	98.308	98.303	98.308	31884.0
2016-09-02	EW	Futures	1655.9	1673.6	1654.0	1673.4	17724.0
2016-09-02	FBON	Futures	123.62	123.99	123.57	123.92	526.0
2016-09-02	FBTP	Futures	110.22	110.68	110.09	110.24	132264.0
2016-09-02	FBTS	Futures	101.302	101.347	101.293	101.32	26673.0
2016-09-02	FCE	Futures	3889.9	3979.0	3882.9	3968.1	105624.0
2016-09-02	FDAX	Futures	11238.9	11415.0	11186.8	11374.6	98901.0
2016-09-02	FDIV	Futures	137.43	139.09	137.43	139.09	31.0
2016-09-02	FDXM	Futures	10950.3	11125.5	10904.6	11087.2	27528.0
2016-09-02	FESX	Futures	2369.8	2417.5	2362.7	2413.6	1330579.0
2016-09-02	FGBL	Futures	150.57	150.9	150.2	150.23	906656.0
2016-09-02	FGBM	Futures	128.91	129.04	128.87	128.88	696268.0
2016-09-02	FGBS	Futures	111.877	111.917	111.877	111.892	536643.0
2016-09-02	FGBX	Futures	187.15	187.93	184.91	185.02	47930.0
2016-09-02	FMWO	Futures	5765.9	5812.1	5765.9	5812.1	113.0
2016-09-02	FOAT	Futures	138.3	138.6	138.0	138.04	150673.0
2016-09-02	FTDX	Futures	1672.2	1692.0	1669.8	1692.0	178.0
2016-09-02	FTI	Futures	410.33	419.27	409.88	418.37	39212.0
2016-09-02	FTUK	Futures	5649.1	5781.3	5634.5	5777.5	181747.0
2016-09-02	FVSA	Futures	1834.68	1864.97	1761.12	1765.45	9258.0
2016-09-02	FXXP	Futures	278.8	284.3	277.9	284.1	27461.0
2016-09-02	G	Futures	116.94	117.18	116.23	116.29	173278.0
2016-09-02	GF	Futures	276.18	278.897	270.848	271.401	2873.0
2016-09-02	GSCI	Futures	491.79	493.13	490.23	492.0	760.0

> showing 50 of 109 rows — these rows as CSV

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