PREVIEW / futures_daily / 2017-06-20

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-20.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-06-20	ES	Futures	2660.27	2663.8	2645.33	2649.13	1332027.0
2017-06-20	NQ	Futures	6779.05	6799.33	6734.68	6739.08	301241.0
2017-06-20	YM	Futures	22697.2	22721.5	22639.0	22661.2	114957.0
2017-06-20	CL	Futures	45.78	46.15	44.34	44.93	894104.0
2017-06-20	GC	Futures	1589.8	1595.0	1586.0	1587.4	185394.0
2017-06-20	ZN	Futures	124.534775	124.857962	124.457826	124.842573	1096330.0
2017-06-20	A6	Futures	0.77969	0.78215	0.77681	0.77794	71060.0
2017-06-20	AD	Futures	0.77055	0.77146	0.76673	0.76841	62108.0
2017-06-20	ALI	Futures	2492.87	2492.87	2492.87	2492.87	0.0
2017-06-20	B	Futures	33.41	33.6	32.31	32.74	343458.0
2017-06-20	B6	Futures	1.3348	1.3372	1.3209	1.3235	145264.0
2017-06-20	BR	Futures	0.22119	0.22126	0.21948	0.21948	145.0
2017-06-20	BZ	Futures	33.22	33.45	32.18	32.6	30670.0
2017-06-20	C	Futures	1568.0	1586.0	1560.0	1573.0	3304.0
2017-06-20	CB	Futures	319.92	324.36	319.92	324.177	13.0
2017-06-20	CC	Futures	1474.0	1480.0	1448.0	1456.0	20365.0
2017-06-20	CNH	Futures	7.1054	7.1063	7.0983	7.0983	71.0
2017-06-20	CSC	Futures	3.561	3.561	3.534	3.538	42.0
2017-06-20	CT	Futures	79.23	79.35	78.41	79.02	4022.0
2017-06-20	DC	Futures	29.81	29.81	29.55	29.58	274.0
2017-06-20	DX	Futures	90.837	91.056	90.701	90.96	30217.0
2017-06-20	E1	Futures	1.26597	1.27014	1.26486	1.2667	18917.0
2017-06-20	E6	Futures	1.28345	1.28539	1.28012	1.28127	152326.0
2017-06-20	E7	Futures	1.2767	1.2786	1.2734	1.2745	4038.0
2017-06-20	EBM	Futures	198.75	200.42	195.69	197.08	30558.0
2017-06-20	ED	Futures	95.5692	95.5789	95.5644	95.5789	190408.0
2017-06-20	ER	Futures	98.332	98.337	98.328	98.332	121899.0
2017-06-20	EW	Futures	1872.5	1874.1	1852.6	1853.5	10761.0
2017-06-20	FBON	Futures	124.59	125.29	124.59	125.13	441.0
2017-06-20	FBTP	Futures	109.43	110.05	109.43	109.86	61258.0
2017-06-20	FBTS	Futures	102.845	102.909	102.845	102.89	21505.0
2017-06-20	FCE	Futures	4795.7	4807.8	4749.7	4765.0	72602.0
2017-06-20	FDAX	Futures	13610.5	13633.6	13448.3	13499.9	69117.0
2017-06-20	FDIV	Futures	153.76	153.76	152.97	152.97	30.0
2017-06-20	FDXM	Futures	13519.9	13550.3	13368.2	13416.8	19841.0
2017-06-20	FESX	Futures	2927.1	2932.0	2892.0	2901.8	751993.0
2017-06-20	FEU3	Futures	99.006	99.006	99.006	99.006	1.0
2017-06-20	FGBL	Futures	149.57	149.91	149.53	149.82	493108.0
2017-06-20	FGBM	Futures	129.55	129.66	129.51	129.56	275627.0
2017-06-20	FGBS	Futures	112.262	112.282	112.227	112.247	178660.0
2017-06-20	FGBX	Futures	170.16	171.19	169.92	170.99	43494.0
2017-06-20	FMWO	Futures	6467.4	6467.4	6416.2	6432.9	788.0
2017-06-20	FOAT	Futures	136.87	137.17	136.77	137.07	64569.0
2017-06-20	FTDX	Futures	2320.2	2320.2	2287.7	2293.2	112.0
2017-06-20	FTI	Futures	486.36	487.79	478.52	479.95	29665.0
2017-06-20	FTUK	Futures	6466.9	6480.7	6382.6	6410.7	98547.0
2017-06-20	FVSA	Futures	447.15	481.79	445.58	472.34	42166.0
2017-06-20	FXXP	Futures	333.7	333.8	329.5	330.4	37359.0
2017-06-20	G	Futures	116.17	116.69	116.04	116.52	160961.0
2017-06-20	GF	Futures	316.436	318.137	309.027	315.942	6830.0

> showing 50 of 110 rows — these rows as CSV

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