PREVIEW / futures_daily / 2018-08-02

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-02.parquet
  size:    9 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-08-02	ES	Futures	3056.28	3075.01	3031.3	3072.03	1238138.0
2018-08-02	NQ	Futures	8492.72	8622.14	8411.11	8611.06	441069.0
2018-08-02	YM	Futures	26672.1	26692.1	26434.0	26663.7	155369.0
2018-08-02	CL	Futures	70.21	71.76	69.24	71.35	531071.0
2018-08-02	GC	Futures	1552.2	1558.9	1540.3	1546.4	234632.0
2018-08-02	ZN	Futures	118.515582	118.717589	118.453426	118.670972	1306817.0
2018-08-02	A6	Futures	0.76182	0.76244	0.75658	0.7574	80917.0
2018-08-02	AD	Futures	0.77943	0.78004	0.77736	0.77827	54916.0
2018-08-02	B	Futures	52.79	53.76	52.37	53.54	226453.0
2018-08-02	B6	Futures	1.3563	1.3595	1.345	1.346	153044.0
2018-08-02	BR	Futures	0.20193	0.20243	0.20079	0.20186	1650.0
2018-08-02	BTC	Futures	10627.5	10969.4	10584.8	10720.1	5552.0
2018-08-02	BZ	Futures	52.85	53.68	52.3	53.47	21038.0
2018-08-02	C	Futures	1464.0	1483.0	1451.0	1464.0	13882.0
2018-08-02	CB	Futures	276.96	278.639	276.96	278.639	30.0
2018-08-02	CC	Futures	1472.0	1510.0	1472.0	1485.0	26369.0
2018-08-02	CNH	Futures	6.9017	6.9519	6.8922	6.9519	443.0
2018-08-02	CSC	Futures	3.226	3.244	3.22	3.22	46.0
2018-08-02	CT	Futures	99.73	100.36	99.48	100.36	17.0
2018-08-02	DC	Futures	26.01	26.33	25.95	26.01	322.0
2018-08-02	DX	Futures	89.454	89.994	89.425	89.962	20487.0
2018-08-02	E1	Futures	1.20911	1.20946	1.20445	1.2048	20863.0
2018-08-02	E6	Futures	1.3081	1.30894	1.29932	1.29988	231821.0
2018-08-02	E7	Futures	1.3015	1.3023	1.2926	1.2933	2985.0
2018-08-02	EBM	Futures	218.13	229.64	218.13	222.57	26299.0
2018-08-02	ED	Futures	95.0059	95.0205	95.001	95.0156	214915.0
2018-08-02	ER	Futures	98.362	98.367	98.362	98.367	72276.0
2018-08-02	EW	Futures	2097.6	2116.9	2080.0	2113.7	13056.0
2018-08-02	FBON	Futures	128.59	128.65	128.4	128.42	359.0
2018-08-02	FBTP	Futures	107.3	107.36	105.68	106.22	113729.0
2018-08-02	FBTS	Futures	102.689	102.791	102.058	102.271	78413.0
2018-08-02	FCE	Futures	4915.5	4924.0	4883.6	4897.5	68539.0
2018-08-02	FDAX	Futures	13254.8	13267.4	13050.5	13100.6	111900.0
2018-08-02	FDXM	Futures	13084.5	13098.9	12883.2	12933.3	44804.0
2018-08-02	FESX	Futures	2914.9	2918.2	2886.5	2894.0	1109593.0
2018-08-02	FGBL	Futures	151.86	152.22	151.75	151.95	680634.0
2018-08-02	FGBM	Futures	130.51	130.72	130.5	130.61	397863.0
2018-08-02	FGBS	Futures	112.537	112.598	112.537	112.573	357482.0
2018-08-02	FGBX	Futures	174.57	175.31	174.23	174.85	38927.0
2018-08-02	FMWO	Futures	7123.0	7137.0	7085.7	7125.3	1243.0
2018-08-02	FOAT	Futures	139.82	139.95	139.69	139.74	167933.0
2018-08-02	FTDX	Futures	2807.8	2835.3	2801.4	2823.5	496.0
2018-08-02	FTI	Futures	525.73	527.21	522.59	524.62	26593.0
2018-08-02	FTUK	Futures	6751.0	6765.7	6659.7	6697.6	129885.0
2018-08-02	FVSA	Futures	269.42	287.58	269.42	283.75	28476.0
2018-08-02	FXXP	Futures	335.0	335.7	332.9	333.7	47983.0
2018-08-02	G	Futures	114.62	114.97	114.45	114.64	264630.0
2018-08-02	GF	Futures	314.516	315.086	310.58	313.221	2621.0
2018-08-02	GSCI	Futures	514.46	521.73	514.46	520.77	474.0
2018-08-02	HE	Futures	68.113	68.316	67.165	67.232	20706.0

> showing 50 of 112 rows — these rows as CSV

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