PREVIEW / futures_daily / 2019-07-15

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-15.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-07-15	ES	Futures	3253.63	3262.53	3248.77	3255.78	829936.0
2019-07-15	NQ	Futures	9162.53	9201.39	9142.96	9195.34	247176.0
2019-07-15	YM	Futures	28668.9	28767.6	28626.8	28709.8	129820.0
2019-07-15	CL	Futures	61.59	62.23	60.51	60.9	201708.0
2019-07-15	GC	Futures	1764.5	1769.4	1754.0	1759.3	243376.0
2019-07-15	ZN	Futures	126.413859	126.631599	126.25833	126.584941	931067.0
2019-07-15	A6	Futures	0.72363	0.72569	0.72281	0.72538	66516.0
2019-07-15	AD	Futures	0.77441	0.77507	0.7731	0.77361	54486.0
2019-07-15	ALI	Futures	2277.63	2278.24	2272.13	2272.13	13.0
2019-07-15	B	Futures	50.27	50.72	49.7	49.98	283089.0
2019-07-15	B6	Futures	1.2872	1.2876	1.2806	1.2817	47755.0
2019-07-15	BR	Futures	0.21334	0.21394	0.21178	0.21186	2124.0
2019-07-15	BTC	Futures	15321.8	15454.8	13879.9	15272.8	7597.0
2019-07-15	BZ	Futures	49.47	50.08	49.04	49.35	35583.0
2019-07-15	C	Futures	1756.0	1758.0	1707.0	1714.0	12079.0
2019-07-15	CB	Futures	286.231	289.411	286.231	287.923	63.0
2019-07-15	CC	Futures	1662.0	1663.0	1604.0	1612.0	24556.0
2019-07-15	CNH	Futures	6.8814	6.8872	6.8737	6.8759	673.0
2019-07-15	CSC	Futures	3.08	3.092	3.08	3.083	118.0
2019-07-15	CT	Futures	61.87	62.91	61.35	62.91	35.0
2019-07-15	DC	Futures	25.94	25.94	25.74	25.86	183.0
2019-07-15	DX	Futures	92.863	93.002	92.791	92.954	8592.0
2019-07-15	E1	Futures	1.18487	1.188	1.18359	1.18429	12979.0
2019-07-15	E6	Futures	1.2358	1.23711	1.23367	1.23443	104102.0
2019-07-15	E7	Futures	1.2292	1.2306	1.2273	1.228	2611.0
2019-07-15	EBM	Futures	206.41	206.41	202.96	203.53	13898.0
2019-07-15	ED	Futures	95.3525	95.3671	95.3476	95.3622	175668.0
2019-07-15	ER	Futures	98.509	98.529	98.509	98.524	84823.0
2019-07-15	EW	Futures	2061.3	2069.2	2047.9	2052.2	10721.0
2019-07-15	FBON	Futures	141.29	142.12	141.29	141.96	473.0
2019-07-15	FBTP	Futures	123.48	124.66	123.48	124.54	63055.0
2019-07-15	FBTS	Futures	107.254	107.619	107.254	107.59	33246.0
2019-07-15	FCE	Futures	5085.1	5104.3	5053.7	5079.2	99375.0
2019-07-15	FDAX	Futures	12969.6	13083.4	12932.3	13042.3	105859.0
2019-07-15	FDIV	Futures	146.28	146.65	146.28	146.65	160.0
2019-07-15	FDXM	Futures	12815.1	12923.2	12773.5	12881.6	37432.0
2019-07-15	FESX	Futures	3044.0	3065.8	3034.4	3056.2	716621.0
2019-07-15	FEU3	Futures	99.144	99.144	99.144	99.144	100.0
2019-07-15	FGBL	Futures	163.3	163.95	163.06	163.86	502403.0
2019-07-15	FGBM	Futures	134.19	134.34	134.12	134.3	322880.0
2019-07-15	FGBS	Futures	113.066	113.066	113.036	113.051	206717.0
2019-07-15	FGBX	Futures	204.44	206.89	203.76	206.68	36305.0
2019-07-15	FMWO	Futures	7461.8	7475.6	7451.4	7456.0	894.0
2019-07-15	FOAT	Futures	150.52	151.19	150.48	151.12	89515.0
2019-07-15	FTDX	Futures	2847.3	2875.9	2826.6	2859.7	53.0
2019-07-15	FTI	Futures	535.96	538.24	533.78	536.89	10145.0
2019-07-15	FTUK	Futures	6858.2	6909.9	6850.8	6904.8	77210.0
2019-07-15	FVSA	Futures	173.12	174.98	171.89	173.74	45814.0
2019-07-15	FXXP	Futures	346.0	347.2	344.4	346.6	37946.0
2019-07-15	G	Futures	119.87	120.38	119.87	120.32	147206.0

> showing 50 of 119 rows — these rows as CSV

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