PREVIEW / futures_daily / 2017-06-07

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-07.parquet
  size:    9 KB
  rows:    109

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-07	ES	Futures	2638.54	2644.52	2632.57	2641.26	1431930.0
2017-06-07	NQ	Futures	6904.5	6931.0	6885.06	6925.11	274935.0
2017-06-07	YM	Futures	22311.5	22356.9	22272.5	22330.5	121187.0
2017-06-07	CL	Futures	49.7	49.96	47.28	47.36	1182327.0
2017-06-07	GC	Futures	1655.7	1656.5	1640.4	1650.9	218849.0
2017-06-07	ZN	Futures	124.888344	124.903707	124.627168	124.657894	21734.0
2017-06-07	A6	Futures	0.77075	0.7766	0.76972	0.77445	119808.0
2017-06-07	AD	Futures	0.75814	0.75972	0.75411	0.75442	64308.0
2017-06-07	ALI	Futures	2504.93	2504.93	2504.93	2504.93	0.0
2017-06-07	B	Futures	35.55	35.67	34.12	34.19	461745.0
2017-06-07	B6	Futures	1.3534	1.3612	1.3515	1.3582	142364.0
2017-06-07	BR	Futures	0.2236	0.2236	0.222	0.22245	71.0
2017-06-07	BZ	Futures	35.41	35.51	33.98	34.04	50234.0
2017-06-07	C	Futures	1548.0	1569.0	1540.0	1548.0	10479.0
2017-06-07	CB	Futures	304.106	307.147	304.106	307.147	44.0
2017-06-07	CC	Futures	1510.0	1523.0	1496.0	1506.0	27879.0
2017-06-07	CNH	Futures	7.0571	7.0651	7.0571	7.0605	30.0
2017-06-07	CSC	Futures	3.606	3.627	3.592	3.602	69.0
2017-06-07	CT	Futures	84.24	84.41	83.78	83.94	13338.0
2017-06-07	DC	Futures	30.31	30.36	30.05	30.09	99.0
2017-06-07	DX	Futures	89.966	90.316	89.864	90.099	24747.0
2017-06-07	E1	Futures	1.28543	1.28568	1.27777	1.28123	26603.0
2017-06-07	E6	Futures	1.29982	1.3004	1.29124	1.29706	262232.0
2017-06-07	E7	Futures	1.2936	1.2936	1.2848	1.2905	8829.0
2017-06-07	EBM	Futures	186.23	188.45	185.95	187.62	12784.0
2017-06-07	ED	Futures	95.5905	95.5954	95.5857	95.5905	197618.0
2017-06-07	ER	Futures	98.337	98.337	98.332	98.337	22001.0
2017-06-07	EW	Futures	1845.3	1852.1	1840.8	1844.7	15747.0
2017-06-07	FBON	Futures	123.54	123.9	123.42	123.56	2157.0
2017-06-07	FBTP	Futures	106.44	106.52	105.78	106.03	204610.0
2017-06-07	FBTS	Futures	102.444	102.48	102.435	102.444	69544.0
2017-06-07	FCE	Futures	4725.9	4773.9	4711.1	4723.6	106137.0
2017-06-07	FDAX	Futures	13384.8	13455.5	13337.3	13365.8	80298.0
2017-06-07	FDXM	Futures	13268.8	13337.8	13222.7	13248.4	25148.0
2017-06-07	FESX	Futures	2894.5	2917.3	2883.8	2892.0	1063986.0
2017-06-07	FGBL	Futures	149.72	149.99	149.67	149.89	872008.0
2017-06-07	FGBM	Futures	129.9	129.96	129.82	129.92	679673.0
2017-06-07	FGBS	Futures	112.372	112.402	112.357	112.387	335018.0
2017-06-07	FGBX	Futures	168.75	170.08	168.71	169.58	72697.0
2017-06-07	FMWO	Futures	6494.0	6498.8	6477.1	6477.1	1308.0
2017-06-07	FOAT	Futures	136.31	136.46	136.1	136.24	207075.0
2017-06-07	FTDX	Futures	2258.7	2268.5	2256.8	2258.7	869.0
2017-06-07	FTI	Futures	478.59	483.64	477.31	479.69	31655.0
2017-06-07	FTUK	Futures	6429.0	6456.3	6385.3	6389.6	135843.0
2017-06-07	FVSA	Futures	492.66	497.74	480.81	494.35	18156.0
2017-06-07	FXXP	Futures	328.1	330.5	327.1	328.0	35065.0
2017-06-07	G	Futures	116.45	116.73	116.38	116.65	180119.0
2017-06-07	GF	Futures	339.65	342.998	333.01	339.815	7565.0
2017-06-07	GSCI	Futures	453.16	453.22	452.29	452.29	1868.0
2017-06-07	HE	Futures	86.462	86.754	85.719	86.064	20591.0

> showing 50 of 109 rows — these rows as CSV

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