PREVIEW / futures_daily / 2017-04-07

all futures daily files

  file:    by_date/futures_daily/2017/2017-04-07.parquet
  size:    10 KB
  rows:    112

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-04-07	ES	Futures	2557.9	2563.88	2537.81	2554.65	1473460.0
2017-04-07	NQ	Futures	6391.57	6402.46	6339.75	6385.09	243807.0
2017-04-07	YM	Futures	21757.6	21809.3	21590.9	21735.4	166432.0
2017-04-07	CL	Futures	54.19	55.49	53.97	54.75	796437.0
2017-04-07	GC	Futures	1603.5	1628.3	1601.6	1607.8	375412.0
2017-04-07	ZN	Futures	123.029383	123.674642	122.629937	122.722117	2067987.0
2017-04-07	A6	Futures	0.77332	0.77373	0.76818	0.76839	105721.0
2017-04-07	AD	Futures	0.76069	0.76508	0.75998	0.76095	72544.0
2017-04-07	ALI	Futures	2595.27	2595.27	2595.27	2595.27	0.0
2017-04-07	B	Futures	39.8	40.67	39.58	40.06	317775.0
2017-04-07	B6	Futures	1.3094	1.3103	1.2985	1.3001	125394.0
2017-04-07	BFX	Futures	4623.1	4626.8	4623.1	4626.8	1.0
2017-04-07	BR	Futures	0.22774	0.22894	0.22691	0.22691	37.0
2017-04-07	BZ	Futures	39.6	40.55	39.47	39.95	34387.0
2017-04-07	C	Futures	1722.0	1726.0	1666.0	1674.0	15496.0
2017-04-07	CB	Futures	261.814	261.814	259.983	259.983	25.0
2017-04-07	CC	Futures	1579.0	1579.0	1521.0	1534.0	40215.0
2017-04-07	CNH	Futures	7.2242	7.2261	7.2236	7.2236	6.0
2017-04-07	CSC	Futures	3.509	3.516	3.478	3.487	64.0
2017-04-07	CT	Futures	83.05	83.15	81.79	81.88	32502.0
2017-04-07	DC	Futures	28.58	28.8	28.39	28.61	282.0
2017-04-07	DX	Futures	93.767	94.27	93.539	94.207	37150.0
2017-04-07	E1	Futures	1.2339	1.23712	1.22884	1.22958	21040.0
2017-04-07	E6	Futures	1.22979	1.23423	1.22271	1.22369	204215.0
2017-04-07	E7	Futures	1.2233	1.2275	1.2165	1.2175	4146.0
2017-04-07	EBM	Futures	183.42	183.7	182.58	182.86	19820.0
2017-04-07	ED	Futures	95.5397	95.5639	95.53	95.5349	318038.0
2017-04-07	ER	Futures	98.328	98.332	98.323	98.328	47624.0
2017-04-07	EW	Futures	1815.8	1819.9	1798.5	1812.5	14954.0
2017-04-07	FBON	Futures	122.23	122.52	122.22	122.3	276.0
2017-04-07	FBTP	Futures	105.35	105.93	105.19	105.74	75081.0
2017-04-07	FBTS	Futures	101.873	101.945	101.845	101.927	28744.0
2017-04-07	FCE	Futures	4499.0	4536.9	4493.2	4526.3	82794.0
2017-04-07	FDAX	Futures	12891.8	12963.6	12845.8	12927.1	74524.0
2017-04-07	FDIV	Futures	145.45	145.89	145.45	145.89	7.0
2017-04-07	FDXM	Futures	12778.0	12849.1	12719.4	12813.6	22957.0
2017-04-07	FESX	Futures	2780.2	2804.7	2776.1	2794.1	854334.0
2017-04-07	FEU3	Futures	99.001	99.001	99.001	99.001	201.0
2017-04-07	FGBL	Futures	149.6	149.85	149.35	149.67	595523.0
2017-04-07	FGBM	Futures	129.84	130.01	129.79	129.97	340539.0
2017-04-07	FGBS	Futures	112.457	112.497	112.437	112.487	169338.0
2017-04-07	FGBX	Futures	171.5	172.46	170.76	171.96	35552.0
2017-04-07	FMWO	Futures	6188.0	6206.1	6188.0	6198.9	385.0
2017-04-07	FOAT	Futures	132.49	132.76	132.28	132.56	112117.0
2017-04-07	FTDX	Futures	1995.0	2007.3	1984.2	2005.8	130.0
2017-04-07	FTI	Futures	466.97	472.07	466.52	470.66	28188.0
2017-04-07	FTUK	Futures	6200.5	6245.4	6165.0	6234.7	95101.0
2017-04-07	FVSA	Futures	647.49	655.81	641.94	651.65	25857.0
2017-04-07	FXXP	Futures	315.5	318.0	315.1	317.1	34801.0
2017-04-07	G	Futures	115.64	116.06	115.41	115.72	135557.0

> showing 50 of 112 rows — these rows as CSV

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