PREVIEW / futures_daily / 2016-11-09

all futures daily files

  file:    by_date/futures_daily/2016/2016-11-09.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-09	ES	Futures	2312.45	2343.55	2194.02	2336.52	5280237.0
2016-11-09	NQ	Futures	5665.58	5701.23	5372.41	5681.19	719499.0
2016-11-09	YM	Futures	19220.1	19520.4	18289.7	19459.5	651872.0
2016-11-09	CL	Futures	48.91	50.14	47.0	49.4	946512.0
2016-11-09	GC	Futures	1638.1	1717.1	1627.0	1633.9	816531.0
2016-11-09	ZN	Futures	125.994867	127.438891	124.35324	124.550843	4231834.0
2016-11-09	A6	Futures	0.78938	0.79224	0.77254	0.77958	258989.0
2016-11-09	AD	Futures	0.77079	0.77248	0.75732	0.76413	144870.0
2016-11-09	ALI	Futures	2358.57	2368.17	2354.4	2364.01	30.0
2016-11-09	B	Futures	34.97	35.66	33.73	35.21	448124.0
2016-11-09	B6	Futures	1.3032	1.322	1.3014	1.3106	168362.0
2016-11-09	BFX	Futures	4096.7	4200.3	4096.7	4200.3	3.0
2016-11-09	BR	Futures	0.21171	0.21284	0.20633	0.21253	2984.0
2016-11-09	BZ	Futures	34.74	35.49	33.56	35.05	53512.0
2016-11-09	C	Futures	2169.0	2195.0	2169.0	2187.0	5081.0
2016-11-09	CB	Futures	238.688	240.176	238.688	238.688	72.0
2016-11-09	CC	Futures	1871.0	1895.0	1861.0	1866.0	23913.0
2016-11-09	CNH	Futures	7.3125	7.3561	7.2952	7.3543	151.0
2016-11-09	CSC	Futures	4.011	4.018	3.983	3.99	33.0
2016-11-09	CT	Futures	76.83	77.63	76.03	76.51	28665.0
2016-11-09	DC	Futures	31.64	31.85	31.04	31.52	359.0
2016-11-09	DX	Futures	91.285	91.858	89.261	91.703	88378.0
2016-11-09	E1	Futures	1.27471	1.30736	1.26749	1.26824	56588.0
2016-11-09	E6	Futures	1.27863	1.3119	1.26588	1.2689	461271.0
2016-11-09	E7	Futures	1.2718	1.3045	1.2591	1.262	9074.0
2016-11-09	EBM	Futures	188.29	190.94	188.29	189.17	17621.0
2016-11-09	ED	Futures	95.62	95.7214	95.6055	95.6393	1526749.0
2016-11-09	ER	Futures	98.264	98.274	98.264	98.269	76565.0
2016-11-09	EW	Futures	1609.2	1641.7	1525.9	1636.7	29468.0
2016-11-09	FBON	Futures	123.44	123.46	122.83	123.06	129.0
2016-11-09	FBTP	Futures	105.98	106.19	105.66	105.95	150179.0
2016-11-09	FBTS	Futures	100.979	101.032	100.979	101.023	19673.0
2016-11-09	FCE	Futures	3814.4	4067.3	3788.1	4045.5	241782.0
2016-11-09	FDAX	Futures	10593.9	11284.5	10581.2	11231.1	200955.0
2016-11-09	FDXM	Futures	10584.7	11261.7	10549.9	11206.8	68010.0
2016-11-09	FESX	Futures	2307.6	2456.6	2302.0	2439.8	2544985.0
2016-11-09	FGBL	Futures	148.52	149.0	146.9	147.92	1204379.0
2016-11-09	FGBM	Futures	128.58	128.66	128.11	128.42	744387.0
2016-11-09	FGBS	Futures	111.907	111.947	111.832	111.882	399995.0
2016-11-09	FGBX	Futures	177.64	180.04	173.46	176.78	87538.0
2016-11-09	FMWO	Futures	5534.4	5668.7	5534.4	5668.7	1514.0
2016-11-09	FOAT	Futures	135.68	136.08	134.53	135.02	224327.0
2016-11-09	FTDX	Futures	1663.2	1715.1	1663.2	1713.2	369.0
2016-11-09	FTI	Futures	395.41	419.09	391.0	416.56	84298.0
2016-11-09	FTUK	Futures	5795.9	5851.6	5479.8	5803.1	199276.0
2016-11-09	FVSA	Futures	1480.99	1480.99	1255.28	1280.02	48718.0
2016-11-09	FXXP	Futures	265.1	281.2	264.0	280.1	66700.0
2016-11-09	G	Futures	112.16	112.55	111.15	111.87	260525.0
2016-11-09	GF	Futures	266.292	268.761	265.809	267.473	725.0
2016-11-09	GSCI	Futures	488.65	492.39	487.33	488.58	2713.0

> showing 50 of 109 rows — these rows as CSV

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