PREVIEW / futures_daily / 2016-07-29

all futures daily files

  file:    by_date/futures_daily/2016/2016-07-29.parquet
  size:    9 KB
  rows:    108

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-29	ES	Futures	2338.07	2344.82	2329.43	2341.04	1718155.0
2016-07-29	NQ	Futures	5577.48	5583.08	5550.67	5571.59	207360.0
2016-07-29	YM	Futures	19196.2	19223.3	19110.5	19179.4	138941.0
2016-07-29	CL	Futures	46.61	47.23	45.99	47.15	478763.0
2016-07-29	GC	Futures	1722.7	1747.5	1712.8	1741.7	229248.0
2016-07-29	ZN	Futures	128.120383	128.588196	127.592207	128.497652	1584235.0
2016-07-29	A6	Futures	0.76246	0.77314	0.76114	0.77233	107881.0
2016-07-29	AD	Futures	0.77797	0.78738	0.77628	0.78477	80760.0
2016-07-29	ALI	Futures	2138.15	2138.15	2106.32	2138.15	3.0
2016-07-29	B	Futures	34.1	34.46	33.61	34.41	286584.0
2016-07-29	B6	Futures	1.3882	1.4034	1.3873	1.3965	111035.0
2016-07-29	BR	Futures	0.20017	0.2038	0.20013	0.2028	1036.0
2016-07-29	BZ	Futures	34.03	34.29	33.44	34.23	23817.0
2016-07-29	C	Futures	2483.0	2485.0	2439.0	2446.0	12358.0
2016-07-29	CB	Futures	257.885	257.885	254.369	257.885	61.0
2016-07-29	CC	Futures	2092.0	2104.0	2064.0	2079.0	21711.0
2016-07-29	CNH	Futures	7.1778	7.184	7.1778	7.184	1.0
2016-07-29	CSC	Futures	3.777	3.779	3.773	3.779	12.0
2016-07-29	CT	Futures	82.34	84.01	81.29	84.01	20.0
2016-07-29	DC	Futures	30.15	30.22	29.93	30.2	284.0
2016-07-29	DX	Futures	89.839	89.941	88.667	88.812	35780.0
2016-07-29	E1	Futures	1.28055	1.30284	1.27942	1.29633	34660.0
2016-07-29	E6	Futures	1.29196	1.3061	1.29143	1.30406	192318.0
2016-07-29	E7	Futures	1.2852	1.299	1.2849	1.2972	3336.0
2016-07-29	EBM	Futures	197.87	200.28	197.57	199.68	8747.0
2016-07-29	ED	Futures	95.6846	95.7136	95.6798	95.7039	419610.0
2016-07-29	ER	Futures	98.313	98.313	98.308	98.308	20151.0
2016-07-29	EW	Futures	1644.3	1655.1	1637.8	1650.3	16611.0
2016-07-29	FBON	Futures	123.45	123.97	123.45	123.97	50.0
2016-07-29	FBTP	Futures	109.75	110.19	109.65	110.14	74900.0
2016-07-29	FBTS	Futures	101.275	101.293	101.257	101.284	19962.0
2016-07-29	FCE	Futures	3879.0	3889.5	3846.7	3875.1	66891.0
2016-07-29	FDAX	Futures	11003.2	11018.1	10938.3	10988.3	72874.0
2016-07-29	FDXM	Futures	10720.0	10740.7	10664.0	10710.6	18367.0
2016-07-29	FESX	Futures	2335.3	2341.6	2321.2	2336.1	894983.0
2016-07-29	FGBL	Futures	150.31	151.17	150.2	151.0	603893.0
2016-07-29	FGBM	Futures	128.79	129.02	128.7	128.97	443972.0
2016-07-29	FGBS	Futures	111.827	111.892	111.827	111.887	270953.0
2016-07-29	FGBX	Futures	189.76	192.94	189.1	192.06	33403.0
2016-07-29	FMWO	Futures	5711.2	5740.4	5711.2	5740.4	1063.0
2016-07-29	FOAT	Futures	138.21	139.11	138.18	139.05	96429.0
2016-07-29	FTDX	Futures	1651.5	1659.7	1648.1	1654.9	130.0
2016-07-29	FTI	Futures	401.51	402.18	398.81	401.6	26165.0
2016-07-29	FTUK	Futures	5582.7	5582.7	5537.3	5569.8	109049.0
2016-07-29	FVSA	Futures	2240.11	2259.63	2171.79	2186.43	12852.0
2016-07-29	FXXP	Futures	275.4	276.2	273.9	275.7	17992.0
2016-07-29	G	Futures	115.34	115.95	115.2	115.88	216179.0
2016-07-29	GF	Futures	280.305	283.75	277.959	279.656	2589.0
2016-07-29	GSCI	Futures	479.58	487.54	479.29	486.68	221.0
2016-07-29	HE	Futures	82.694	83.83	82.097	82.426	6551.0

> showing 50 of 108 rows — these rows as CSV

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