PREVIEW / futures_daily / 2017-05-31

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-31.parquet
  size:    9 KB
  rows:    111

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-05-31	ES	Futures	2617.91	2624.69	2609.49	2618.45	1729723.0
2017-05-31	NQ	Futures	6822.35	6853.85	6788.48	6823.23	332645.0
2017-05-31	YM	Futures	22179.6	22221.8	22083.6	22160.6	128420.0
2017-05-31	CL	Futures	51.43	51.49	49.44	50.05	779144.0
2017-05-31	GC	Futures	1615.8	1629.9	1611.0	1628.1	204293.0
2017-05-31	ZN	Futures	124.319901	124.442808	124.150905	124.442808	260254.0
2017-05-31	A6	Futures	0.76562	0.76716	0.76192	0.76295	88155.0
2017-05-31	AD	Futures	0.75743	0.75957	0.75437	0.75534	73734.0
2017-05-31	ALI	Futures	2541.73	2541.73	2541.73	2541.73	0.0
2017-05-31	B	Futures	37.12	37.22	35.72	36.11	514958.0
2017-05-31	B6	Futures	1.3426	1.3554	1.3393	1.3524	159249.0
2017-05-31	BFX	Futures	4728.5	4728.5	4709.1	4709.1	1.0
2017-05-31	BR	Futures	0.22497	0.22497	0.22274	0.22493	5.0
2017-05-31	BZ	Futures	37.01	37.05	35.58	35.96	45703.0
2017-05-31	C	Futures	1598.0	1634.0	1590.0	1602.0	29537.0
2017-05-31	CB	Futures	297.751	302.89	297.507	301.886	18.0
2017-05-31	CC	Futures	1560.0	1575.0	1549.0	1566.0	37725.0
2017-05-31	CNH	Futures	7.1371	7.1395	7.0628	7.0671	198.0
2017-05-31	CSC	Futures	3.643	3.643	3.639	3.643	12.0
2017-05-31	CT	Futures	85.38	85.66	84.96	85.25	11569.0
2017-05-31	DC	Futures	30.47	30.57	30.36	30.56	42.0
2017-05-31	DX	Futures	90.702	90.767	90.18	90.235	27255.0
2017-05-31	E1	Futures	1.26875	1.27925	1.26727	1.27876	32028.0
2017-05-31	E6	Futures	1.28934	1.29729	1.2871	1.29654	211806.0
2017-05-31	E7	Futures	1.2825	1.2906	1.2805	1.2899	4039.0
2017-05-31	EBM	Futures	186.23	186.78	185.67	185.67	5431.0
2017-05-31	ED	Futures	95.5954	95.5954	95.5905	95.5954	181413.0
2017-05-31	ER	Futures	98.337	98.337	98.332	98.337	19181.0
2017-05-31	EW	Futures	1827.4	1834.0	1810.0	1828.2	20464.0
2017-05-31	FBON	Futures	123.76	123.95	123.55	123.74	788.0
2017-05-31	FBTP	Futures	106.85	107.07	106.59	106.8	122790.0
2017-05-31	FBTS	Futures	102.48	102.535	102.462	102.498	43801.0
2017-05-31	FCE	Futures	4738.5	4777.5	4726.3	4730.4	99634.0
2017-05-31	FDAX	Futures	13276.0	13416.5	13276.0	13342.0	108516.0
2017-05-31	FDXM	Futures	13159.9	13298.1	13158.9	13224.8	32101.0
2017-05-31	FESX	Futures	2893.6	2922.2	2891.2	2900.2	1216080.0
2017-05-31	FEU3	Futures	99.011	99.011	99.006	99.011	9.0
2017-05-31	FGBL	Futures	149.27	149.3	148.95	149.18	953498.0
2017-05-31	FGBM	Futures	129.7	129.76	129.61	129.73	669425.0
2017-05-31	FGBS	Futures	112.332	112.357	112.312	112.352	367810.0
2017-05-31	FGBX	Futures	168.25	168.37	167.43	168.07	52532.0
2017-05-31	FMWO	Futures	6427.8	6448.2	6420.5	6426.6	1118.0
2017-05-31	FOAT	Futures	135.61	135.88	135.53	135.69	166584.0
2017-05-31	FTDX	Futures	2242.5	2259.2	2233.7	2242.0	157.0
2017-05-31	FTI	Futures	481.3	483.41	479.79	480.15	29268.0
2017-05-31	FTUK	Futures	6430.2	6479.0	6417.0	6425.1	151556.0
2017-05-31	FVSA	Futures	511.28	519.75	502.82	514.67	10004.0
2017-05-31	FXXP	Futures	328.6	330.5	328.0	328.9	41441.0
2017-05-31	G	Futures	116.49	116.64	115.96	116.16	208992.0
2017-05-31	GF	Futures	330.101	336.193	328.18	334.93	7316.0

> showing 50 of 111 rows — these rows as CSV

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