PREVIEW / futures_daily / 2019-08-23

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-23.parquet
  size:    10 KB
  rows:    120

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-23	ES	Futures	3151.12	3168.92	3058.05	3081.25	2864662.0
2019-08-23	NQ	Futures	8871.82	8936.58	8574.78	8640.12	763864.0
2019-08-23	YM	Futures	27536.9	27665.0	26767.3	26954.2	339653.0
2019-08-23	CL	Futures	56.85	57.1	54.68	55.64	807151.0
2019-08-23	GC	Futures	1861.2	1900.0	1854.0	1896.7	472999.0
2019-08-23	ZN	Futures	129.648859	130.550927	129.27559	130.348739	3167656.0
2019-08-23	A6	Futures	0.69586	0.69781	0.69349	0.69524	87526.0
2019-08-23	AD	Futures	0.75818	0.75949	0.75592	0.75849	101652.0
2019-08-23	ALI	Futures	2164.77	2164.77	2164.77	2164.77	0.0
2019-08-23	B	Futures	45.35	45.48	43.98	44.77	321242.0
2019-08-23	B6	Futures	1.2521	1.2562	1.2459	1.2553	125381.0
2019-08-23	BR	Futures	0.19592	0.19712	0.1924	0.19396	10283.0
2019-08-23	BTC	Futures	14050.5	14504.9	13837.1	14401.6	3319.0
2019-08-23	BZ	Futures	44.71	44.89	43.43	44.19	41613.0
2019-08-23	C	Futures	1555.0	1561.0	1547.0	1550.0	1135.0
2019-08-23	CB	Futures	265.697	266.877	265.342	265.342	30.0
2019-08-23	CC	Futures	1459.0	1481.0	1456.0	1469.0	17832.0
2019-08-23	CNH	Futures	7.0958	7.1458	7.0915	7.144	1887.0
2019-08-23	CSC	Futures	3.01	3.011	2.989	3.0	124.0
2019-08-23	CT	Futures	57.7	58.01	57.25	57.25	7.0
2019-08-23	DC	Futures	25.35	25.41	25.16	25.28	510.0
2019-08-23	DX	Futures	94.447	94.793	93.83	93.903	29650.0
2019-08-23	E1	Futures	1.18139	1.19357	1.1764	1.19264	34806.0
2019-08-23	E6	Futures	1.2106	1.21878	1.2076	1.21796	215588.0
2019-08-23	E7	Futures	1.2043	1.2124	1.2013	1.2116	5489.0
2019-08-23	EBM	Futures	190.58	191.44	190.29	190.58	9749.0
2019-08-23	ED	Futures	95.3525	95.4207	95.3452	95.4061	463470.0
2019-08-23	ER	Futures	98.529	98.543	98.524	98.538	73222.0
2019-08-23	EW	Futures	1982.3	1992.7	1923.1	1928.9	23138.0
2019-08-23	FBON	Futures	145.6	146.09	145.38	146.07	213.0
2019-08-23	FBTP	Futures	128.19	128.48	127.45	128.13	61264.0
2019-08-23	FBTS	Futures	107.743	107.858	107.59	107.753	29821.0
2019-08-23	FCE	Futures	4902.2	4913.1	4786.7	4824.3	102422.0
2019-08-23	FDAX	Futures	12379.4	12445.8	12136.7	12250.4	138919.0
2019-08-23	FDIV	Futures	141.59	141.59	139.92	139.97	282.0
2019-08-23	FDXM	Futures	12212.9	12291.9	11988.3	12099.5	62870.0
2019-08-23	FESX	Futures	2947.9	2963.6	2885.9	2916.5	1178464.0
2019-08-23	FGBL	Futures	169.26	170.04	168.76	169.77	648613.0
2019-08-23	FGBM	Futures	135.82	136.08	135.68	136.02	379343.0
2019-08-23	FGBS	Futures	113.272	113.363	113.257	113.348	260380.0
2019-08-23	FGBX	Futures	226.92	229.6	225.01	228.02	65463.0
2019-08-23	FMWO	Futures	7197.5	7199.8	7003.7	7097.2	2403.0
2019-08-23	FOAT	Futures	155.39	156.0	155.09	155.83	88017.0
2019-08-23	FTDX	Futures	2723.9	2729.9	2682.0	2686.4	294.0
2019-08-23	FTI	Futures	519.56	520.65	508.25	512.92	37882.0
2019-08-23	FTUK	Futures	6570.1	6631.1	6480.1	6559.0	109621.0
2019-08-23	FVSA	Futures	210.07	242.05	208.19	228.88	58587.0
2019-08-23	FXXP	Futures	337.4	337.4	329.5	332.9	95277.0
2019-08-23	G	Futures	122.14	122.8	121.78	122.52	252787.0
2019-08-23	GF	Futures	277.613	277.613	268.456	271.153	6001.0

> showing 50 of 120 rows — these rows as CSV

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