PREVIEW / futures_daily / 2017-06-30

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-30.parquet
  size:    9 KB
  rows:    110

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
2017-06-30	ES	Futures	2630.93	2640.71	2624.68	2631.2	1638217.0
2017-06-30	NQ	Futures	6639.75	6684.71	6610.66	6645.04	336513.0
2017-06-30	YM	Futures	22478.3	22586.2	22444.5	22516.4	147374.0
2017-06-30	CL	Futures	46.36	47.86	46.35	47.54	677408.0
2017-06-30	GC	Futures	1589.6	1593.4	1581.7	1585.9	222756.0
2017-06-30	ZN	Futures	123.934571	123.99613	123.565214	123.642163	1887665.0
2017-06-30	A6	Futures	0.78852	0.7915	0.78688	0.78842	99100.0
2017-06-30	AD	Futures	0.78341	0.78656	0.78311	0.78555	79743.0
2017-06-30	ALI	Futures	2530.56	2530.56	2530.56	2530.56	0.0
2017-06-30	B	Futures	33.65	34.64	33.65	34.48	308192.0
2017-06-30	B6	Futures	1.3623	1.365	1.356	1.3633	109788.0
2017-06-30	BFX	Futures	4565.5	4577.6	4565.5	4577.6	7.0
2017-06-30	BR	Futures	0.222	0.222	0.22189	0.22189	20.0
2017-06-30	BZ	Futures	33.4	34.42	33.4	34.26	23479.0
2017-06-30	C	Futures	1499.0	1568.0	1491.0	1551.0	22747.0
2017-06-30	CB	Futures	325.394	326.002	325.394	325.972	6.0
2017-06-30	CC	Futures	1408.0	1484.0	1406.0	1473.0	34289.0
2017-06-30	CNH	Futures	7.0513	7.0513	7.0368	7.0426	2.0
2017-06-30	CSC	Futures	3.478	3.509	3.474	3.509	39.0
2017-06-30	CT	Futures	80.87	82.12	80.46	82.12	7.0
2017-06-30	DC	Futures	28.81	29.16	28.78	29.13	188.0
2017-06-30	DX	Futures	88.997	89.235	88.918	89.101	20291.0
2017-06-30	E1	Futures	1.29163	1.29188	1.28574	1.28684	25255.0
2017-06-30	E6	Futures	1.31621	1.31656	1.31049	1.31381	206175.0
2017-06-30	E7	Futures	1.3092	1.3096	1.3036	1.3069	4521.0
2017-06-30	EBM	Futures	195.13	198.2	194.58	196.53	21164.0
2017-06-30	ED	Futures	95.5789	95.5838	95.5644	95.5692	193594.0
2017-06-30	ER	Futures	98.332	98.337	98.328	98.328	88987.0
2017-06-30	EW	Futures	1854.6	1862.8	1850.1	1854.8	18061.0
2017-06-30	FBON	Futures	123.6	123.98	123.6	123.82	598.0
2017-06-30	FBTP	Futures	107.3	107.95	107.26	107.47	117071.0
2017-06-30	FBTS	Futures	102.726	102.745	102.681	102.699	50034.0
2017-06-30	FCE	Futures	4635.6	4678.5	4604.1	4612.6	111821.0
2017-06-30	FDAX	Futures	13045.6	13111.4	12954.0	12971.9	104187.0
2017-06-30	FDXM	Futures	12970.5	13030.2	12875.3	12892.1	31689.0
2017-06-30	FESX	Futures	2818.5	2842.2	2795.7	2800.6	1171671.0
2017-06-30	FEU3	Futures	99.006	99.006	99.006	99.006	426.0
2017-06-30	FGBL	Futures	147.21	147.71	146.85	147.05	955622.0
2017-06-30	FGBM	Futures	128.52	128.73	128.42	128.47	487868.0
2017-06-30	FGBS	Futures	112.051	112.086	112.016	112.046	390686.0
2017-06-30	FGBX	Futures	165.54	166.77	164.73	165.23	56653.0
2017-06-30	FMWO	Futures	6418.6	6428.1	6394.7	6394.7	1885.0
2017-06-30	FOAT	Futures	134.82	135.33	134.68	134.78	133357.0
2017-06-30	FTDX	Futures	2158.0	2210.6	2158.0	2185.0	491.0
2017-06-30	FTI	Futures	467.96	472.06	466.62	467.31	37663.0
2017-06-30	FTUK	Futures	6296.2	6323.9	6250.4	6259.0	119103.0
2017-06-30	FVSA	Futures	508.56	532.17	502.26	529.02	31753.0
2017-06-30	FXXP	Futures	322.9	324.7	321.0	321.5	50920.0
2017-06-30	G	Futures	113.87	114.39	113.63	114.01	264698.0
2017-06-30	GF	Futures	322.692	325.326	317.863	324.723	5454.0

> showing 50 of 110 rows — these rows as CSV

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