PREVIEW / futures_daily / 2018-04-04

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-04.parquet
  size:    10 KB
  rows:    112

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-04-04	ES	Futures	2840.47	2881.52	2783.37	2878.53	2247386.0
2018-04-04	NQ	Futures	7568.02	7715.2	7381.63	7704.38	635562.0
2018-04-04	YM	Futures	25261.6	25578.7	24608.5	25560.8	382535.0
2018-04-04	CL	Futures	63.86	63.91	62.32	63.64	760596.0
2018-04-04	GC	Futures	1706.5	1726.7	1704.6	1711.0	351033.0
2018-04-04	ZN	Futures	120.005408	120.253546	119.77278	119.927865	1510326.0
2018-04-04	A6	Futures	0.79031	0.79411	0.78794	0.79247	96067.0
2018-04-04	AD	Futures	0.79107	0.79416	0.78859	0.79208	81415.0
2018-04-04	B	Futures	49.54	49.63	48.48	49.44	361479.0
2018-04-04	B6	Futures	1.4606	1.4643	1.4561	1.4622	99049.0
2018-04-04	BR	Futures	0.2265	0.22746	0.22532	0.22704	1181.0
2018-04-04	BTC	Futures	10551.8	10566.0	9550.6	9742.3	2951.0
2018-04-04	BZ	Futures	48.89	48.98	47.86	48.8	39674.0
2018-04-04	C	Futures	1609.0	1633.0	1584.0	1611.0	13787.0
2018-04-04	CB	Futures	288.474	293.447	288.474	291.563	43.0
2018-04-04	CC	Futures	1833.0	1871.0	1814.0	1841.0	25610.0
2018-04-04	CNH	Futures	6.384	6.4163	6.384	6.3898	16.0
2018-04-04	CSC	Futures	3.36	3.36	3.346	3.356	26.0
2018-04-04	CT	Futures	94.37	94.61	90.37	91.54	43856.0
2018-04-04	DC	Futures	26.49	26.85	26.49	26.85	124.0
2018-04-04	DX	Futures	84.693	84.783	84.476	84.677	15113.0
2018-04-04	E1	Futures	1.2638	1.26873	1.2609	1.26163	20135.0
2018-04-04	E6	Futures	1.39015	1.39493	1.38829	1.3911	169413.0
2018-04-04	E7	Futures	1.3824	1.3875	1.3809	1.3837	2361.0
2018-04-04	EBM	Futures	176.66	179.08	175.59	178.54	29074.0
2018-04-04	ED	Futures	94.9938	95.0035	94.9889	94.9938	298512.0
2018-04-04	ER	Futures	98.337	98.342	98.332	98.337	35392.0
2018-04-04	EW	Futures	1972.0	1992.9	1934.2	1989.7	20621.0
2018-04-04	FBON	Futures	130.39	130.78	130.39	130.74	327.0
2018-04-04	FBTP	Futures	115.48	116.09	115.39	115.99	89561.0
2018-04-04	FBTS	Futures	104.232	104.352	104.223	104.333	63233.0
2018-04-04	FCE	Futures	4545.5	4568.0	4482.5	4524.8	92868.0
2018-04-04	FDAX	Futures	12508.5	12554.3	12254.0	12430.6	118787.0
2018-04-04	FDXM	Futures	12387.9	12443.5	12145.9	12319.9	54330.0
2018-04-04	FESX	Futures	2721.5	2737.3	2676.5	2709.8	1226429.0
2018-04-04	FEU3	Futures	99.026	99.026	99.021	99.021	603.0
2018-04-04	FGBL	Futures	149.89	150.25	149.83	150.07	705993.0
2018-04-04	FGBM	Futures	129.71	129.84	129.69	129.77	399002.0
2018-04-04	FGBS	Futures	112.553	112.563	112.542	112.547	208156.0
2018-04-04	FGBX	Futures	170.95	171.88	170.82	171.36	49030.0
2018-04-04	FMWO	Futures	6763.5	6856.9	6677.0	6770.5	1912.0
2018-04-04	FOAT	Futures	139.12	139.46	139.06	139.34	98586.0
2018-04-04	FTDX	Futures	2426.7	2430.2	2370.3	2388.6	368.0
2018-04-04	FTI	Futures	485.06	486.11	477.53	481.8	35833.0
2018-04-04	FTUK	Futures	6145.2	6207.9	6086.8	6143.4	116700.0
2018-04-04	FVSA	Futures	443.52	479.19	430.44	456.6	30581.0
2018-04-04	FXXP	Futures	313.2	314.7	308.9	311.6	46579.0
2018-04-04	G	Futures	114.22	114.51	114.1	114.2	196945.0
2018-04-04	GF	Futures	283.305	294.086	280.038	292.943	3221.0
2018-04-04	GSCI	Futures	502.96	511.3	502.96	509.07	227.0

> showing 50 of 112 rows — these rows as CSV

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