PREVIEW / futures_daily / 2016-09-19

all futures daily files

  file:    by_date/futures_daily/2016/2016-09-19.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-19	ES	Futures	2306.23	2321.92	2301.37	2307.04	1527880.0
2016-09-19	NQ	Futures	5674.42	5706.24	5636.41	5650.26	235031.0
2016-09-19	YM	Futures	18961.8	19080.4	18905.1	18955.5	122943.0
2016-09-19	CL	Futures	48.19	49.29	48.14	48.36	515314.0
2016-09-19	GC	Futures	1684.9	1695.9	1684.1	1690.8	115841.0
2016-09-19	ZN	Futures	126.982883	127.058885	126.709279	126.876482	577146.0
2016-09-19	A6	Futures	0.76224	0.77091	0.76214	0.76836	77201.0
2016-09-19	AD	Futures	0.77535	0.78026	0.77519	0.77632	54446.0
2016-09-19	ALI	Futures	2090.12	2090.12	2090.12	2090.12	0.0
2016-09-19	B	Futures	36.17	36.9	36.05	36.13	209911.0
2016-09-19	B6	Futures	1.3718	1.3805	1.3712	1.3742	72723.0
2016-09-19	BFX	Futures	4181.3	4197.9	4181.3	4191.4	5.0
2016-09-19	BR	Futures	0.20496	0.20629	0.20496	0.20544	18.0
2016-09-19	BZ	Futures	35.93	36.73	35.9	35.97	19674.0
2016-09-19	C	Futures	2402.0	2461.0	2402.0	2451.0	10150.0
2016-09-19	CB	Futures	249.848	250.375	247.988	248.019	39.0
2016-09-19	CC	Futures	2083.0	2136.0	2083.0	2124.0	21005.0
2016-09-19	CNH	Futures	7.2327	7.2352	7.2254	7.2254	42.0
2016-09-19	CSC	Futures	3.868	3.868	3.833	3.833	36.0
2016-09-19	CT	Futures	78.34	78.71	78.14	78.14	9.0
2016-09-19	DC	Futures	30.6	30.64	30.34	30.37	114.0
2016-09-19	DX	Futures	89.363	89.363	88.944	89.127	13261.0
2016-09-19	E1	Futures	1.27746	1.27995	1.27521	1.27795	13428.0
2016-09-19	E6	Futures	1.29782	1.30298	1.29747	1.30054	116856.0
2016-09-19	E7	Futures	1.2913	1.2958	1.2905	1.2935	2920.0
2016-09-19	EBM	Futures	188.29	190.35	188.0	189.17	19419.0
2016-09-19	ED	Futures	95.6538	95.6538	95.6297	95.6393	289284.0
2016-09-19	ER	Futures	98.288	98.293	98.279	98.283	86941.0
2016-09-19	EW	Futures	1615.6	1636.9	1614.5	1626.5	17646.0
2016-09-19	FBON	Futures	123.69	124.18	123.69	124.06	491.0
2016-09-19	FBTP	Futures	108.71	108.98	108.57	108.89	66908.0
2016-09-19	FBTS	Futures	101.185	101.23	101.185	101.212	13430.0
2016-09-19	FCE	Futures	3867.5	3901.8	3862.2	3896.9	66007.0
2016-09-19	FDAX	Futures	10922.5	10965.8	10899.3	10951.6	73214.0
2016-09-19	FDXM	Futures	10895.8	10942.2	10874.7	10927.9	22095.0
2016-09-19	FESX	Futures	2354.1	2369.3	2351.7	2366.1	867487.0
2016-09-19	FGBL	Futures	149.61	149.84	149.4	149.51	469634.0
2016-09-19	FGBM	Futures	128.83	128.93	128.79	128.82	327804.0
2016-09-19	FGBS	Futures	111.902	111.932	111.897	111.907	117171.0
2016-09-19	FGBX	Futures	181.74	182.0	180.6	181.49	36102.0
2016-09-19	FMWO	Futures	5678.4	5695.3	5678.4	5692.9	344.0
2016-09-19	FOAT	Futures	137.39	137.56	137.18	137.29	103752.0
2016-09-19	FTDX	Futures	1746.0	1746.0	1734.7	1739.1	227.0
2016-09-19	FTI	Futures	404.9	408.39	404.9	407.61	20261.0
2016-09-19	FTUK	Futures	5676.0	5721.6	5668.0	5715.3	101109.0
2016-09-19	FVSA	Futures	1673.07	1673.07	1619.44	1633.74	28570.0
2016-09-19	FXXP	Futures	279.2	280.6	278.6	280.3	14781.0
2016-09-19	G	Futures	115.08	115.17	114.9	115.0	107980.0
2016-09-19	GF	Futures	276.23	276.23	270.454	271.846	3491.0
2016-09-19	GSCI	Futures	498.94	501.0	495.18	495.53	524.0

> showing 50 of 109 rows — these rows as CSV

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