PREVIEW / futures_daily / 2018-06-19

all futures daily files

  file:    by_date/futures_daily/2018/2018-06-19.parquet
  size:    10 KB
  rows:    114

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
2018-06-19	ES	Futures	3017.45	3019.62	2971.29	3004.42	1657081.0
2018-06-19	NQ	Futures	8481.94	8486.6	8344.94	8455.41	450281.0
2018-06-19	YM	Futures	26343.4	26360.2	25888.2	26042.0	268359.0
2018-06-19	CL	Futures	66.55	66.59	65.06	65.74	629988.0
2018-06-19	GC	Futures	1635.0	1642.8	1624.7	1632.4	289574.0
2018-06-19	ZN	Futures	119.012829	119.525614	118.99729	119.183757	1551816.0
2018-06-19	A6	Futures	0.76357	0.76408	0.75555	0.75884	126281.0
2018-06-19	AD	Futures	0.76844	0.76865	0.76328	0.76383	74859.0
2018-06-19	B	Futures	55.1	55.32	54.52	54.98	290589.0
2018-06-19	B6	Futures	1.372	1.3752	1.3623	1.364	109033.0
2018-06-19	BR	Futures	0.19809	0.2022	0.19809	0.2022	121.0
2018-06-19	BTC	Futures	9535.8	9720.6	9450.5	9571.3	1563.0
2018-06-19	BZ	Futures	54.71	54.79	54.01	54.46	33282.0
2018-06-19	C	Futures	1595.0	1629.0	1583.0	1623.0	2298.0
2018-06-19	CB	Futures	284.276	287.245	282.657	282.837	51.0
2018-06-19	CC	Futures	1770.0	1788.0	1739.0	1758.0	16736.0
2018-06-19	CNH	Futures	6.5514	6.592	6.5514	6.5767	67.0
2018-06-19	CSC	Futures	3.367	3.381	3.341	3.381	102.0
2018-06-19	CT	Futures	99.35	100.2	94.71	94.71	9421.0
2018-06-19	DC	Futures	26.64	26.86	26.46	26.86	222.0
2018-06-19	DX	Futures	89.354	89.923	89.193	89.718	26769.0
2018-06-19	E1	Futures	1.20935	1.21424	1.20696	1.21042	19351.0
2018-06-19	E6	Futures	1.30855	1.31118	1.29837	1.30324	295487.0
2018-06-19	E7	Futures	1.3017	1.3045	1.2918	1.2966	6833.0
2018-06-19	EBM	Futures	180.99	181.25	178.37	179.68	37104.0
2018-06-19	ED	Futures	94.9767	95.001	94.9718	94.9718	262165.0
2018-06-19	ER	Futures	98.362	98.362	98.352	98.357	92763.0
2018-06-19	EW	Futures	2118.6	2119.7	2089.6	2114.4	15581.0
2018-06-19	FBON	Futures	129.77	130.14	129.77	129.88	123.0
2018-06-19	FBTP	Futures	108.84	108.88	108.15	108.58	59515.0
2018-06-19	FBTS	Futures	103.134	103.134	102.819	102.921	38225.0
2018-06-19	FCE	Futures	4848.3	4864.0	4815.0	4838.4	87881.0
2018-06-19	FDAX	Futures	13251.7	13296.6	13142.5	13249.6	111783.0
2018-06-19	FDIV	Futures	150.74	150.88	150.74	150.88	4.0
2018-06-19	FDXM	Futures	13089.6	13126.8	12975.1	13080.3	46139.0
2018-06-19	FESX	Futures	2856.4	2875.6	2838.9	2862.2	1157377.0
2018-06-19	FEU3	Futures	99.001	99.006	99.001	99.006	70.0
2018-06-19	FGBL	Futures	152.17	152.52	152.14	152.21	721781.0
2018-06-19	FGBM	Futures	130.87	131.07	130.87	130.93	446098.0
2018-06-19	FGBS	Futures	112.693	112.723	112.688	112.703	285515.0
2018-06-19	FGBX	Futures	172.95	174.31	172.93	173.71	63990.0
2018-06-19	FMWO	Futures	6986.7	7049.6	6983.3	7029.8	573.0
2018-06-19	FOAT	Futures	140.45	140.77	140.38	140.5	146457.0
2018-06-19	FTDX	Futures	2768.1	2768.1	2722.5	2738.7	596.0
2018-06-19	FTI	Futures	512.7	513.86	508.92	511.64	30054.0
2018-06-19	FTUK	Futures	6749.3	6749.3	6659.7	6714.1	106987.0
2018-06-19	FVSA	Futures	297.39	311.97	290.59	294.48	33100.0
2018-06-19	FXXP	Futures	328.7	330.9	327.7	329.7	80647.0
2018-06-19	G	Futures	115.41	115.58	115.3	115.38	174381.0
2018-06-19	GF	Futures	306.385	310.58	304.417	309.959	7441.0

> showing 50 of 114 rows — these rows as CSV

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