PREVIEW / futures_daily / 2019-08-01

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-01.parquet
  size:    10 KB
  rows:    122

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-08-01	ES	Futures	3205.07	3252.55	3177.28	3185.38	2736926.0
2019-08-01	NQ	Futures	9019.48	9227.29	8953.56	8989.83	772956.0
2019-08-01	YM	Futures	28088.2	28505.0	27838.3	27870.8	354565.0
2019-08-01	CL	Futures	59.03	59.17	54.68	55.05	886748.0
2019-08-01	GC	Futures	1758.5	1798.8	1741.9	1766.9	587561.0
2019-08-01	ZN	Futures	126.911551	128.217994	126.553835	128.093571	3135151.0
2019-08-01	A6	Futures	0.70501	0.70758	0.70007	0.7011	150027.0
2019-08-01	AD	Futures	0.76474	0.76524	0.76151	0.76232	96854.0
2019-08-01	ALI	Futures	2188.76	2189.98	2188.76	2189.98	14.0
2019-08-01	B	Futures	48.35	48.69	45.28	45.64	433719.0
2019-08-01	B6	Futures	1.243	1.245	1.2355	1.2426	147288.0
2019-08-01	BFX	Futures	4152.1	4176.8	4152.1	4176.8	5.0
2019-08-01	BR	Futures	0.20926	0.20926	0.20647	0.20731	6028.0
2019-08-01	BTC	Futures	13988.6	14683.9	13788.9	14387.9	1880.0
2019-08-01	BZ	Futures	47.87	48.04	44.7	45.05	63060.0
2019-08-01	C	Futures	1718.0	1745.0	1712.0	1716.0	10281.0
2019-08-01	CB	Futures	278.617	278.617	278.617	278.617	1.0
2019-08-01	CC	Futures	1557.0	1576.0	1541.0	1551.0	28279.0
2019-08-01	CNH	Futures	6.9117	6.9723	6.9054	6.9658	968.0
2019-08-01	CSC	Futures	3.073	3.087	3.07	3.078	96.0
2019-08-01	CT	Futures	63.22	63.22	60.84	61.07	25.0
2019-08-01	DC	Futures	25.94	25.99	25.8	25.95	430.0
2019-08-01	DX	Futures	94.707	95.029	94.394	94.494	26678.0
2019-08-01	E1	Futures	1.17119	1.17756	1.16713	1.17629	37414.0
2019-08-01	E6	Futures	1.21218	1.21464	1.20705	1.21338	283259.0
2019-08-01	E7	Futures	1.206	1.2082	1.2006	1.207	5604.0
2019-08-01	EBM	Futures	201.81	201.81	199.22	199.22	18685.0
2019-08-01	ED	Futures	95.2308	95.3428	95.2113	95.3038	720662.0
2019-08-01	ER	Futures	98.533	98.543	98.529	98.533	152907.0
2019-08-01	EW	Futures	2060.8	2078.9	2023.0	2033.4	24482.0
2019-08-01	FBON	Futures	144.59	144.59	143.95	144.45	236.0
2019-08-01	FBTP	Futures	125.45	125.75	124.72	125.44	88098.0
2019-08-01	FBTS	Futures	107.628	107.753	107.523	107.676	54284.0
2019-08-01	FCE	Futures	5013.2	5069.2	4964.4	5062.4	125691.0
2019-08-01	FDAX	Futures	12735.9	12909.6	12659.5	12879.6	130447.0
2019-08-01	FDIV	Futures	144.47	145.3	144.37	145.3	12.0
2019-08-01	FDXM	Futures	12598.7	12750.6	12505.1	12720.9	68907.0
2019-08-01	FESX	Futures	3002.9	3047.5	2982.8	3039.6	1122849.0
2019-08-01	FEU3	Futures	99.164	99.164	99.159	99.159	5.0
2019-08-01	FGBL	Futures	166.43	167.24	166.14	166.82	728992.0
2019-08-01	FGBM	Futures	134.96	135.19	134.83	135.03	401915.0
2019-08-01	FGBS	Futures	113.126	113.162	113.091	113.126	177963.0
2019-08-01	FGBX	Futures	215.34	218.72	214.41	217.77	64318.0
2019-08-01	FMWO	Futures	7347.5	7416.8	7282.9	7408.7	4065.0
2019-08-01	FOAT	Futures	153.3	153.81	153.09	153.7	184001.0
2019-08-01	FTDX	Futures	2872.0	2901.6	2863.1	2900.1	74.0
2019-08-01	FTI	Futures	539.19	541.09	529.6	540.61	35742.0
2019-08-01	FTUK	Futures	6924.7	6964.8	6849.4	6936.2	120570.0
2019-08-01	FVSA	Futures	175.6	205.89	172.51	175.6	51838.0
2019-08-01	FXXP	Futures	343.5	347.2	340.9	346.4	67690.0

> showing 50 of 122 rows — these rows as CSV

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