PREVIEW / futures_daily / 2016-09-01

all futures daily files

  file:    by_date/futures_daily/2016/2016-09-01.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-01	ES	Futures	2341.85	2350.76	2326.46	2339.96	1943431.0
2016-09-01	NQ	Futures	5627.28	5652.33	5598.4	5631.41	248348.0
2016-09-01	YM	Futures	19211.8	19283.9	19100.1	19213.9	169678.0
2016-09-01	CL	Futures	49.85	50.11	47.79	47.97	605003.0
2016-09-01	GC	Futures	1682.9	1691.8	1675.0	1689.9	179601.0
2016-09-01	ZN	Futures	127.23003	127.501663	126.898033	127.380937	191897.0
2016-09-01	A6	Futures	0.76429	0.76877	0.76327	0.76836	110611.0
2016-09-01	AD	Futures	0.78083	0.78232	0.77838	0.78134	73185.0
2016-09-01	ALI	Futures	2101.27	2101.27	2098.13	2098.13	10.0
2016-09-01	B	Futures	36.94	37.14	35.63	35.73	290044.0
2016-09-01	B6	Futures	1.3855	1.4043	1.3843	1.3994	137503.0
2016-09-01	BR	Futures	0.20705	0.20705	0.20451	0.20588	1132.0
2016-09-01	BZ	Futures	36.86	36.98	35.48	35.58	23846.0
2016-09-01	C	Futures	2508.0	2513.0	2449.0	2461.0	19250.0
2016-09-01	CB	Futures	260.387	260.387	257.318	257.597	25.0
2016-09-01	CC	Futures	2160.0	2166.0	2130.0	2143.0	21546.0
2016-09-01	CNH	Futures	7.2337	7.2337	7.2332	7.2332	1.0
2016-09-01	CSC	Futures	3.859	3.882	3.854	3.882	27.0
2016-09-01	CT	Futures	74.76	77.12	74.75	77.04	28.0
2016-09-01	DC	Futures	30.78	30.93	30.55	30.89	163.0
2016-09-01	DX	Futures	89.299	89.513	88.909	88.969	19219.0
2016-09-01	E1	Futures	1.27329	1.28043	1.26753	1.27867	30792.0
2016-09-01	E6	Futures	1.29981	1.30517	1.29609	1.30441	174294.0
2016-09-01	E7	Futures	1.293	1.2982	1.2893	1.2975	2583.0
2016-09-01	EBM	Futures	186.75	189.75	186.75	189.45	6522.0
2016-09-01	ED	Futures	95.6147	95.6316	95.6075	95.6243	318565.0
2016-09-01	ER	Futures	98.303	98.308	98.303	98.303	22325.0
2016-09-01	EW	Futures	1658.4	1666.8	1644.5	1656.1	18487.0
2016-09-01	FBON	Futures	124.14	124.22	123.61	123.69	1570.0
2016-09-01	FBTP	Futures	110.48	110.63	110.13	110.21	130413.0
2016-09-01	FBTS	Futures	101.32	101.338	101.275	101.284	31068.0
2016-09-01	FCE	Futures	3883.4	3923.5	3862.0	3878.1	97082.0
2016-09-01	FDAX	Futures	11293.2	11362.9	11161.2	11198.5	99349.0
2016-09-01	FDXM	Futures	11009.4	11075.8	10879.7	10915.5	25600.0
2016-09-01	FESX	Futures	2372.9	2392.5	2352.5	2360.4	1136448.0
2016-09-01	FGBL	Futures	150.5	150.7	150.22	150.61	928286.0
2016-09-01	FGBM	Futures	128.86	128.94	128.78	128.93	584283.0
2016-09-01	FGBS	Futures	111.877	111.892	111.862	111.882	377859.0
2016-09-01	FGBX	Futures	187.63	187.85	186.09	187.09	60130.0
2016-09-01	FMWO	Futures	5767.1	5776.8	5741.6	5750.1	633.0
2016-09-01	FOAT	Futures	138.21	138.35	137.94	138.31	216425.0
2016-09-01	FTDX	Futures	1655.4	1678.0	1655.4	1671.7	140.0
2016-09-01	FTI	Futures	411.19	414.04	408.21	409.57	33079.0
2016-09-01	FTUK	Futures	5657.8	5695.4	5607.8	5626.9	113070.0
2016-09-01	FVSA	Futures	1843.34	1890.94	1808.72	1860.65	12636.0
2016-09-01	FXXP	Futures	278.9	280.9	277.3	278.0	53438.0
2016-09-01	G	Futures	117.12	117.19	116.51	116.89	227863.0
2016-09-01	GF	Futures	281.814	282.468	275.073	276.281	1975.0
2016-09-01	GSCI	Futures	491.43	491.43	484.2	484.98	173.0
2016-09-01	HE	Futures	86.818	88.34	86.023	87.614	17476.0

> showing 50 of 108 rows — these rows as CSV

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