PREVIEW / futures_daily / 2016-07-28

all futures daily files

  file:    by_date/futures_daily/2016/2016-07-28.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-28	ES	Futures	2335.1	2341.31	2325.11	2337.26	1622142.0
2016-07-28	NQ	Futures	5552.14	5577.78	5527.68	5563.34	220001.0
2016-07-28	YM	Futures	19229.6	19275.5	19107.4	19194.1	131774.0
2016-07-28	CL	Futures	47.53	47.86	46.52	46.63	447913.0
2016-07-28	GC	Futures	1728.9	1735.4	1718.2	1720.8	194758.0
2016-07-28	ZN	Futures	128.105293	128.210928	127.818569	128.029839	1109267.0
2016-07-28	A6	Futures	0.76103	0.76683	0.76042	0.76205	69116.0
2016-07-28	AD	Futures	0.77659	0.78134	0.77592	0.77766	56185.0
2016-07-28	ALI	Futures	2099.32	2100.6	2099.32	2100.6	3.0
2016-07-28	B	Futures	34.74	34.9	34.09	34.17	336668.0
2016-07-28	B6	Futures	1.3939	1.398	1.3839	1.3873	77279.0
2016-07-28	BR	Futures	0.20137	0.2017	0.1997	0.1999	2521.0
2016-07-28	BZ	Futures	34.62	34.73	33.93	34.0	24974.0
2016-07-28	C	Futures	2509.0	2514.0	2472.0	2483.0	18392.0
2016-07-28	CB	Futures	267.263	267.263	255.541	259.087	41.0
2016-07-28	CC	Futures	2114.0	2120.0	2087.0	2090.0	18447.0
2016-07-28	CNH	Futures	7.2214	7.2214	7.2192	7.2192	1.0
2016-07-28	CSC	Futures	3.762	3.773	3.747	3.773	40.0
2016-07-28	CT	Futures	83.66	83.66	80.85	82.72	46.0
2016-07-28	DC	Futures	30.16	30.18	29.95	30.18	133.0
2016-07-28	DX	Futures	89.881	89.992	89.513	89.956	22984.0
2016-07-28	E1	Futures	1.27241	1.2818	1.27229	1.2798	18481.0
2016-07-28	E6	Futures	1.28945	1.29725	1.28934	1.29172	142672.0
2016-07-28	E7	Futures	1.2827	1.2903	1.2824	1.2849	2616.0
2016-07-28	EBM	Futures	197.57	200.88	197.27	199.38	12427.0
2016-07-28	ED	Futures	95.6846	95.6894	95.6702	95.6798	182099.0
2016-07-28	ER	Futures	98.308	98.313	98.308	98.308	32982.0
2016-07-28	EW	Futures	1637.1	1647.7	1634.0	1644.8	12152.0
2016-07-28	FBON	Futures	123.15	123.4	123.15	123.35	57.0
2016-07-28	FBTP	Futures	109.84	109.9	109.62	109.84	88486.0
2016-07-28	FBTS	Futures	101.293	101.293	101.257	101.266	13880.0
2016-07-28	FCE	Futures	3877.3	3907.4	3855.0	3859.0	75283.0
2016-07-28	FDAX	Futures	10966.5	11046.8	10917.0	10955.8	88050.0
2016-07-28	FDXM	Futures	10688.9	10767.7	10641.2	10679.0	21010.0
2016-07-28	FESX	Futures	2341.6	2353.3	2318.9	2325.9	989189.0
2016-07-28	FGBL	Futures	150.76	150.83	150.38	150.64	455640.0
2016-07-28	FGBM	Futures	128.94	128.96	128.77	128.86	346538.0
2016-07-28	FGBS	Futures	111.887	111.887	111.837	111.862	181788.0
2016-07-28	FGBX	Futures	190.5	191.34	190.01	190.93	25923.0
2016-07-28	FMWO	Futures	5708.8	5724.6	5685.6	5690.5	71.0
2016-07-28	FOAT	Futures	138.72	138.77	138.35	138.59	69095.0
2016-07-28	FTDX	Futures	1652.9	1654.9	1638.5	1640.9	199.0
2016-07-28	FTI	Futures	404.16	404.97	399.39	399.75	29110.0
2016-07-28	FTUK	Futures	5581.1	5599.0	5554.4	5576.1	95078.0
2016-07-28	FVSA	Futures	2235.23	2279.16	2230.35	2269.4	8462.0
2016-07-28	FXXP	Futures	275.7	277.3	273.5	274.2	19442.0
2016-07-28	G	Futures	115.58	115.79	115.36	115.65	181173.0
2016-07-28	GF	Futures	283.5	287.943	279.357	280.505	3625.0
2016-07-28	GSCI	Futures	486.11	487.69	482.74	483.09	50.0
2016-07-28	HE	Futures	85.712	85.772	82.187	82.276	12268.0

> showing 50 of 108 rows — these rows as CSV

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