PREVIEW / futures_daily / 2016-08-17

all futures daily files

  file:    by_date/futures_daily/2016/2016-08-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
2016-08-17	ES	Futures	2351.03	2355.89	2338.07	2353.46	1702425.0
2016-08-17	NQ	Futures	5658.81	5669.42	5624.93	5662.64	197778.0
2016-08-17	YM	Futures	19359.1	19385.2	19264.0	19366.4	127972.0
2016-08-17	CL	Futures	52.26	53.0	51.68	52.82	397540.0
2016-08-17	GC	Futures	1733.7	1740.8	1719.9	1730.5	169160.0
2016-08-17	ZN	Futures	127.486572	127.863841	127.320574	127.592207	1112006.0
2016-08-17	A6	Futures	0.7825	0.78372	0.77345	0.77772	108091.0
2016-08-17	AD	Futures	0.79588	0.79767	0.79229	0.79664	64906.0
2016-08-17	ALI	Futures	2173.06	2174.63	2173.06	2174.63	7.0
2016-08-17	B	Futures	38.63	39.46	38.37	39.4	377399.0
2016-08-17	B6	Futures	1.3759	1.3804	1.3687	1.3758	86311.0
2016-08-17	BFX	Futures	4045.0	4045.0	4028.3	4028.3	21.0
2016-08-17	BR	Futures	0.20676	0.20699	0.20516	0.20673	692.0
2016-08-17	BZ	Futures	38.52	39.31	38.18	39.2	39930.0
2016-08-17	C	Futures	2648.0	2664.0	2632.0	2662.0	4226.0
2016-08-17	CB	Futures	270.809	270.809	266.823	266.823	75.0
2016-08-17	CC	Futures	2266.0	2284.0	2251.0	2277.0	20144.0
2016-08-17	CNH	Futures	7.179	7.1883	7.179	7.1827	6.0
2016-08-17	CSC	Futures	3.889	3.952	3.881	3.942	75.0
2016-08-17	CT	Futures	77.72	78.12	77.29	77.44	59.0
2016-08-17	DC	Futures	31.37	31.95	31.28	31.89	494.0
2016-08-17	DX	Futures	88.132	88.434	87.881	88.067	22949.0
2016-08-17	E1	Futures	1.30434	1.30685	1.29846	1.30422	20503.0
2016-08-17	E6	Futures	1.31437	1.31908	1.31012	1.316	139701.0
2016-08-17	E7	Futures	1.3072	1.312	1.3033	1.309	2806.0
2016-08-17	EBM	Futures	196.37	197.57	196.07	196.37	3781.0
2016-08-17	ED	Futures	95.6605	95.6605	95.6243	95.6412	388529.0
2016-08-17	ER	Futures	98.308	98.308	98.303	98.303	11502.0
2016-08-17	EW	Futures	1648.7	1650.4	1632.3	1642.2	14037.0
2016-08-17	FBON	Futures	124.58	124.64	124.22	124.51	52.0
2016-08-17	FBTP	Futures	110.7	110.89	110.44	110.64	64483.0
2016-08-17	FBTS	Futures	101.338	101.356	101.32	101.329	12849.0
2016-08-17	FCE	Futures	3894.7	3914.4	3856.3	3858.9	139262.0
2016-08-17	FDAX	Futures	11343.7	11389.5	11186.2	11215.5	90700.0
2016-08-17	FDXM	Futures	11058.1	11105.8	10903.6	10932.1	22257.0
2016-08-17	FESX	Futures	2358.8	2370.6	2331.4	2335.3	936484.0
2016-08-17	FGBL	Futures	150.11	150.55	149.95	150.22	458737.0
2016-08-17	FGBM	Futures	128.79	128.85	128.75	128.78	259951.0
2016-08-17	FGBS	Futures	111.862	111.872	111.852	111.862	105307.0
2016-08-17	FGBX	Futures	187.21	188.92	186.8	187.85	19885.0
2016-08-17	FMWO	Futures	5790.2	5790.2	5763.5	5763.5	77.0
2016-08-17	FOAT	Futures	138.07	138.38	138.01	138.26	73158.0
2016-08-17	FTDX	Futures	1660.7	1660.7	1635.6	1635.6	232.0
2016-08-17	FTI	Futures	405.87	407.22	402.03	403.25	28046.0
2016-08-17	FTUK	Futures	5745.8	5765.4	5705.8	5719.1	94044.0
2016-08-17	FVSA	Futures	1934.21	1999.11	1934.21	1994.79	10248.0
2016-08-17	FXXP	Futures	278.2	278.8	274.9	275.4	24772.0
2016-08-17	G	Futures	117.0	117.28	116.63	117.08	178415.0
2016-08-17	GF	Futures	290.92	293.687	290.92	291.624	2585.0
2016-08-17	GSCI	Futures	512.56	518.95	512.56	518.52	36.0

> showing 50 of 108 rows — these rows as CSV

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