PREVIEW / futures_daily / 2017-10-11

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-11.parquet
  size:    9 KB
  rows:    107

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
2017-10-11	ES	Futures	2772.26	2777.43	2767.37	2776.88	818238.0
2017-10-11	NQ	Futures	7123.43	7148.69	7110.22	7144.57	180901.0
2017-10-11	YM	Futures	24055.6	24096.7	24032.3	24093.6	68158.0
2017-10-11	CL	Futures	51.62	52.1	51.28	51.98	651948.0
2017-10-11	GC	Futures	1642.3	1648.9	1637.3	1640.0	261355.0
2017-10-11	ZN	Futures	123.362719	123.593793	123.301099	123.470554	1123947.0
2017-10-11	A6	Futures	0.79967	0.80286	0.79885	0.8008	82320.0
2017-10-11	AD	Futures	0.8133	0.81742	0.81228	0.81585	54749.0
2017-10-11	B	Futures	39.94	40.32	39.65	40.21	310139.0
2017-10-11	B6	Futures	1.3795	1.3827	1.3765	1.3808	79569.0
2017-10-11	BZ	Futures	39.6	39.99	39.34	39.88	21840.0
2017-10-11	C	Futures	1515.0	1551.0	1515.0	1549.0	13861.0
2017-10-11	CB	Futures	299.186	301.706	299.186	301.706	24.0
2017-10-11	CC	Futures	1527.0	1572.0	1519.0	1557.0	29019.0
2017-10-11	CNH	Futures	6.7578	6.7747	6.7578	6.7747	36.0
2017-10-11	CSC	Futures	3.456	3.46	3.447	3.447	48.0
2017-10-11	CT	Futures	81.33	81.57	80.41	80.73	8776.0
2017-10-11	DC	Futures	28.16	28.23	27.86	27.96	167.0
2017-10-11	DX	Futures	87.026	87.148	86.703	86.806	20789.0
2017-10-11	E1	Futures	1.25939	1.26392	1.25731	1.26184	19425.0
2017-10-11	E6	Futures	1.35213	1.35926	1.3507	1.35749	226345.0
2017-10-11	E7	Futures	1.3453	1.3522	1.3437	1.3504	4433.0
2017-10-11	EBM	Futures	175.32	175.59	173.7	174.51	20256.0
2017-10-11	ED	Futures	95.4939	95.4939	95.4842	95.4891	212967.0
2017-10-11	ER	Futures	98.337	98.342	98.337	98.342	24379.0
2017-10-11	EW	Futures	1932.4	1936.5	1929.9	1934.5	7970.0
2017-10-11	FBON	Futures	124.46	124.5	124.15	124.4	732.0
2017-10-11	FBTP	Futures	108.86	109.02	108.6	108.91	84391.0
2017-10-11	FBTS	Futures	103.283	103.283	103.237	103.255	33142.0
2017-10-11	FCE	Futures	4818.5	4819.0	4782.2	4804.6	58749.0
2017-10-11	FDAX	Futures	13631.8	13640.2	13574.5	13626.0	50409.0
2017-10-11	FDIV	Futures	152.0	152.0	152.0	152.0	30.0
2017-10-11	FDXM	Futures	13515.7	13525.1	13459.4	13511.0	14487.0
2017-10-11	FESX	Futures	2940.1	2940.1	2921.3	2936.0	638245.0
2017-10-11	FEU3	Futures	99.011	99.011	99.006	99.006	1.0
2017-10-11	FGBL	Futures	149.1	149.24	148.97	149.11	568499.0
2017-10-11	FGBM	Futures	129.53	129.6	129.46	129.54	458041.0
2017-10-11	FGBS	Futures	112.417	112.437	112.402	112.417	203942.0
2017-10-11	FGBX	Futures	166.91	167.24	166.48	166.83	28946.0
2017-10-11	FMWO	Futures	6715.5	6738.0	6714.4	6729.7	2110.0
2017-10-11	FOAT	Futures	136.36	136.48	136.24	136.38	78622.0
2017-10-11	FTDX	Futures	2497.0	2507.9	2491.5	2504.5	35.0
2017-10-11	FTI	Futures	499.22	500.47	499.22	500.24	481.0
2017-10-11	FTUK	Futures	6519.8	6521.1	6491.1	6503.7	71730.0
2017-10-11	FVSA	Futures	377.43	385.95	376.02	376.02	22907.0
2017-10-11	FXXP	Futures	331.6	331.6	329.9	330.6	32806.0
2017-10-11	G	Futures	113.26	113.37	113.13	113.31	144318.0
2017-10-11	GF	Futures	335.939	337.609	332.922	335.508	6212.0
2017-10-11	GSCI	Futures	469.56	470.8	468.74	470.8	2689.0
2017-10-11	HE	Futures	91.768	92.839	91.436	92.285	17478.0

> showing 50 of 107 rows — these rows as CSV

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