PREVIEW / futures_daily / 2017-02-14

all futures daily files

  file:    by_date/futures_daily/2017/2017-02-14.parquet
  size:    9 KB
  rows:    108

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-14	ES	Futures	2522.16	2534.35	2514.84	2533.54	1390309.0
2017-02-14	NQ	Futures	6198.59	6220.69	6175.61	6218.34	166904.0
2017-02-14	YM	Futures	21468.3	21588.4	21430.4	21573.6	120445.0
2017-02-14	CL	Futures	56.68	57.5	56.62	56.99	253676.0
2017-02-14	GC	Futures	1566.3	1579.0	1562.0	1565.4	233752.0
2017-02-14	ZN	Futures	121.813081	121.889491	121.247646	121.50744	1536726.0
2017-02-14	A6	Futures	0.78191	0.78775	0.77965	0.78324	88754.0
2017-02-14	AD	Futures	0.78169	0.7844	0.77939	0.78138	54999.0
2017-02-14	ALI	Futures	2558.22	2558.22	2558.22	2558.22	0.0
2017-02-14	B	Futures	41.11	41.64	40.95	41.27	254982.0
2017-02-14	B6	Futures	1.3144	1.317	1.3058	1.3081	106937.0
2017-02-14	BR	Futures	0.22827	0.23062	0.22678	0.22895	1382.0
2017-02-14	BZ	Futures	40.87	41.42	40.76	41.06	25975.0
2017-02-14	C	Futures	1605.0	1633.0	1580.0	1597.0	10504.0
2017-02-14	CB	Futures	261.203	264.408	261.203	263.95	32.0
2017-02-14	CC	Futures	1456.0	1483.0	1445.0	1454.0	22994.0
2017-02-14	CNH	Futures	7.2704	7.2704	7.2436	7.2543	53.0
2017-02-14	CSC	Futures	3.847	3.903	3.847	3.896	78.0
2017-02-14	CT	Futures	88.05	88.14	87.19	87.67	20502.0
2017-02-14	DC	Futures	32.13	32.48	32.08	32.36	192.0
2017-02-14	DX	Futures	93.993	94.398	93.761	94.257	38108.0
2017-02-14	E1	Futures	1.23343	1.23715	1.2307	1.23256	17249.0
2017-02-14	E6	Futures	1.22501	1.22946	1.22103	1.22242	201934.0
2017-02-14	E7	Futures	1.2185	1.223	1.2147	1.2161	5418.0
2017-02-14	EBM	Futures	196.27	197.41	195.41	197.12	13540.0
2017-02-14	ED	Futures	95.5665	95.5689	95.5448	95.552	388812.0
2017-02-14	ER	Futures	98.303	98.303	98.298	98.298	23219.0
2017-02-14	EW	Futures	1835.4	1843.2	1827.2	1839.7	12317.0
2017-02-14	FBON	Futures	120.38	120.57	120.11	120.2	596.0
2017-02-14	FBTP	Futures	103.84	104.3	103.66	103.84	95777.0
2017-02-14	FBTS	Futures	101.512	101.593	101.512	101.557	34283.0
2017-02-14	FCE	Futures	4297.6	4321.4	4291.0	4306.4	184349.0
2017-02-14	FDAX	Futures	12422.5	12457.4	12400.9	12425.7	62449.0
2017-02-14	FDXM	Futures	12372.5	12406.1	12351.5	12375.6	20251.0
2017-02-14	FESX	Futures	2643.9	2655.9	2636.7	2646.3	664736.0
2017-02-14	FGBL	Futures	147.88	147.97	147.23	147.38	739945.0
2017-02-14	FGBM	Futures	129.35	129.39	129.17	129.26	474224.0
2017-02-14	FGBS	Futures	112.287	112.302	112.267	112.282	228072.0
2017-02-14	FGBX	Futures	167.04	167.42	164.95	165.32	44549.0
2017-02-14	FMWO	Futures	6093.9	6098.7	6077.0	6089.1	1929.0
2017-02-14	FOAT	Futures	130.71	130.97	130.34	130.52	108724.0
2017-02-14	FTDX	Futures	1840.6	1851.4	1840.6	1845.5	136.0
2017-02-14	FTI	Futures	448.39	449.8	447.21	448.16	27615.0
2017-02-14	FTUK	Futures	6119.5	6128.4	6091.9	6111.8	90039.0
2017-02-14	FVSA	Futures	715.66	732.4	715.66	724.03	29097.0
2017-02-14	FXXP	Futures	306.0	307.1	305.2	306.2	22454.0
2017-02-14	G	Futures	112.12	112.26	111.7	111.89	192109.0
2017-02-14	GF	Futures	277.729	283.029	277.387	282.687	5151.0
2017-02-14	GSCI	Futures	523.91	523.91	519.92	521.6	610.0
2017-02-14	HE	Futures	89.285	91.357	89.285	90.943	15672.0

> showing 50 of 108 rows — these rows as CSV

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