PREVIEW / futures_daily / 2016-08-18

all futures daily files

  file:    by_date/futures_daily/2016/2016-08-18.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-18	ES	Futures	2354.54	2358.58	2349.68	2357.5	1201115.0
2016-08-18	NQ	Futures	5667.65	5674.43	5649.38	5667.95	149002.0
2016-08-18	YM	Futures	19377.9	19401.9	19328.8	19391.5	92435.0
2016-08-18	CL	Futures	52.88	54.52	52.55	54.34	474898.0
2016-08-18	GC	Futures	1736.9	1746.8	1733.6	1741.3	170557.0
2016-08-18	ZN	Futures	127.697843	127.954385	127.562026	127.84875	884807.0
2016-08-18	A6	Futures	0.77853	0.78505	0.77752	0.78199	92293.0
2016-08-18	AD	Futures	0.79659	0.80191	0.79613	0.8015	56199.0
2016-08-18	ALI	Futures	2171.17	2173.69	2171.17	2173.69	2.0
2016-08-18	B	Futures	39.33	40.35	39.14	40.22	268834.0
2016-08-18	B6	Futures	1.3755	1.3894	1.3751	1.3867	101765.0
2016-08-18	BFX	Futures	4050.7	4054.8	4050.7	4054.8	11.0
2016-08-18	BR	Futures	0.20666	0.20699	0.20406	0.20489	1623.0
2016-08-18	BZ	Futures	39.1	40.15	38.94	40.02	28379.0
2016-08-18	C	Futures	2667.0	2675.0	2648.0	2675.0	3783.0
2016-08-18	CB	Futures	266.384	269.49	266.091	267.263	38.0
2016-08-18	CC	Futures	2292.0	2307.0	2283.0	2302.0	22700.0
2016-08-18	CNH	Futures	7.1811	7.1811	7.1798	7.1798	3.0
2016-08-18	CSC	Futures	3.959	4.014	3.955	3.995	98.0
2016-08-18	CT	Futures	77.45	78.79	77.45	77.6	23.0
2016-08-18	DC	Futures	31.91	32.32	31.89	32.22	511.0
2016-08-18	DX	Futures	87.983	88.011	87.472	87.553	22338.0
2016-08-18	E1	Futures	1.30347	1.31486	1.30321	1.31461	24174.0
2016-08-18	E6	Futures	1.31565	1.32484	1.31553	1.32333	159275.0
2016-08-18	E7	Futures	1.309	1.3177	1.3086	1.3163	3181.0
2016-08-18	EBM	Futures	196.97	197.57	196.07	196.67	5292.0
2016-08-18	ED	Futures	95.646	95.6581	95.6436	95.6509	183913.0
2016-08-18	ER	Futures	98.303	98.308	98.303	98.308	18363.0
2016-08-18	EW	Futures	1643.5	1654.4	1639.4	1653.9	14365.0
2016-08-18	FBON	Futures	124.77	125.05	124.61	124.97	259.0
2016-08-18	FBTP	Futures	110.82	111.09	110.67	110.97	48677.0
2016-08-18	FBTS	Futures	101.338	101.347	101.329	101.338	6824.0
2016-08-18	FCE	Futures	3886.9	3889.5	3854.5	3875.5	64290.0
2016-08-18	FDAX	Futures	11294.8	11308.1	11222.9	11280.4	58851.0
2016-08-18	FDXM	Futures	11013.5	11022.9	10938.8	10995.4	14974.0
2016-08-18	FESX	Futures	2351.8	2353.3	2330.6	2343.1	684974.0
2016-08-18	FGBL	Futures	150.48	150.88	150.41	150.68	400111.0
2016-08-18	FGBM	Futures	128.85	128.94	128.81	128.9	272614.0
2016-08-18	FGBS	Futures	111.872	111.877	111.852	111.862	105291.0
2016-08-18	FGBX	Futures	188.51	190.36	188.51	189.58	20725.0
2016-08-18	FMWO	Futures	5793.9	5808.5	5791.4	5808.5	415.0
2016-08-18	FOAT	Futures	138.48	138.74	138.43	138.68	55167.0
2016-08-18	FTDX	Futures	1645.2	1658.2	1645.2	1654.4	83.0
2016-08-18	FTI	Futures	405.73	407.13	405.46	406.95	13653.0
2016-08-18	FTUK	Futures	5751.7	5756.3	5712.9	5728.3	89569.0
2016-08-18	FVSA	Futures	1951.51	1968.82	1942.86	1951.51	11127.0
2016-08-18	FXXP	Futures	276.7	277.5	276.2	277.1	18772.0
2016-08-18	G	Futures	117.34	117.48	116.96	117.12	113382.0
2016-08-18	GF	Futures	291.875	292.278	287.65	288.052	3227.0
2016-08-18	GSCI	Futures	518.8	526.82	518.8	525.68	129.0

> showing 50 of 108 rows — these rows as CSV

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