PREVIEW / futures_daily / 2018-11-07

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-07.parquet
  size:    10 KB
  rows:    115

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-11-07	ES	Futures	2989.73	3055.88	2976.71	3054.53	1894012.0
2018-11-07	NQ	Futures	8144.04	8392.02	8097.58	8384.47	621601.0
2018-11-07	YM	Futures	26980.0	27587.6	26888.4	27570.8	245257.0
2018-11-07	CL	Futures	64.34	65.84	63.78	64.27	866628.0
2018-11-07	GC	Futures	1557.5	1569.6	1551.6	1557.3	259294.0
2018-11-07	ZN	Futures	117.44074	117.798696	117.25398	117.518556	2301837.0
2018-11-07	A6	Futures	0.74475	0.75155	0.74249	0.75	119946.0
2018-11-07	AD	Futures	0.77082	0.77502	0.76895	0.77244	70048.0
2018-11-07	B	Futures	52.97	54.36	52.74	53.27	361361.0
2018-11-07	B6	Futures	1.3488	1.3574	1.347	1.3545	119933.0
2018-11-07	BFX	Futures	4127.0	4144.4	4127.0	4144.4	2.0
2018-11-07	BR	Futures	0.20205	0.20426	0.20083	0.20315	4126.0
2018-11-07	BTC	Futures	9307.8	9474.2	9307.8	9423.6	4263.0
2018-11-07	BZ	Futures	52.67	53.98	52.38	52.91	36648.0
2018-11-07	C	Futures	1571.0	1576.0	1551.0	1572.0	5494.0
2018-11-07	CB	Futures	266.761	267.061	266.761	267.061	34.0
2018-11-07	CC	Futures	1652.0	1660.0	1629.0	1653.0	36781.0
2018-11-07	CNH	Futures	6.9612	6.9824	6.9522	6.955	509.0
2018-11-07	CSC	Futures	2.992	2.992	2.952	2.952	98.0
2018-11-07	CT	Futures	86.83	89.54	86.65	88.63	30683.0
2018-11-07	DC	Futures	24.79	24.81	24.43	24.46	467.0
2018-11-07	DX	Futures	90.975	91.469	90.709	91.015	34006.0
2018-11-07	E1	Futures	1.18561	1.19497	1.18335	1.18881	27278.0
2018-11-07	E6	Futures	1.27355	1.28367	1.27083	1.27755	268365.0
2018-11-07	E7	Futures	1.2674	1.277	1.2646	1.2713	5151.0
2018-11-07	EBM	Futures	209.24	209.76	208.46	209.24	20376.0
2018-11-07	ED	Futures	94.9694	94.9792	94.9597	94.9646	275070.0
2018-11-07	ER	Futures	98.386	98.391	98.381	98.386	20335.0
2018-11-07	EW	Futures	1980.0	2012.6	1972.8	2010.2	16187.0
2018-11-07	FBON	Futures	127.43	127.74	127.23	127.28	832.0
2018-11-07	FBTP	Futures	104.99	105.75	104.93	105.52	63120.0
2018-11-07	FBTS	Futures	102.771	102.949	102.705	102.883	57022.0
2018-11-07	FCE	Futures	4569.4	4622.2	4558.6	4599.4	62058.0
2018-11-07	FDAX	Futures	12131.5	12253.5	12094.7	12160.4	89085.0
2018-11-07	FDXM	Futures	11922.5	12045.4	11886.3	11949.8	45487.0
2018-11-07	FESX	Futures	2705.8	2736.1	2697.4	2717.6	986820.0
2018-11-07	FGBL	Futures	152.95	153.02	152.43	152.64	616320.0
2018-11-07	FGBM	Futures	131.04	131.05	130.79	130.88	358617.0
2018-11-07	FGBS	Futures	112.678	112.688	112.628	112.643	325700.0
2018-11-07	FGBX	Futures	177.35	177.43	176.02	176.48	45393.0
2018-11-07	FMWO	Futures	6853.5	6945.1	6853.5	6905.7	3333.0
2018-11-07	FOAT	Futures	140.14	140.24	139.8	139.93	135207.0
2018-11-07	FTDX	Futures	2612.8	2649.1	2610.8	2631.4	266.0
2018-11-07	FTI	Futures	488.69	494.71	487.71	491.98	24997.0
2018-11-07	FTUK	Futures	6278.7	6372.5	6276.9	6326.5	104730.0
2018-11-07	FVSA	Futures	335.82	338.67	315.84	324.4	37379.0
2018-11-07	FXXP	Futures	315.1	318.8	314.3	316.6	62969.0
2018-11-07	G	Futures	114.31	114.4	114.0	114.25	224084.0
2018-11-07	GF	Futures	312.1	312.88	310.853	311.736	1365.0
2018-11-07	GSCI	Futures	512.23	512.23	508.23	511.03	3547.0

> showing 50 of 115 rows — these rows as CSV

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