PREVIEW / futures_daily / 2017-02-23

all futures daily files

  file:    by_date/futures_daily/2017/2017-02-23.parquet
  size:    9 KB
  rows:    110

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-02-23	ES	Futures	2560.64	2566.61	2550.89	2561.46	1556359.0
2017-02-23	NQ	Futures	6308.5	6318.81	6259.29	6284.34	240394.0
2017-02-23	YM	Futures	21868.6	21926.5	21828.5	21905.4	138561.0
2017-02-23	CL	Futures	57.2	58.3	57.16	57.78	529880.0
2017-02-23	GC	Futures	1581.9	1599.7	1579.5	1598.6	264971.0
2017-02-23	ZN	Futures	122.042312	122.40908	121.996466	122.302106	3329428.0
2017-02-23	A6	Futures	0.78836	0.79246	0.78457	0.78979	86179.0
2017-02-23	AD	Futures	0.77627	0.78087	0.77561	0.77903	56986.0
2017-02-23	ALI	Futures	2520.72	2520.72	2520.72	2520.72	0.0
2017-02-23	B	Futures	41.18	41.97	41.16	41.49	246909.0
2017-02-23	B6	Futures	1.3071	1.318	1.3039	1.3159	117078.0
2017-02-23	BFX	Futures	4376.6	4376.6	4369.9	4369.9	1.0
2017-02-23	BR	Futures	0.23238	0.23277	0.23151	0.23151	4968.0
2017-02-23	BZ	Futures	40.97	41.78	40.95	41.3	28185.0
2017-02-23	C	Futures	1659.0	1683.0	1654.0	1677.0	5844.0
2017-02-23	CB	Futures	272.799	274.63	272.799	274.05	27.0
2017-02-23	CC	Futures	1522.0	1553.0	1522.0	1547.0	14799.0
2017-02-23	CNH	Futures	7.2493	7.2493	7.2353	7.2353	7.0
2017-02-23	CSC	Futures	3.793	3.824	3.793	3.815	144.0
2017-02-23	CT	Futures	84.14	85.45	84.1	84.82	10228.0
2017-02-23	DC	Futures	31.56	31.9	31.51	31.71	156.0
2017-02-23	DX	Futures	94.366	94.445	93.905	94.089	32820.0
2017-02-23	E1	Futures	1.22723	1.2338	1.22624	1.23169	15838.0
2017-02-23	E6	Futures	1.22005	1.22461	1.21785	1.2219	168514.0
2017-02-23	E7	Futures	1.2138	1.2182	1.2116	1.2157	2850.0
2017-02-23	EBM	Futures	196.27	197.12	195.98	195.98	13560.0
2017-02-23	ED	Futures	95.5448	95.5544	95.5399	95.5472	247696.0
2017-02-23	ER	Futures	98.303	98.308	98.298	98.308	31928.0
2017-02-23	EW	Futures	1854.6	1859.9	1837.4	1844.9	12963.0
2017-02-23	FBON	Futures	120.3	120.51	120.01	120.23	770.0
2017-02-23	FBTP	Futures	103.94	104.23	103.64	103.86	124808.0
2017-02-23	FBTS	Futures	101.485	101.503	101.403	101.449	54341.0
2017-02-23	FCE	Futures	4311.7	4325.3	4292.8	4302.9	69629.0
2017-02-23	FDAX	Futures	12670.1	12682.7	12587.2	12603.0	64227.0
2017-02-23	FDXM	Futures	12621.7	12632.2	12536.5	12552.3	21006.0
2017-02-23	FESX	Futures	2672.7	2679.9	2659.1	2663.9	1021575.0
2017-02-23	FEU3	Futures	98.971	98.971	98.971	98.971	13.0
2017-02-23	FGBL	Futures	148.89	149.53	148.66	149.38	781843.0
2017-02-23	FGBM	Futures	129.93	130.24	129.86	130.15	535747.0
2017-02-23	FGBS	Futures	112.472	112.547	112.437	112.512	333335.0
2017-02-23	FGBX	Futures	169.26	171.06	168.57	170.82	58007.0
2017-02-23	FMWO	Futures	6181.9	6181.9	6156.6	6156.6	1096.0
2017-02-23	FOAT	Futures	130.89	131.63	130.74	131.31	224806.0
2017-02-23	FTDX	Futures	1880.8	1897.0	1874.9	1874.9	330.0
2017-02-23	FTI	Futures	453.29	454.7	451.48	452.07	21107.0
2017-02-23	FTUK	Futures	6166.1	6185.6	6144.5	6149.1	91710.0
2017-02-23	FVSA	Futures	715.66	734.49	709.38	732.4	22478.0
2017-02-23	FXXP	Futures	309.1	310.0	308.5	308.9	22867.0
2017-02-23	G	Futures	113.27	113.8	113.18	113.78	336289.0
2017-02-23	GF	Futures	285.48	287.019	284.91	285.309	4801.0

> showing 50 of 110 rows — these rows as CSV

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