PREVIEW / futures_daily / 2016-11-11

all futures daily files

  file:    by_date/futures_daily/2016/2016-11-11.parquet
  size:    9 KB
  rows:    106

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-11-11	ES	Futures	2341.66	2347.6	2323.81	2337.87	1883989.0
2016-11-11	NQ	Futures	5588.38	5607.53	5517.67	5595.75	324940.0
2016-11-11	YM	Futures	19704.1	19775.5	19617.0	19727.2	205161.0
2016-11-11	CL	Futures	48.4	48.7	46.96	47.37	631135.0
2016-11-11	GC	Futures	1614.9	1623.0	1563.6	1570.8	444585.0
2016-11-11	ZN	Futures	123.897233	124.216438	123.623628	123.71483	596168.0
2016-11-11	A6	Futures	0.77581	0.77785	0.76714	0.76805	127023.0
2016-11-11	AD	Futures	0.76075	0.76142	0.75614	0.75624	87577.0
2016-11-11	ALI	Futures	2390.91	2407.25	2371.06	2373.94	80.0
2016-11-11	B	Futures	34.79	34.86	33.57	33.99	286705.0
2016-11-11	B6	Futures	1.3221	1.3351	1.3194	1.3275	121211.0
2016-11-11	BR	Futures	0.20102	0.20157	0.1942	0.20006	8282.0
2016-11-11	BZ	Futures	34.55	34.68	33.41	33.83	37821.0
2016-11-11	C	Futures	2196.0	2213.0	2178.0	2206.0	2839.0
2016-11-11	CB	Futures	241.788	244.888	241.788	244.888	22.0
2016-11-11	CC	Futures	1874.0	1894.0	1863.0	1881.0	26186.0
2016-11-11	CNH	Futures	7.3537	7.3769	7.3323	7.358	75.0
2016-11-11	CSC	Futures	4.038	4.041	3.935	3.935	58.0
2016-11-11	CT	Futures	77.69	80.03	76.53	76.67	42865.0
2016-11-11	DC	Futures	31.9	32.13	31.08	31.14	524.0
2016-11-11	DX	Futures	91.979	92.262	91.718	92.188	33351.0
2016-11-11	E1	Futures	1.264	1.26936	1.26138	1.2625	30792.0
2016-11-11	E6	Futures	1.26322	1.26791	1.25707	1.25881	187179.0
2016-11-11	E7	Futures	1.2567	1.2609	1.2502	1.252	4954.0
2016-11-11	EBM	Futures	189.76	190.94	189.47	190.06	8096.0
2016-11-11	ED	Futures	95.6297	95.6345	95.6152	95.62	160982.0
2016-11-11	ER	Futures	98.269	98.274	98.259	98.274	41991.0
2016-11-11	EW	Futures	1643.6	1663.5	1638.8	1660.7	14585.0
2016-11-11	FBON	Futures	121.16	121.59	120.8	121.08	159.0
2016-11-11	FBTP	Futures	104.56	104.59	103.23	103.49	197298.0
2016-11-11	FBTS	Futures	100.889	100.889	100.709	100.718	51203.0
2016-11-11	FCE	Futures	4049.5	4056.6	3982.7	3998.3	102010.0
2016-11-11	FDAX	Futures	11277.6	11317.2	11182.0	11261.7	111165.0
2016-11-11	FDXM	Futures	11251.1	11293.3	11158.3	11237.4	31950.0
2016-11-11	FESX	Futures	2445.4	2453.4	2408.6	2418.2	1203613.0
2016-11-11	FGBL	Futures	146.65	146.65	145.88	146.33	756875.0
2016-11-11	FGBM	Futures	128.04	128.06	127.77	127.91	555146.0
2016-11-11	FGBS	Futures	111.837	111.842	111.778	111.813	303883.0
2016-11-11	FGBX	Futures	172.53	172.53	170.18	171.71	48277.0
2016-11-11	FMWO	Futures	5692.9	5692.9	5646.9	5646.9	2790.0
2016-11-11	FOAT	Futures	133.2	133.25	131.89	132.42	184104.0
2016-11-11	FTDX	Futures	1685.7	1685.7	1652.4	1659.2	172.0
2016-11-11	FTI	Futures	412.6	412.6	404.85	405.85	298.0
2016-11-11	FTUK	Futures	5762.1	5776.5	5654.1	5667.2	157511.0
2016-11-11	FVSA	Futures	1280.02	1372.77	1273.84	1357.31	31883.0
2016-11-11	FXXP	Futures	280.7	281.1	277.3	277.8	26210.0
2016-11-11	G	Futures	110.34	111.01	110.24	110.79	138555.0
2016-11-11	GF	Futures	268.923	270.373	267.64	269.983	2715.0
2016-11-11	GSCI	Futures	480.2	481.29	477.67	477.88	3433.0
2016-11-11	HE	Futures	72.762	74.834	71.956	72.34	27993.0

> showing 50 of 106 rows — these rows as CSV

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