PREVIEW / futures_daily / 2018-12-20

all futures daily files

  file:    by_date/futures_daily/2018/2018-12-20.parquet
  size:    10 KB
  rows:    116

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-12-20	ES	Futures	2712.09	2726.16	2643.34	2691.79	3686614.0
2018-12-20	NQ	Futures	7351.73	7414.83	7154.92	7323.08	1011493.0
2018-12-20	YM	Futures	24589.9	24719.6	23878.9	24256.6	465503.0
2018-12-20	CL	Futures	49.71	49.83	47.9	48.12	794130.0
2018-12-20	GC	Futures	1571.2	1600.6	1570.2	1597.6	318239.0
2018-12-20	ZN	Futures	120.771226	120.833471	120.397754	120.568929	2172584.0
2018-12-20	A6	Futures	0.73425	0.73744	0.73106	0.73446	114771.0
2018-12-20	AD	Futures	0.75251	0.75468	0.74993	0.7519	95896.0
2018-12-20	B	Futures	41.48	41.67	39.85	39.91	299454.0
2018-12-20	B6	Futures	1.3018	1.3108	1.301	1.307	94477.0
2018-12-20	BFX	Futures	3786.7	3797.9	3786.7	3797.9	10.0
2018-12-20	BR	Futures	0.20627	0.20627	0.20627	0.20627	1.0
2018-12-20	BTC	Futures	5607.5	6332.3	5546.5	5912.7	4834.0
2018-12-20	BZ	Futures	40.99	41.13	39.34	39.39	40553.0
2018-12-20	C	Futures	1496.0	1498.0	1450.0	1475.0	12963.0
2018-12-20	CB	Futures	268.856	271.529	268.735	269.403	33.0
2018-12-20	CC	Futures	1596.0	1596.0	1551.0	1565.0	16125.0
2018-12-20	CNH	Futures	6.9184	6.9297	6.8971	6.9054	703.0
2018-12-20	CSC	Futures	2.786	2.803	2.78	2.79	101.0
2018-12-20	CT	Futures	83.52	84.36	81.72	81.76	24813.0
2018-12-20	DC	Futures	23.72	23.86	23.67	23.84	225.0
2018-12-20	DX	Futures	91.989	92.046	91.202	91.296	31349.0
2018-12-20	E1	Futures	1.193	1.20535	1.19183	1.20158	33689.0
2018-12-20	E6	Futures	1.26735	1.27895	1.26691	1.27707	258931.0
2018-12-20	E7	Futures	1.2612	1.2728	1.2608	1.2708	4801.0
2018-12-20	EBM	Futures	212.05	212.57	210.77	211.8	21598.0
2018-12-20	ED	Futures	94.9646	94.9793	94.9256	94.9402	417525.0
2018-12-20	ER	Futures	98.396	98.401	98.391	98.396	70372.0
2018-12-20	EW	Futures	1771.0	1784.5	1731.9	1752.1	26690.0
2018-12-20	FBON	Futures	130.19	130.2	129.97	130.05	431.0
2018-12-20	FBTP	Futures	111.12	111.92	110.92	111.73	58364.0
2018-12-20	FBTS	Futures	104.641	104.925	104.537	104.849	38961.0
2018-12-20	FCE	Futures	4185.8	4192.5	4125.9	4164.0	81748.0
2018-12-20	FDAX	Futures	11197.4	11232.6	11006.6	11138.5	82549.0
2018-12-20	FDIV	Futures	130.33	130.51	130.33	130.51	7.0
2018-12-20	FDXM	Futures	11184.2	11197.9	10975.6	11111.4	4449.0
2018-12-20	FESX	Futures	2572.3	2575.7	2527.8	2552.6	1512097.0
2018-12-20	FGBL	Futures	155.68	155.94	155.37	155.51	696846.0
2018-12-20	FGBM	Futures	131.78	131.9	131.68	131.74	352760.0
2018-12-20	FGBS	Futures	112.678	112.703	112.648	112.668	176787.0
2018-12-20	FGBX	Futures	184.73	185.34	184.12	184.55	46408.0
2018-12-20	FMWO	Futures	6273.2	6360.6	6224.2	6291.8	10697.0
2018-12-20	FOAT	Futures	141.47	141.68	141.36	141.57	101656.0
2018-12-20	FTDX	Futures	2438.0	2455.9	2390.3	2415.1	894.0
2018-12-20	FTI	Futures	455.31	458.03	449.04	454.6	21332.0
2018-12-20	FTUK	Futures	6045.8	6102.3	5979.8	6057.2	136185.0
2018-12-20	FVSA	Futures	418.43	460.07	418.43	435.7	32024.0
2018-12-20	FXXP	Futures	294.5	295.9	290.7	294.0	75503.0
2018-12-20	G	Futures	117.18	117.42	116.74	116.9	170677.0
2018-12-20	GF	Futures	314.71	317.885	313.58	317.347	3094.0

> showing 50 of 116 rows — these rows as CSV

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