PREVIEW / futures_daily / 2017-08-11

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-11.parquet
  size:    9 KB
  rows:    108

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-08-11	ES	Futures	2645.87	2658.91	2641.25	2651.85	1670104.0
2017-08-11	NQ	Futures	6781.7	6871.92	6772.29	6863.1	394754.0
2017-08-11	YM	Futures	23062.9	23133.8	23034.4	23095.7	147335.0
2017-08-11	CL	Futures	49.91	50.38	49.35	50.22	804237.0
2017-08-11	GC	Futures	1644.6	1651.7	1637.2	1646.5	265329.0
2017-08-11	ZN	Futures	124.765623	124.965692	124.642504	124.904132	1478912.0
2017-08-11	A6	Futures	0.80835	0.81215	0.80485	0.81081	109539.0
2017-08-11	AD	Futures	0.79857	0.80416	0.7978	0.80228	73235.0
2017-08-11	ALI	Futures	2674.19	2674.19	2674.19	2674.19	0.0
2017-08-11	B	Futures	36.33	36.57	35.88	36.44	245314.0
2017-08-11	B6	Futures	1.3577	1.3634	1.3538	1.3615	106463.0
2017-08-11	BR	Futures	0.23306	0.23429	0.22876	0.23355	2356.0
2017-08-11	BZ	Futures	36.01	36.25	35.58	36.13	25318.0
2017-08-11	C	Futures	1548.0	1566.0	1534.0	1554.0	14492.0
2017-08-11	CB	Futures	325.09	328.283	325.09	326.367	19.0
2017-08-11	CC	Futures	1452.0	1476.0	1445.0	1468.0	31399.0
2017-08-11	CNH	Futures	6.9004	6.9118	6.9004	6.9024	159.0
2017-08-11	CSC	Futures	3.534	3.579	3.534	3.579	45.0
2017-08-11	CT	Futures	80.66	81.52	80.61	80.81	13.0
2017-08-11	DC	Futures	29.27	29.82	29.25	29.75	454.0
2017-08-11	DX	Futures	87.116	87.228	86.682	86.799	28525.0
2017-08-11	E1	Futures	1.27911	1.28476	1.2769	1.28058	37799.0
2017-08-11	E6	Futures	1.35133	1.35992	1.34852	1.35717	216624.0
2017-08-11	E7	Futures	1.344	1.3527	1.3415	1.3501	5562.0
2017-08-11	EBM	Futures	179.27	179.27	178.15	178.71	12210.0
2017-08-11	ED	Futures	95.5983	95.6032	95.5886	95.5983	209242.0
2017-08-11	ER	Futures	98.342	98.342	98.337	98.342	33385.0
2017-08-11	EW	Futures	1810.4	1818.5	1804.1	1816.2	16299.0
2017-08-11	FBON	Futures	125.12	125.15	124.94	125.01	276.0
2017-08-11	FBTP	Futures	109.56	109.56	108.97	109.2	63906.0
2017-08-11	FBTS	Futures	103.027	103.027	103.0	103.009	27300.0
2017-08-11	FCE	Futures	4559.3	4573.2	4530.6	4543.6	104805.0
2017-08-11	FDAX	Futures	12561.3	12680.2	12557.0	12641.3	105210.0
2017-08-11	FDXM	Futures	12488.1	12602.2	12481.8	12563.5	37176.0
2017-08-11	FESX	Futures	2781.8	2791.6	2766.3	2774.5	1187720.0
2017-08-11	FGBL	Futures	149.29	149.57	149.16	149.47	543758.0
2017-08-11	FGBM	Futures	129.46	129.61	129.41	129.59	278530.0
2017-08-11	FGBS	Futures	112.337	112.387	112.327	112.382	203325.0
2017-08-11	FGBX	Futures	169.46	170.14	168.95	169.74	30900.0
2017-08-11	FMWO	Futures	6457.9	6473.3	6441.2	6459.1	2363.0
2017-08-11	FOAT	Futures	136.35	136.52	136.25	136.46	81270.0
2017-08-11	FTDX	Futures	2216.6	2223.1	2198.5	2218.1	271.0
2017-08-11	FTI	Futures	481.21	481.91	477.55	477.97	2235.0
2017-08-11	FTUK	Futures	6335.5	6342.9	6288.0	6297.9	115055.0
2017-08-11	FVSA	Futures	584.41	680.82	548.81	563.64	71342.0
2017-08-11	FXXP	Futures	317.8	318.3	315.8	316.1	77248.0
2017-08-11	G	Futures	116.06	116.44	115.96	116.14	150102.0
2017-08-11	GF	Futures	310.564	313.579	308.646	311.825	7257.0
2017-08-11	GSCI	Futures	453.01	458.82	452.77	457.74	2521.0
2017-08-11	HE	Futures	95.458	96.402	94.933	96.053	13754.0

> showing 50 of 108 rows — these rows as CSV

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