PREVIEW / futures_daily / 2016-11-02

all futures daily files

  file:    by_date/futures_daily/2016/2016-11-02.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-11-02	ES	Futures	2273.79	2278.38	2257.56	2262.97	2013595.0
2016-11-02	NQ	Futures	5603.41	5619.91	5548.9	5558.92	300313.0
2016-11-02	YM	Futures	18832.6	18858.8	18717.1	18775.9	200698.0
2016-11-02	CL	Futures	50.55	50.71	49.06	49.48	674322.0
2016-11-02	GC	Futures	1653.8	1679.8	1653.0	1678.4	241704.0
2016-11-02	ZN	Futures	126.207671	126.724479	126.19247	126.496475	1480569.0
2016-11-02	A6	Futures	0.7801	0.78254	0.77591	0.7802	83729.0
2016-11-02	AD	Futures	0.76536	0.76695	0.76326	0.7647	71545.0
2016-11-02	ALI	Futures	2279.46	2279.46	2271.77	2271.77	5.0
2016-11-02	B	Futures	36.38	36.48	35.29	35.59	366824.0
2016-11-02	B6	Futures	1.2898	1.3017	1.2877	1.2946	119492.0
2016-11-02	BFX	Futures	4110.4	4110.4	4102.6	4102.6	3.0
2016-11-02	BR	Futures	0.21037	0.21092	0.20794	0.20982	1138.0
2016-11-02	BZ	Futures	36.27	36.34	35.14	35.42	47015.0
2016-11-02	C	Futures	2379.0	2385.0	2360.0	2375.0	5839.0
2016-11-02	CB	Futures	238.068	239.308	238.006	238.037	23.0
2016-11-02	CC	Futures	1997.0	2010.0	1971.0	2004.0	18156.0
2016-11-02	CNH	Futures	7.2943	7.2965	7.2875	7.2875	4.0
2016-11-02	CSC	Futures	3.912	3.937	3.903	3.903	81.0
2016-11-02	CT	Futures	76.46	77.05	76.26	76.85	15713.0
2016-11-02	DC	Futures	30.6	31.08	30.53	30.74	686.0
2016-11-02	DX	Futures	90.997	91.02	90.443	90.665	27791.0
2016-11-02	E1	Futures	1.28182	1.28817	1.28045	1.28319	34650.0
2016-11-02	E6	Futures	1.28426	1.29173	1.28333	1.28854	203584.0
2016-11-02	E7	Futures	1.2771	1.2847	1.2764	1.2816	3430.0
2016-11-02	EBM	Futures	191.82	193.0	191.23	191.53	15464.0
2016-11-02	ED	Futures	95.6393	95.6538	95.6393	95.6442	366564.0
2016-11-02	ER	Futures	98.269	98.274	98.264	98.264	86688.0
2016-11-02	EW	Futures	1584.2	1585.9	1567.5	1570.3	20552.0
2016-11-02	FBON	Futures	122.89	123.6	122.7	123.46	152.0
2016-11-02	FBTP	Futures	106.08	106.78	105.85	106.67	134538.0
2016-11-02	FBTS	Futures	100.907	101.014	100.889	100.996	36300.0
2016-11-02	FCE	Futures	3940.4	3960.0	3913.7	3928.8	99534.0
2016-11-02	FDAX	Futures	11031.4	11059.4	10908.8	10964.3	112880.0
2016-11-02	FDXM	Futures	11008.6	11036.0	10889.4	10940.6	27986.0
2016-11-02	FESX	Futures	2396.5	2402.1	2372.5	2383.7	1220308.0
2016-11-02	FGBL	Futures	148.2	148.63	148.08	148.43	837664.0
2016-11-02	FGBM	Futures	128.34	128.48	128.3	128.43	511660.0
2016-11-02	FGBS	Futures	111.837	111.867	111.832	111.852	262432.0
2016-11-02	FGBX	Futures	177.36	178.76	177.13	178.11	50677.0
2016-11-02	FMWO	Futures	5585.2	5610.6	5585.2	5593.7	2866.0
2016-11-02	FOAT	Futures	135.43	135.94	135.32	135.73	149538.0
2016-11-02	FTDX	Futures	1656.8	1664.2	1650.4	1651.9	187.0
2016-11-02	FTI	Futures	409.85	410.31	405.48	406.81	35292.0
2016-11-02	FTUK	Futures	5799.7	5807.3	5738.1	5757.9	119409.0
2016-11-02	FVSA	Futures	1462.44	1487.17	1443.89	1459.35	33827.0
2016-11-02	FXXP	Futures	274.3	275.2	272.6	273.1	29970.0
2016-11-02	G	Futures	111.83	112.51	111.8	112.29	229924.0
2016-11-02	GF	Futures	271.661	273.486	269.352	271.822	1961.0
2016-11-02	GSCI	Futures	500.35	502.91	489.89	492.18	1346.0

> showing 50 of 109 rows — these rows as CSV

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