PREVIEW / futures_daily / 2019-05-20

all futures daily files

  file:    by_date/futures_daily/2019/2019-05-20.parquet
  size:    10 KB
  rows:    119

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
2019-05-20	ES	Futures	3090.92	3107.12	3059.6	3072.02	1659139.0
2019-05-20	NQ	Futures	8658.53	8709.8	8481.96	8516.81	634294.0
2019-05-20	YM	Futures	27208.0	27340.0	26973.7	27123.6	246483.0
2019-05-20	CL	Futures	64.75	65.64	64.25	64.87	678773.0
2019-05-20	GC	Futures	1590.1	1591.6	1584.8	1589.8	212182.0
2019-05-20	ZN	Futures	123.818578	123.911815	123.569946	123.601025	1263291.0
2019-05-20	A6	Futures	0.71158	0.71518	0.71065	0.7123	104921.0
2019-05-20	AD	Futures	0.75216	0.75408	0.75175	0.75312	52424.0
2019-05-20	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2019-05-20	B	Futures	53.42	54.09	52.76	53.03	301978.0
2019-05-20	B6	Futures	1.3061	1.3086	1.3043	1.3054	77917.0
2019-05-20	BR	Futures	0.19564	0.19592	0.19396	0.19504	3450.0
2019-05-20	BTC	Futures	12487.9	12959.6	11784.2	12139.9	15195.0
2019-05-20	BZ	Futures	53.17	53.93	52.61	52.89	48963.0
2019-05-20	C	Futures	1677.0	1698.0	1660.0	1692.0	7719.0
2019-05-20	CB	Futures	284.106	284.106	283.029	283.508	17.0
2019-05-20	CC	Futures	1584.0	1611.0	1570.0	1607.0	16428.0
2019-05-20	CNH	Futures	6.9575	6.9589	6.9381	6.9501	935.0
2019-05-20	CSC	Futures	3.003	3.027	2.998	3.001	104.0
2019-05-20	CT	Futures	69.24	71.17	68.93	71.09	17056.0
2019-05-20	DC	Futures	25.26	25.52	25.23	25.29	530.0
2019-05-20	DX	Futures	93.786	93.815	93.666	93.709	7309.0
2019-05-20	E1	Futures	1.15746	1.16061	1.15594	1.16026	17021.0
2019-05-20	E6	Futures	1.22756	1.22932	1.22663	1.2285	107746.0
2019-05-20	E7	Futures	1.2214	1.2232	1.2206	1.2224	3482.0
2019-05-20	EBM	Futures	201.23	203.25	201.23	202.67	15102.0
2019-05-20	ED	Futures	95.1941	95.1965	95.1868	95.1868	150996.0
2019-05-20	ER	Futures	98.426	98.43	98.421	98.426	39933.0
2019-05-20	EW	Futures	2008.8	2018.6	1985.6	1991.6	12200.0
2019-05-20	FBON	Futures	137.83	137.83	137.61	137.65	312.0
2019-05-20	FBTP	Futures	115.06	115.29	114.71	114.84	67947.0
2019-05-20	FBTS	Futures	105.703	105.76	105.56	105.589	57265.0
2019-05-20	FCE	Futures	4874.8	4884.7	4786.7	4811.2	92044.0
2019-05-20	FDAX	Futures	12862.2	12912.2	12617.4	12656.9	124069.0
2019-05-20	FDIV	Futures	146.6	146.6	144.98	145.02	61.0
2019-05-20	FDXM	Futures	12758.0	12800.8	12509.7	12547.2	58493.0
2019-05-20	FESX	Futures	2970.6	2977.6	2916.5	2923.4	1034958.0
2019-05-20	FGBL	Futures	161.16	161.25	160.82	160.98	551282.0
2019-05-20	FGBM	Futures	133.55	133.58	133.43	133.51	315417.0
2019-05-20	FGBS	Futures	112.875	112.89	112.855	112.87	235315.0
2019-05-20	FGBX	Futures	197.62	197.72	196.45	196.88	32352.0
2019-05-20	FMWO	Futures	7127.0	7134.0	7055.3	7077.3	1308.0
2019-05-20	FOAT	Futures	147.7	147.77	147.41	147.44	95885.0
2019-05-20	FTDX	Futures	2828.6	2828.6	2790.1	2792.5	164.0
2019-05-20	FTI	Futures	524.85	526.26	517.11	519.35	30066.0
2019-05-20	FTUK	Futures	6738.5	6747.2	6651.3	6683.9	77722.0
2019-05-20	FVSA	Futures	217.41	230.96	216.7	227.39	59496.0
2019-05-20	FXXP	Futures	339.9	340.4	335.0	336.0	55916.0
2019-05-20	G	Futures	118.84	118.93	118.62	118.68	114425.0
2019-05-20	GF	Futures	286.265	286.265	282.046	284.106	5975.0

> showing 50 of 119 rows — these rows as CSV

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