PREVIEW / futures_daily / 2017-11-17

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-17.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-11-17	ES	Futures	2810.87	2812.78	2800.54	2802.17	1186958.0
2017-11-17	NQ	Futures	7450.27	7460.84	7410.04	7415.62	275846.0
2017-11-17	YM	Futures	24727.2	24752.5	24610.0	24621.6	125397.0
2017-11-17	CL	Futures	55.52	56.88	55.45	56.77	734878.0
2017-11-17	GC	Futures	1627.2	1651.0	1626.3	1649.7	387015.0
2017-11-17	ZN	Futures	123.039216	123.316504	123.008406	123.14705	1286280.0
2017-11-17	A6	Futures	0.78033	0.78249	0.77508	0.77827	99764.0
2017-11-17	AD	Futures	0.79809	0.80053	0.79361	0.79743	86217.0
2017-11-17	B	Futures	43.44	44.5	43.2	44.36	356735.0
2017-11-17	B6	Futures	1.3767	1.3837	1.374	1.3792	132678.0
2017-11-17	BR	Futures	0.23041	0.23132	0.22921	0.23117	2697.0
2017-11-17	BZ	Futures	43.08	44.09	42.83	43.97	30936.0
2017-11-17	C	Futures	1553.0	1555.0	1532.0	1543.0	7818.0
2017-11-17	CB	Futures	284.857	284.857	283.44	283.44	6.0
2017-11-17	CC	Futures	1600.0	1602.0	1576.0	1590.0	14109.0
2017-11-17	CNH	Futures	6.8152	6.8264	6.8084	6.8172	109.0
2017-11-17	CSC	Futures	3.377	3.377	3.36	3.365	72.0
2017-11-17	CT	Futures	81.29	82.31	81.29	81.96	10903.0
2017-11-17	DC	Futures	27.22	27.29	27.01	27.02	449.0
2017-11-17	DX	Futures	87.638	87.76	87.363	87.508	16907.0
2017-11-17	E1	Futures	1.23249	1.2402	1.232	1.2391	22939.0
2017-11-17	E6	Futures	1.34522	1.35093	1.34448	1.34813	196780.0
2017-11-17	E7	Futures	1.338	1.3438	1.3376	1.3411	3728.0
2017-11-17	EBM	Futures	171.27	171.54	170.73	171.27	18581.0
2017-11-17	ED	Futures	95.4673	95.4697	95.46	95.4624	295848.0
2017-11-17	ER	Futures	98.342	98.347	98.342	98.347	28226.0
2017-11-17	EW	Futures	1950.1	1959.6	1945.2	1956.0	14215.0
2017-11-17	FBON	Futures	125.72	125.88	125.65	125.74	106.0
2017-11-17	FBTP	Futures	112.45	112.55	112.09	112.36	92996.0
2017-11-17	FBTS	Futures	103.768	103.832	103.741	103.796	69795.0
2017-11-17	FCE	Futures	4780.4	4788.5	4748.2	4761.6	86866.0
2017-11-17	FDAX	Futures	13721.7	13754.8	13625.0	13654.9	82014.0
2017-11-17	FDXM	Futures	13609.5	13637.6	13509.4	13539.7	26598.0
2017-11-17	FESX	Futures	2906.6	2911.5	2885.4	2891.1	885869.0
2017-11-17	FGBL	Futures	150.48	150.66	150.25	150.59	435115.0
2017-11-17	FGBM	Futures	130.08	130.12	130.01	130.1	271534.0
2017-11-17	FGBS	Futures	112.537	112.547	112.522	112.547	128111.0
2017-11-17	FGBX	Futures	168.73	169.26	168.05	168.99	46815.0
2017-11-17	FMWO	Futures	6771.0	6775.8	6765.1	6766.3	279.0
2017-11-17	FOAT	Futures	138.66	138.86	138.45	138.8	96074.0
2017-11-17	FTDX	Futures	2503.0	2514.4	2490.0	2506.0	307.0
2017-11-17	FTI	Futures	501.38	501.43	496.37	498.27	33777.0
2017-11-17	FTUK	Futures	6412.6	6420.8	6377.0	6400.0	88855.0
2017-11-17	FVSA	Futures	346.27	350.96	336.88	343.92	19184.0
2017-11-17	FXXP	Futures	326.9	327.2	324.8	326.0	25046.0
2017-11-17	G	Futures	114.19	114.26	113.91	114.16	116083.0
2017-11-17	GF	Futures	332.948	332.948	327.219	328.03	5292.0
2017-11-17	GSCI	Futures	491.76	497.18	491.76	496.54	257.0
2017-11-17	HE	Futures	88.741	90.809	88.508	89.475	14899.0
2017-11-17	HG	Futures	3.6825	3.7115	3.662	3.7049	88405.0

> showing 50 of 108 rows — these rows as CSV

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