PREVIEW / futures_daily / 2016-08-19

all futures daily files

  file:    by_date/futures_daily/2016/2016-08-19.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
2016-08-19	ES	Futures	2357.5	2358.31	2345.63	2355.62	1431860.0
2016-08-19	NQ	Futures	5667.36	5677.67	5640.25	5666.18	194623.0
2016-08-19	YM	Futures	19392.5	19403.0	19291.2	19365.4	112215.0
2016-08-19	CL	Futures	54.41	54.86	53.96	54.59	555574.0
2016-08-19	GC	Futures	1741.2	1742.2	1721.8	1727.2	185033.0
2016-08-19	ZN	Futures	127.894022	127.909113	127.320574	127.4413	987238.0
2016-08-19	A6	Futures	0.78138	0.78189	0.77253	0.77477	85763.0
2016-08-19	AD	Futures	0.80125	0.8013	0.79368	0.79588	58379.0
2016-08-19	ALI	Futures	2153.54	2157.0	2153.54	2157.0	2.0
2016-08-19	B	Futures	40.28	40.48	39.77	40.22	252338.0
2016-08-19	B6	Futures	1.388	1.3907	1.3735	1.3794	87580.0
2016-08-19	BFX	Futures	4028.3	4036.3	4028.3	4036.3	1.0
2016-08-19	BR	Futures	0.20436	0.20686	0.2038	0.20629	1921.0
2016-08-19	BZ	Futures	40.01	40.28	39.58	40.01	25452.0
2016-08-19	C	Futures	2667.0	2677.0	2637.0	2653.0	8012.0
2016-08-19	CB	Futures	266.97	266.97	262.574	262.867	54.0
2016-08-19	CC	Futures	2302.0	2308.0	2275.0	2292.0	20791.0
2016-08-19	CNH	Futures	7.2107	7.2107	7.2044	7.2044	6.0
2016-08-19	CSC	Futures	3.995	4.012	3.995	4.005	80.0
2016-08-19	CT	Futures	77.72	77.72	76.23	76.54	47.0
2016-08-19	DC	Futures	32.22	32.39	32.16	32.16	304.0
2016-08-19	DX	Futures	87.593	87.983	87.593	87.875	24047.0
2016-08-19	E1	Futures	1.31386	1.31461	1.30472	1.30672	25317.0
2016-08-19	E6	Futures	1.32316	1.32403	1.31745	1.31966	122551.0
2016-08-19	E7	Futures	1.3161	1.3167	1.3105	1.3127	2053.0
2016-08-19	EBM	Futures	196.97	196.97	195.17	195.77	7386.0
2016-08-19	ED	Futures	95.6509	95.6509	95.6267	95.6292	142229.0
2016-08-19	ER	Futures	98.308	98.308	98.303	98.303	38404.0
2016-08-19	EW	Futures	1652.3	1655.9	1645.1	1654.6	11586.0
2016-08-19	FBON	Futures	124.99	125.0	124.61	124.7	364.0
2016-08-19	FBTP	Futures	111.01	111.08	110.47	110.57	54188.0
2016-08-19	FBTS	Futures	101.347	101.347	101.32	101.329	8157.0
2016-08-19	FCE	Futures	3879.4	3880.7	3820.0	3843.2	77385.0
2016-08-19	FDAX	Futures	11312.9	11314.5	11160.2	11224.5	81812.0
2016-08-19	FDIV	Futures	137.01	137.52	137.01	137.52	30.0
2016-08-19	FDXM	Futures	11024.9	11029.1	10878.7	10940.9	21354.0
2016-08-19	FESX	Futures	2347.8	2348.6	2308.7	2325.1	847011.0
2016-08-19	FGBL	Futures	150.68	150.8	150.05	150.24	414295.0
2016-08-19	FGBM	Futures	128.93	128.94	128.74	128.79	205391.0
2016-08-19	FGBS	Futures	111.867	111.872	111.847	111.852	120822.0
2016-08-19	FGBX	Futures	189.74	190.03	187.26	187.83	18894.0
2016-08-19	FMWO	Futures	5781.7	5789.0	5770.8	5789.0	263.0
2016-08-19	FOAT	Futures	138.67	138.75	138.04	138.21	53856.0
2016-08-19	FTDX	Futures	1654.9	1654.9	1644.7	1649.1	131.0
2016-08-19	FTI	Futures	407.04	407.54	402.8	404.51	27729.0
2016-08-19	FTUK	Futures	5739.6	5739.6	5705.4	5719.5	81265.0
2016-08-19	FVSA	Futures	1947.19	1990.46	1947.19	1981.8	10642.0
2016-08-19	FXXP	Futures	277.1	277.3	274.0	275.4	23232.0
2016-08-19	G	Futures	117.23	117.27	116.5	116.64	116685.0
2016-08-19	GF	Futures	288.002	290.215	286.342	289.461	2705.0

> showing 50 of 109 rows — these rows as CSV

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