PREVIEW / futures_daily / 2017-01-20

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-20.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
2017-01-20	ES	Futures	2451.15	2463.89	2449.79	2456.57	1737181.0
2017-01-20	NQ	Futures	5958.45	5990.87	5945.78	5961.69	216184.0
2017-01-20	YM	Futures	20699.4	20833.2	20699.4	20797.4	150968.0
2017-01-20	CL	Futures	55.86	57.43	55.79	56.95	567231.0
2017-01-20	GC	Futures	1547.2	1560.0	1538.7	1547.3	244343.0
2017-01-20	ZN	Futures	121.339338	121.568569	121.064262	121.492158	1461739.0
2017-01-20	A6	Futures	0.7729	0.77628	0.769	0.77351	82928.0
2017-01-20	AD	Futures	0.76708	0.76928	0.7633	0.7678	77305.0
2017-01-20	ALI	Futures	2499.53	2518.46	2483.49	2518.46	185.0
2017-01-20	B	Futures	40.48	41.57	40.36	41.34	293535.0
2017-01-20	B6	Futures	1.2953	1.3001	1.2874	1.2999	98611.0
2017-01-20	BFX	Futures	4355.4	4355.4	4343.9	4350.5	7.0
2017-01-20	BR	Futures	0.22016	0.22166	0.22016	0.22166	5.0
2017-01-20	BZ	Futures	40.14	41.26	40.07	41.04	29231.0
2017-01-20	C	Futures	1814.0	1827.0	1799.0	1812.0	9002.0
2017-01-20	CB	Futures	279.024	279.085	274.66	276.583	19.0
2017-01-20	CC	Futures	1639.0	1649.0	1616.0	1629.0	17794.0
2017-01-20	CSC	Futures	4.036	4.036	4.015	4.018	26.0
2017-01-20	CT	Futures	83.7	84.35	83.54	83.9	12411.0
2017-01-20	DC	Futures	33.36	33.47	33.28	33.3	85.0
2017-01-20	DX	Futures	94.221	94.491	93.737	93.751	40552.0
2017-01-20	E1	Futures	1.23541	1.24111	1.2312	1.24074	18951.0
2017-01-20	E6	Futures	1.23397	1.23968	1.22981	1.23939	193044.0
2017-01-20	E7	Futures	1.2276	1.2332	1.2236	1.233	3912.0
2017-01-20	EBM	Futures	192.56	193.7	192.56	193.42	10647.0
2017-01-20	ED	Futures	95.5327	95.5472	95.523	95.5375	281543.0
2017-01-20	ER	Futures	98.313	98.313	98.303	98.303	84050.0
2017-01-20	EW	Futures	1774.6	1787.6	1774.6	1782.2	18191.0
2017-01-20	FBON	Futures	122.12	122.34	121.61	121.72	779.0
2017-01-20	FBTP	Futures	105.93	106.11	105.44	105.51	80528.0
2017-01-20	FBTS	Futures	101.828	101.864	101.819	101.828	20385.0
2017-01-20	FCE	Futures	4263.8	4288.0	4242.6	4270.8	97341.0
2017-01-20	FDAX	Futures	12237.3	12281.1	12187.1	12262.1	75286.0
2017-01-20	FDXM	Futures	12187.4	12231.6	12138.0	12212.7	21754.0
2017-01-20	FESX	Futures	2624.7	2642.3	2615.1	2630.3	920508.0
2017-01-20	FEU3	Futures	98.976	98.976	98.971	98.971	13.0
2017-01-20	FGBL	Futures	147.16	147.25	146.28	146.36	726552.0
2017-01-20	FGBM	Futures	128.85	128.89	128.57	128.6	487752.0
2017-01-20	FGBS	Futures	112.097	112.107	112.027	112.037	316729.0
2017-01-20	FGBX	Futures	166.25	166.65	163.45	163.62	44508.0
2017-01-20	FMWO	Futures	5955.2	5968.4	5950.3	5962.4	2052.0
2017-01-20	FOAT	Futures	132.38	132.55	131.61	131.68	90812.0
2017-01-20	FTDX	Futures	1800.4	1806.8	1798.0	1802.4	34.0
2017-01-20	FTI	Futures	441.19	443.52	439.32	441.79	41544.0
2017-01-20	FTUK	Futures	6066.5	6070.7	6032.1	6047.4	104422.0
2017-01-20	FVSA	Futures	840.79	843.16	817.11	833.69	23245.0
2017-01-20	FXXP	Futures	299.5	300.4	298.5	299.4	18945.0
2017-01-20	G	Futures	111.09	111.24	110.52	110.71	168038.0
2017-01-20	GF	Futures	296.594	300.355	293.288	299.272	5004.0
2017-01-20	GSCI	Futures	527.63	529.61	526.51	526.9	67.0

> showing 50 of 109 rows — these rows as CSV

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