PREVIEW / futures_daily / 2017-06-29

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-29.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-06-29	ES	Futures	2654.02	2657.28	2610.82	2630.11	2337789.0
2017-06-29	NQ	Futures	6778.46	6789.93	6584.21	6645.33	604720.0
2017-06-29	YM	Futures	22650.7	22676.0	22345.2	22468.8	239968.0
2017-06-29	CL	Futures	46.36	46.93	46.11	46.4	768946.0
2017-06-29	GC	Futures	1595.2	1599.8	1582.6	1590.4	277752.0
2017-06-29	ZN	Futures	124.273148	124.334707	123.688333	123.919181	1915901.0
2017-06-29	A6	Futures	0.78421	0.78883	0.78359	0.7879	102550.0
2017-06-29	AD	Futures	0.78128	0.78433	0.78082	0.78295	98760.0
2017-06-29	ALI	Futures	2527.71	2527.71	2527.71	2527.71	0.0
2017-06-29	B	Futures	33.66	34.13	33.47	33.68	401760.0
2017-06-29	B6	Futures	1.3545	1.3635	1.3543	1.361	129534.0
2017-06-29	BR	Futures	0.2243	0.2243	0.22115	0.22189	874.0
2017-06-29	BZ	Futures	33.49	33.9	33.27	33.46	27609.0
2017-06-29	C	Futures	1515.0	1527.0	1500.0	1503.0	6698.0
2017-06-29	CB	Futures	324.786	324.786	324.481	324.481	3.0
2017-06-29	CC	Futures	1433.0	1441.0	1395.0	1413.0	19631.0
2017-06-29	CNH	Futures	7.0647	7.0647	7.0564	7.0647	8.0
2017-06-29	CSC	Futures	3.499	3.499	3.476	3.478	192.0
2017-06-29	CT	Futures	80.65	80.89	80.37	80.59	6.0
2017-06-29	DC	Futures	29.13	29.13	28.81	28.85	308.0
2017-06-29	DX	Futures	89.427	89.436	88.96	89.05	22606.0
2017-06-29	E1	Futures	1.28623	1.29163	1.28586	1.29041	29435.0
2017-06-29	E6	Futures	1.309	1.31679	1.3086	1.31524	265810.0
2017-06-29	E7	Futures	1.3019	1.3097	1.3017	1.3084	5329.0
2017-06-29	EBM	Futures	189.57	193.46	189.29	192.91	22087.0
2017-06-29	ED	Futures	95.5692	95.5789	95.5596	95.5741	248364.0
2017-06-29	ER	Futures	98.328	98.337	98.328	98.332	118491.0
2017-06-29	EW	Futures	1868.5	1871.7	1837.3	1853.5	28476.0
2017-06-29	FBON	Futures	124.65	124.66	123.72	123.75	1061.0
2017-06-29	FBTP	Futures	108.89	108.89	107.45	107.49	115988.0
2017-06-29	FBTS	Futures	102.799	102.799	102.663	102.69	61624.0
2017-06-29	FCE	Futures	4751.5	4760.0	4612.6	4642.4	143957.0
2017-06-29	FDAX	Futures	13383.1	13403.6	12994.5	13060.3	135896.0
2017-06-29	FDXM	Futures	13294.9	13320.0	12916.1	12980.0	46511.0
2017-06-29	FESX	Futures	2892.8	2896.1	2806.3	2825.1	1503527.0
2017-06-29	FEU3	Futures	99.006	99.006	99.001	99.006	501.0
2017-06-29	FGBL	Futures	148.35	148.36	147.22	147.32	1049947.0
2017-06-29	FGBM	Futures	128.88	128.88	128.49	128.52	600068.0
2017-06-29	FGBS	Futures	112.066	112.081	112.031	112.046	512651.0
2017-06-29	FGBX	Futures	168.18	168.26	165.72	166.06	60405.0
2017-06-29	FMWO	Futures	6475.7	6475.7	6400.7	6412.6	1201.0
2017-06-29	FOAT	Futures	135.86	135.88	134.91	134.99	135725.0
2017-06-29	FTDX	Futures	2232.1	2232.1	2157.0	2174.0	337.0
2017-06-29	FTI	Futures	478.52	478.8	465.69	468.55	43761.0
2017-06-29	FTUK	Futures	6362.3	6389.5	6261.6	6302.7	117718.0
2017-06-29	FVSA	Futures	472.34	558.94	467.62	518.0	33761.0
2017-06-29	FXXP	Futures	328.8	329.0	321.5	322.7	68229.0
2017-06-29	G	Futures	114.59	114.64	113.93	114.14	289802.0
2017-06-29	GF	Futures	321.924	324.668	318.905	323.076	4412.0
2017-06-29	GSCI	Futures	445.31	446.77	443.54	443.66	76.0

> showing 50 of 109 rows — these rows as CSV

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