PREVIEW / futures_daily / 2016-07-19

all futures daily files

  file:    by_date/futures_daily/2016/2016-07-19.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-19	ES	Futures	2332.13	2332.94	2322.68	2330.78	1151631.0
2016-07-19	NQ	Futures	5433.38	5435.44	5408.33	5429.84	165175.0
2016-07-19	YM	Futures	19282.8	19317.3	19220.2	19302.7	105405.0
2016-07-19	CL	Futures	52.06	52.57	51.32	51.52	481709.0
2016-07-19	GC	Futures	1709.9	1718.1	1705.7	1714.0	150620.0
2016-07-19	ZN	Futures	127.531844	127.878932	127.486572	127.712933	887408.0
2016-07-19	A6	Futures	0.76978	0.77029	0.7589	0.76236	93970.0
2016-07-19	AD	Futures	0.79045	0.79117	0.784	0.7859	50049.0
2016-07-19	ALI	Futures	2149.61	2150.88	2149.61	2150.88	3.0
2016-07-19	B	Futures	37.47	37.91	37.15	37.25	214363.0
2016-07-19	B6	Futures	1.3976	1.4003	1.3791	1.3808	114523.0
2016-07-19	BR	Futures	0.20103	0.20207	0.19997	0.20127	133.0
2016-07-19	BZ	Futures	37.41	37.76	37.03	37.11	20962.0
2016-07-19	C	Futures	2633.0	2641.0	2593.0	2595.0	10859.0
2016-07-19	CB	Futures	281.329	281.329	280.597	280.743	5.0
2016-07-19	CC	Futures	2249.0	2249.0	2192.0	2198.0	23171.0
2016-07-19	CNH	Futures	7.272	7.2732	7.272	7.2732	13.0
2016-07-19	CSC	Futures	3.703	3.72	3.69	3.72	30.0
2016-07-19	CT	Futures	83.3	83.76	82.09	82.65	13.0
2016-07-19	DC	Futures	29.8	30.04	29.61	29.86	147.0
2016-07-19	DX	Futures	89.834	90.388	89.778	90.316	24232.0
2016-07-19	E1	Futures	1.27855	1.2798	1.27129	1.27454	12784.0
2016-07-19	E6	Futures	1.29231	1.29312	1.28357	1.28544	146873.0
2016-07-19	E7	Futures	1.2856	1.2862	1.2768	1.2786	3848.0
2016-07-19	EBM	Futures	193.06	194.87	191.86	192.76	12769.0
2016-07-19	ED	Futures	95.7425	95.757	95.7329	95.7329	222336.0
2016-07-19	ER	Futures	98.318	98.318	98.313	98.313	32213.0
2016-07-19	EW	Futures	1635.8	1636.5	1626.2	1631.9	14621.0
2016-07-19	FBON	Futures	121.99	122.54	121.95	122.41	441.0
2016-07-19	FBTP	Futures	109.24	109.53	109.18	109.36	72628.0
2016-07-19	FBTS	Futures	101.311	101.329	101.293	101.302	14988.0
2016-07-19	FCE	Futures	3792.2	3803.5	3756.0	3779.1	71295.0
2016-07-19	FDAX	Futures	10662.7	10687.7	10546.1	10612.7	80083.0
2016-07-19	FDXM	Futures	10397.4	10417.1	10280.2	10344.5	19513.0
2016-07-19	FESX	Futures	2296.2	2304.8	2273.4	2292.2	1002887.0
2016-07-19	FGBL	Futures	149.88	150.15	149.67	149.81	536134.0
2016-07-19	FGBM	Futures	128.94	129.02	128.82	128.88	338847.0
2016-07-19	FGBS	Futures	111.932	111.947	111.897	111.917	193920.0
2016-07-19	FGBX	Futures	185.9	186.84	185.18	185.65	25180.0
2016-07-19	FMWO	Futures	5678.4	5678.4	5660.1	5667.4	132.0
2016-07-19	FOAT	Futures	137.84	138.03	137.61	137.72	67549.0
2016-07-19	FTDX	Futures	1579.2	1581.6	1573.9	1578.7	31.0
2016-07-19	FTI	Futures	399.39	400.7	396.56	399.75	23864.0
2016-07-19	FTUK	Futures	5548.5	5555.2	5511.4	5541.4	86032.0
2016-07-19	FVSA	Futures	2303.56	2386.53	2288.92	2308.44	11244.0
2016-07-19	FXXP	Futures	271.8	272.8	270.2	271.8	22296.0
2016-07-19	G	Futures	114.92	115.11	114.62	114.75	146832.0
2016-07-19	GF	Futures	282.651	285.996	278.608	279.357	3859.0
2016-07-19	GSCI	Futures	511.44	513.01	510.72	510.72	9.0
2016-07-19	HE	Futures	93.539	93.539	92.344	92.434	9347.0

> showing 50 of 108 rows — these rows as CSV

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