PREVIEW / futures_daily / 2016-07-14

all futures daily files

  file:    by_date/futures_daily/2016/2016-07-14.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
2016-07-14	ES	Futures	2316.21	2340.77	2313.51	2329.16	1782561.0
2016-07-14	NQ	Futures	5376.21	5431.91	5367.37	5410.4	191874.0
2016-07-14	YM	Futures	19102.1	19297.5	19079.2	19247.3	148861.0
2016-07-14	CL	Futures	51.98	52.72	51.73	52.62	312794.0
2016-07-14	GC	Futures	1729.7	1734.2	1698.7	1713.9	264334.0
2016-07-14	ZN	Futures	128.195837	128.361835	127.667661	127.863841	1366292.0
2016-07-14	A6	Futures	0.77243	0.7768	0.7706	0.77538	83723.0
2016-07-14	AD	Futures	0.78846	0.79567	0.78805	0.79419	60513.0
2016-07-14	ALI	Futures	2189.67	2189.67	2187.77	2189.67	8.0
2016-07-14	B	Futures	37.2	37.9	37.0	37.82	289398.0
2016-07-14	B6	Futures	1.3856	1.4222	1.3827	1.4061	197350.0
2016-07-14	BFX	Futures	3958.5	3958.5	3932.5	3932.5	10.0
2016-07-14	BR	Futures	0.20303	0.20303	0.2013	0.20163	5.0
2016-07-14	BZ	Futures	37.06	37.76	36.87	37.68	27528.0
2016-07-14	C	Futures	2651.0	2655.0	2624.0	2640.0	6484.0
2016-07-14	CB	Futures	278.838	281.329	278.838	281.329	24.0
2016-07-14	CC	Futures	2306.0	2319.0	2301.0	2315.0	15103.0
2016-07-14	CSC	Futures	3.61	3.699	3.61	3.678	68.0
2016-07-14	CT	Futures	82.85	84.53	82.0	83.62	53.0
2016-07-14	DC	Futures	28.85	29.71	28.85	29.61	237.0
2016-07-14	DX	Futures	89.578	89.676	89.137	89.379	13959.0
2016-07-14	E1	Futures	1.27529	1.28656	1.27529	1.28143	17835.0
2016-07-14	E6	Futures	1.29469	1.30296	1.29399	1.29789	139913.0
2016-07-14	E7	Futures	1.2879	1.296	1.2871	1.291	3497.0
2016-07-14	EBM	Futures	196.07	196.67	189.45	190.66	8916.0
2016-07-14	ED	Futures	95.7763	95.7859	95.757	95.7666	229779.0
2016-07-14	ER	Futures	98.332	98.332	98.308	98.313	46014.0
2016-07-14	EW	Futures	1629.5	1647.4	1628.8	1633.3	15870.0
2016-07-14	FBON	Futures	122.69	122.92	122.48	122.53	319.0
2016-07-14	FBTP	Futures	109.55	109.87	109.27	109.49	75822.0
2016-07-14	FBTS	Futures	101.284	101.302	101.257	101.257	20712.0
2016-07-14	FCE	Futures	3790.0	3841.9	3788.7	3827.5	63991.0
2016-07-14	FDAX	Futures	10577.5	10749.4	10576.5	10716.9	90062.0
2016-07-14	FDIV	Futures	130.44	130.53	130.44	130.53	55.0
2016-07-14	FDXM	Futures	10316.5	10478.3	10310.3	10446.1	24250.0
2016-07-14	FESX	Futures	2293.0	2328.3	2292.2	2320.4	1372500.0
2016-07-14	FEU3	Futures	98.966	98.971	98.966	98.971	4.0
2016-07-14	FGBL	Futures	150.33	150.42	149.6	149.97	643851.0
2016-07-14	FGBM	Futures	129.05	129.09	128.84	128.96	432870.0
2016-07-14	FGBS	Futures	111.967	111.977	111.917	111.937	204877.0
2016-07-14	FGBX	Futures	188.57	188.63	185.55	186.72	38208.0
2016-07-14	FMWO	Futures	5701.5	5701.5	5696.6	5696.6	37.0
2016-07-14	FOAT	Futures	138.23	138.45	137.67	137.99	77336.0
2016-07-14	FTDX	Futures	1570.1	1577.3	1559.5	1575.4	504.0
2016-07-14	FTI	Futures	397.37	402.68	397.37	400.07	16039.0
2016-07-14	FTUK	Futures	5534.8	5583.2	5501.4	5513.5	150746.0
2016-07-14	FVSA	Futures	2269.4	2362.12	2254.75	2279.16	15790.0
2016-07-14	FXXP	Futures	271.1	273.7	271.1	273.1	26771.0
2016-07-14	G	Futures	114.99	115.17	114.48	114.8	196664.0
2016-07-14	GF	Futures	277.759	284.648	277.759	282.951	5774.0

> showing 50 of 110 rows — these rows as CSV

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