PREVIEW / futures_daily / 2016-07-26

all futures daily files

  file:    by_date/futures_daily/2016/2016-07-26.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
2016-07-26	ES	Futures	2335.1	2340.77	2325.38	2335.64	1609035.0
2016-07-26	NQ	Futures	5491.14	5526.21	5470.51	5497.33	209762.0
2016-07-26	YM	Futures	19248.4	19268.2	19126.2	19217.0	137652.0
2016-07-26	CL	Futures	48.82	49.18	48.01	48.65	461324.0
2016-07-26	GC	Futures	1697.6	1709.0	1695.2	1704.2	89884.0
2016-07-26	ZN	Futures	127.516754	127.818569	127.350756	127.607298	1023027.0
2016-07-26	A6	Futures	0.75869	0.76582	0.75788	0.76225	73355.0
2016-07-26	AD	Futures	0.77428	0.77699	0.7728	0.77577	59874.0
2016-07-26	ALI	Futures	2082.77	2083.41	2081.5	2083.41	8.0
2016-07-26	B	Futures	35.7	35.84	35.2	35.75	213119.0
2016-07-26	B6	Futures	1.3859	1.3905	1.3775	1.3856	93897.0
2016-07-26	BR	Futures	0.2008	0.2013	0.20037	0.2009	1898.0
2016-07-26	BZ	Futures	35.57	35.65	35.03	35.57	20799.0
2016-07-26	C	Futures	2502.0	2517.0	2486.0	2494.0	13339.0
2016-07-26	CB	Futures	275.908	275.908	272.479	273.124	58.0
2016-07-26	CC	Futures	2098.0	2117.0	2083.0	2090.0	16965.0
2016-07-26	CNH	Futures	7.2463	7.2463	7.2398	7.2398	2.0
2016-07-26	CSC	Futures	3.796	3.809	3.743	3.76	114.0
2016-07-26	CT	Futures	82.1	84.3	82.1	83.41	24.0
2016-07-26	DC	Futures	30.38	30.61	29.86	30.11	223.0
2016-07-26	DX	Futures	90.504	90.536	90.118	90.372	10590.0
2016-07-26	E1	Futures	1.27341	1.2768	1.26402	1.26528	17962.0
2016-07-26	E6	Futures	1.28247	1.28695	1.28095	1.28189	104632.0
2016-07-26	E7	Futures	1.2756	1.2799	1.2741	1.275	1731.0
2016-07-26	EBM	Futures	204.49	205.09	199.08	199.98	22600.0
2016-07-26	ED	Futures	95.6605	95.675	95.6557	95.6653	238226.0
2016-07-26	ER	Futures	98.313	98.313	98.308	98.313	21891.0
2016-07-26	EW	Futures	1635.1	1646.8	1633.7	1645.6	13414.0
2016-07-26	FBON	Futures	123.07	123.23	123.07	123.07	19.0
2016-07-26	FBTP	Futures	109.59	109.62	109.27	109.3	61383.0
2016-07-26	FBTS	Futures	101.275	101.284	101.248	101.257	11149.0
2016-07-26	FCE	Futures	3835.0	3845.9	3798.7	3835.8	69169.0
2016-07-26	FDAX	Futures	10865.4	10929.8	10788.8	10903.7	74297.0
2016-07-26	FDXM	Futures	10585.1	10652.6	10515.6	10628.2	19280.0
2016-07-26	FESX	Futures	2326.7	2336.1	2306.3	2331.4	908351.0
2016-07-26	FEU3	Futures	98.961	98.966	98.961	98.966	7.0
2016-07-26	FGBL	Futures	150.1	150.3	149.75	149.81	495606.0
2016-07-26	FGBM	Futures	128.78	128.83	128.68	128.7	406142.0
2016-07-26	FGBS	Futures	111.852	111.867	111.842	111.852	188188.0
2016-07-26	FGBX	Futures	187.95	189.23	187.11	187.32	25508.0
2016-07-26	FMWO	Futures	5691.7	5691.7	5688.1	5688.1	23.0
2016-07-26	FOAT	Futures	138.09	138.23	137.75	137.82	61628.0
2016-07-26	FTDX	Futures	1626.0	1634.6	1616.8	1631.3	122.0
2016-07-26	FTI	Futures	404.3	406.09	401.87	405.29	22584.0
2016-07-26	FTUK	Futures	5557.7	5582.7	5545.2	5571.5	77594.0
2016-07-26	FVSA	Futures	2220.59	2284.04	2210.83	2259.63	13811.0
2016-07-26	FXXP	Futures	275.0	275.9	273.2	275.5	16838.0
2016-07-26	G	Futures	114.91	115.18	114.42	114.51	275753.0
2016-07-26	GF	Futures	284.449	286.695	281.753	284.449	4098.0
2016-07-26	GSCI	Futures	494.5	494.5	493.93	494.5	316.0

> showing 50 of 109 rows — these rows as CSV

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