PREVIEW / futures_daily / 2016-09-23

all futures daily files

  file:    by_date/futures_daily/2016/2016-09-23.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-23	ES	Futures	2345.17	2346.52	2331.92	2334.08	1448300.0
2016-09-23	NQ	Futures	5759.86	5762.81	5713.9	5723.62	197323.0
2016-09-23	YM	Futures	19212.7	19225.3	19074.1	19100.4	104660.0
2016-09-23	CL	Futures	50.8	51.33	48.76	49.05	718395.0
2016-09-23	GC	Futures	1719.6	1725.0	1715.9	1721.4	113260.0
2016-09-23	ZN	Futures	127.36289	127.514892	127.302089	127.469291	719773.0
2016-09-23	A6	Futures	0.77846	0.77928	0.77479	0.77571	70840.0
2016-09-23	AD	Futures	0.78533	0.78641	0.7774	0.77811	83469.0
2016-09-23	ALI	Futures	2153.06	2153.06	2153.06	2153.06	0.0
2016-09-23	B	Futures	37.28	37.94	35.89	36.08	306857.0
2016-09-23	B6	Futures	1.3787	1.38	1.3615	1.3666	97152.0
2016-09-23	BFX	Futures	4272.4	4273.0	4272.4	4273.0	1.0
2016-09-23	BR	Futures	0.20777	0.2088	0.20777	0.20859	5.0
2016-09-23	BZ	Futures	37.13	37.77	35.76	35.93	39822.0
2016-09-23	C	Futures	2477.0	2490.0	2408.0	2443.0	17320.0
2016-09-23	CB	Futures	252.948	252.948	250.778	252.917	6.0
2016-09-23	CC	Futures	2156.0	2163.0	2079.0	2109.0	23720.0
2016-09-23	CNH	Futures	7.2192	7.2241	7.2192	7.2226	26.0
2016-09-23	CSC	Futures	3.827	3.833	3.81	3.813	103.0
2016-09-23	CT	Futures	80.1	80.1	77.24	78.25	106.0
2016-09-23	DC	Futures	30.22	30.32	29.99	30.09	198.0
2016-09-23	DX	Futures	88.707	88.982	88.679	88.783	16219.0
2016-09-23	E1	Futures	1.29191	1.29228	1.28468	1.29079	16184.0
2016-09-23	E6	Futures	1.3039	1.30761	1.30211	1.30663	129823.0
2016-09-23	E7	Futures	1.2966	1.3005	1.2952	1.2996	2290.0
2016-09-23	EBM	Futures	189.47	190.94	189.17	189.76	10103.0
2016-09-23	ED	Futures	95.6442	95.6586	95.6393	95.6538	145159.0
2016-09-23	ER	Futures	98.288	98.288	98.279	98.283	79498.0
2016-09-23	EW	Futures	1659.7	1660.4	1644.7	1646.0	13909.0
2016-09-23	FBON	Futures	125.16	125.17	124.74	124.78	441.0
2016-09-23	FBTP	Futures	110.11	110.14	109.79	109.86	65673.0
2016-09-23	FBTS	Futures	101.338	101.347	101.32	101.338	10561.0
2016-09-23	FCE	Futures	3993.8	4002.3	3968.5	3981.8	71612.0
2016-09-23	FDAX	Futures	11277.6	11277.6	11196.2	11220.5	74543.0
2016-09-23	FDXM	Futures	11246.9	11249.0	11173.1	11196.3	26770.0
2016-09-23	FESX	Futures	2431.0	2431.0	2411.8	2418.2	824679.0
2016-09-23	FGBL	Futures	150.73	150.91	150.63	150.68	484484.0
2016-09-23	FGBM	Futures	129.06	129.14	129.04	129.09	311458.0
2016-09-23	FGBS	Futures	111.932	111.952	111.922	111.937	177976.0
2016-09-23	FGBX	Futures	187.14	188.26	186.99	187.22	25617.0
2016-09-23	FMWO	Futures	5775.1	5784.8	5775.1	5778.8	73.0
2016-09-23	FOAT	Futures	138.5	138.68	138.41	138.44	75292.0
2016-09-23	FTDX	Futures	1770.0	1771.5	1764.1	1766.1	110.0
2016-09-23	FTI	Futures	417.24	417.7	415.5	416.64	18797.0
2016-09-23	FTUK	Futures	5797.6	5809.4	5777.3	5802.2	85027.0
2016-09-23	FVSA	Futures	1487.17	1490.75	1455.0	1469.3	8251.0
2016-09-23	FXXP	Futures	285.6	285.7	283.2	283.8	14855.0
2016-09-23	G	Futures	116.45	116.7	116.35	116.41	103650.0
2016-09-23	GF	Futures	271.279	273.755	264.317	273.084	6583.0
2016-09-23	GSCI	Futures	508.75	509.25	499.09	499.09	31.0

> showing 50 of 109 rows — these rows as CSV

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