PREVIEW / futures_daily / 2016-09-20

all futures daily files

  file:    by_date/futures_daily/2016/2016-09-20.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-20	ES	Futures	2307.86	2318.4	2302.72	2304.88	1385876.0
2016-09-20	NQ	Futures	5653.2	5681.19	5645.25	5655.26	195027.0
2016-09-20	YM	Futures	18961.8	19053.1	18933.4	18950.2	111843.0
2016-09-20	CL	Futures	48.23	49.17	47.48	48.57	694130.0
2016-09-20	GC	Futures	1688.8	1695.0	1687.4	1691.3	93724.0
2016-09-20	ZN	Futures	126.75488	127.134886	126.724479	126.952483	787032.0
2016-09-20	A6	Futures	0.76734	0.7702	0.76673	0.76877	64359.0
2016-09-20	AD	Futures	0.77632	0.77735	0.77386	0.77555	54673.0
2016-09-20	ALI	Futures	2078.36	2078.36	2078.36	2078.36	10.0
2016-09-20	B	Futures	36.1	36.4	35.45	36.07	298796.0
2016-09-20	B6	Futures	1.374	1.3776	1.365	1.3685	82998.0
2016-09-20	BFX	Futures	4200.9	4200.9	4197.3	4197.3	7.0
2016-09-20	BZ	Futures	35.81	36.24	35.3	35.92	28150.0
2016-09-20	C	Futures	2437.0	2473.0	2437.0	2459.0	9842.0
2016-09-20	CB	Futures	247.368	247.492	246.128	247.492	16.0
2016-09-20	CC	Futures	2122.0	2132.0	2096.0	2120.0	14302.0
2016-09-20	CNH	Futures	7.2337	7.2393	7.2337	7.2353	5.0
2016-09-20	CSC	Futures	3.838	3.921	3.833	3.916	46.0
2016-09-20	CT	Futures	77.58	80.22	77.58	80.22	13.0
2016-09-20	DC	Futures	30.32	31.18	30.2	31.1	288.0
2016-09-20	DX	Futures	89.14	89.335	88.907	89.327	16016.0
2016-09-20	E1	Futures	1.27721	1.28256	1.27608	1.27858	16300.0
2016-09-20	E6	Futures	1.30043	1.30472	1.2973	1.29817	131280.0
2016-09-20	E7	Futures	1.2935	1.2976	1.2901	1.2912	1756.0
2016-09-20	EBM	Futures	190.06	191.23	189.17	190.64	16070.0
2016-09-20	ED	Futures	95.6297	95.6393	95.6249	95.6249	332450.0
2016-09-20	ER	Futures	98.283	98.288	98.283	98.288	49516.0
2016-09-20	EW	Futures	1627.2	1634.2	1617.3	1619.1	11316.0
2016-09-20	FBON	Futures	124.1	124.65	124.08	124.5	689.0
2016-09-20	FBTP	Futures	108.89	109.56	108.89	109.39	91545.0
2016-09-20	FBTS	Futures	101.23	101.266	101.23	101.248	18337.0
2016-09-20	FCE	Futures	3880.9	3921.3	3879.1	3892.0	67532.0
2016-09-20	FDAX	Futures	10927.8	11052.5	10927.8	10988.6	82626.0
2016-09-20	FDXM	Futures	10904.2	11028.6	10904.2	10964.8	32662.0
2016-09-20	FESX	Futures	2358.1	2380.5	2357.3	2366.1	945838.0
2016-09-20	FEU3	Futures	98.966	98.966	98.966	98.966	10.0
2016-09-20	FGBL	Futures	149.42	150.0	149.42	149.9	547872.0
2016-09-20	FGBM	Futures	128.82	128.94	128.81	128.9	337780.0
2016-09-20	FGBS	Futures	111.907	111.932	111.902	111.922	181756.0
2016-09-20	FGBX	Futures	181.63	184.26	181.53	184.0	36568.0
2016-09-20	FMWO	Futures	5695.3	5702.5	5689.2	5689.2	590.0
2016-09-20	FOAT	Futures	137.21	137.81	137.19	137.7	87892.0
2016-09-20	FTDX	Futures	1741.1	1743.5	1735.2	1740.1	101.0
2016-09-20	FTI	Futures	406.23	409.4	406.1	407.43	20234.0
2016-09-20	FTUK	Futures	5692.1	5765.9	5692.1	5737.2	104342.0
2016-09-20	FVSA	Futures	1630.17	1648.04	1608.72	1633.74	15751.0
2016-09-20	FXXP	Futures	279.7	281.5	279.2	280.4	21530.0
2016-09-20	G	Futures	115.1	115.81	115.05	115.73	208012.0
2016-09-20	GF	Futures	271.64	273.187	269.526	270.506	3187.0
2016-09-20	GSCI	Futures	493.83	498.8	491.27	498.02	1172.0

> showing 50 of 109 rows — these rows as CSV

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