PREVIEW / futures_daily / 2017-02-17

all futures daily files

  file:    by_date/futures_daily/2017/2017-02-17.parquet
  size:    9 KB
  rows:    109

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-17	ES	Futures	2542.21	2546.28	2533.0	2545.47	1399520.0
2017-02-17	NQ	Futures	6246.92	6280.51	6231.01	6276.97	170805.0
2017-02-17	YM	Futures	21691.6	21703.2	21598.9	21685.3	122287.0
2017-02-17	CL	Futures	57.16	57.2	56.55	57.07	411983.0
2017-02-17	GC	Futures	1585.1	1590.6	1578.1	1582.9	164405.0
2017-02-17	ZN	Futures	121.706107	122.164568	121.614415	121.965901	1124874.0
2017-02-17	A6	Futures	0.78764	0.78949	0.78365	0.78396	63156.0
2017-02-17	AD	Futures	0.78164	0.78215	0.77822	0.77959	41892.0
2017-02-17	ALI	Futures	2544.76	2544.76	2544.76	2544.76	0.0
2017-02-17	B	Futures	41.1	41.21	40.63	41.16	270492.0
2017-02-17	B6	Futures	1.3098	1.3128	1.2999	1.3025	104260.0
2017-02-17	BFX	Futures	4397.8	4397.8	4348.1	4372.9	433.0
2017-02-17	BR	Futures	0.23076	0.23076	0.22841	0.22944	1284.0
2017-02-17	BZ	Futures	40.84	40.99	40.43	40.95	27599.0
2017-02-17	C	Futures	1711.0	1724.0	1667.0	1672.0	6978.0
2017-02-17	CB	Futures	267.306	269.137	265.75	266.086	15.0
2017-02-17	CC	Futures	1563.0	1573.0	1518.0	1527.0	18475.0
2017-02-17	CNH	Futures	7.2554	7.2583	7.2524	7.2551	18.0
2017-02-17	CSC	Futures	3.875	3.88	3.868	3.877	66.0
2017-02-17	CT	Futures	86.23	86.33	83.88	84.41	14854.0
2017-02-17	DC	Futures	32.29	32.46	32.17	32.29	225.0
2017-02-17	DX	Futures	93.57	94.003	93.518	93.994	27265.0
2017-02-17	E1	Futures	1.24458	1.24483	1.23653	1.23677	16403.0
2017-02-17	E6	Futures	1.2335	1.23425	1.22594	1.22605	158980.0
2017-02-17	E7	Futures	1.227	1.228	1.2196	1.2198	2845.0
2017-02-17	EBM	Futures	194.56	195.7	194.27	195.41	10614.0
2017-02-17	ED	Futures	95.5423	95.552	95.5399	95.5496	178620.0
2017-02-17	ER	Futures	98.298	98.303	98.298	98.303	33354.0
2017-02-17	EW	Futures	1842.6	1846.7	1832.5	1845.6	10334.0
2017-02-17	FBON	Futures	120.81	121.06	120.68	120.76	602.0
2017-02-17	FBTP	Futures	104.17	104.34	103.96	104.15	95979.0
2017-02-17	FBTS	Futures	101.602	101.656	101.575	101.611	33342.0
2017-02-17	FCE	Futures	4306.9	4312.6	4258.9	4280.9	117593.0
2017-02-17	FDAX	Futures	12402.0	12452.1	12338.1	12388.2	79137.0
2017-02-17	FDXM	Futures	12357.8	12400.9	12288.4	12338.3	31680.0
2017-02-17	FESX	Futures	2647.1	2655.1	2623.9	2640.7	1089533.0
2017-02-17	FGBL	Futures	147.71	148.48	147.56	148.29	745506.0
2017-02-17	FGBM	Futures	129.26	129.53	129.17	129.48	508537.0
2017-02-17	FGBS	Futures	112.247	112.332	112.227	112.322	335851.0
2017-02-17	FGBX	Futures	166.33	168.67	165.88	167.97	45423.0
2017-02-17	FMWO	Futures	6119.2	6126.4	6112.0	6120.4	2341.0
2017-02-17	FOAT	Futures	130.85	130.98	130.47	130.69	158379.0
2017-02-17	FTDX	Futures	1851.4	1852.4	1845.0	1850.4	68.0
2017-02-17	FTI	Futures	448.52	456.66	444.94	453.34	56965.0
2017-02-17	FTUK	Futures	6147.5	6170.3	6116.9	6149.6	101285.0
2017-02-17	FVSA	Futures	724.03	747.04	721.93	730.3	12455.0
2017-02-17	FXXP	Futures	306.1	307.6	304.4	306.0	32692.0
2017-02-17	G	Futures	112.36	113.2	112.32	113.02	179591.0
2017-02-17	GF	Futures	282.06	283.941	281.319	282.858	3293.0
2017-02-17	GSCI	Futures	516.58	518.38	516.19	518.38	24.0

> showing 50 of 109 rows — these rows as CSV

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