PREVIEW / futures_daily / 2018-04-02

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-02.parquet
  size:    8 KB
  rows:    84

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-02	ES	Futures	2865.48	2872.55	2775.22	2800.23	2395329.0
2018-04-02	NQ	Futures	7674.53	7711.4	7404.75	7482.87	670690.0
2018-04-02	YM	Futures	25383.8	25436.5	24550.6	24809.7	358651.0
2018-04-02	CL	Futures	65.19	65.7	63.07	63.28	582742.0
2018-04-02	GC	Futures	1698.9	1722.5	1696.7	1719.6	254663.0
2018-04-02	ZN	Futures	120.129477	120.470666	120.020917	120.362106	1054232.0
2018-04-02	A6	Futures	0.79082	0.79134	0.78661	0.78692	44701.0
2018-04-02	AD	Futures	0.78601	0.78763	0.78257	0.78313	44380.0
2018-04-02	B	Futures	50.39	50.91	49.06	49.17	190053.0
2018-04-02	B6	Futures	1.4565	1.4625	1.4563	1.4587	46244.0
2018-04-02	BR	Futures	0.22955	0.22955	0.22841	0.22841	9.0
2018-04-02	BTC	Futures	9806.2	10154.1	9621.6	9926.9	3539.0
2018-04-02	BZ	Futures	49.81	50.24	48.41	48.53	25064.0
2018-04-02	CB	Futures	281.37	281.494	281.37	281.494	1.0
2018-04-02	CC	Futures	1902.0	1942.0	1868.0	1933.0	19762.0
2018-04-02	CNH	Futures	6.3794	6.3887	6.3794	6.3805	2.0
2018-04-02	CSC	Futures	3.3	3.31	3.3	3.31	4.0
2018-04-02	CT	Futures	94.03	95.07	93.01	93.07	15144.0
2018-04-02	DC	Futures	26.24	26.4	26.12	26.35	110.0
2018-04-02	DX	Futures	84.58	84.703	84.325	84.605	13275.0
2018-04-02	E1	Futures	1.26958	1.27223	1.26717	1.26934	13946.0
2018-04-02	E6	Futures	1.39555	1.39848	1.3911	1.3933	100862.0
2018-04-02	E7	Futures	1.3874	1.3909	1.3836	1.3858	1575.0
2018-04-02	ED	Futures	95.0035	95.023	94.9986	95.0181	148892.0
2018-04-02	ER	Futures	98.337	98.337	98.337	98.337	0.0
2018-04-02	EW	Futures	1991.0	1991.8	1929.1	1944.0	28113.0
2018-04-02	GF	Futures	288.968	291.745	285.211	287.225	2137.0
2018-04-02	GSCI	Futures	516.05	516.05	508.62	508.62	976.0
2018-04-02	HE	Futures	78.467	78.467	75.301	75.301	427.0
2018-04-02	HG	Futures	3.6263	3.6554	3.6132	3.6287	70252.0
2018-04-02	HH	Futures	17.952	17.952	17.351	17.54	1654.0
2018-04-02	HO	Futures	1.3382	1.3469	1.3054	1.3066	32545.0
2018-04-02	HRC	Futures	1861.2	1861.2	1861.2	1861.2	25.0
2018-04-02	J1	Futures	0.0114625	0.0115316	0.0114449	0.0115104	96032.0
2018-04-02	J7	Futures	0.01143	0.011499	0.011414	0.01148	422.0
2018-04-02	JB	Futures	138.42	138.47	138.37	138.47	539.0
2018-04-02	KC	Futures	145.29	145.78	142.17	142.48	18338.0
2018-04-02	KE	Futures	878.44	883.55	865.92	867.31	24816.0
2018-04-02	LBS	Futures	764.5	766.6	755.6	756.7	580.0
2018-04-02	LE	Futures	154.317	156.541	151.942	152.206	34391.0
2018-04-02	MFS	Futures	2056.3	2061.5	2018.3	2029.8	32020.0
2018-04-02	MGC	Futures	1660.0	1683.0	1657.9	1680.1	3785.0
2018-04-02	MME	Futures	1197.0	1197.0	1163.0	1173.2	64349.0
2018-04-02	MP	Futures	0.03798	0.03802	0.03765	0.03773	45821.0
2018-04-02	N6	Futures	0.71822	0.71842	0.71534	0.71574	8428.0
2018-04-02	NG	Futures	23.391	23.639	22.705	22.988	165214.0
2018-04-02	NIY	Futures	18893.0	19029.5	18434.7	18544.9	35604.0
2018-04-02	NKD	Futures	20001.5	20145.9	19517.2	19629.0	14674.0
2018-04-02	NOK	Futures	0.133104	0.133574	0.132509	0.132603	98.0
2018-04-02	OJ	Futures	134.79	135.56	131.21	132.89	1167.0

> showing 50 of 84 rows — these rows as CSV

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