PREVIEW / futures_daily / 2017-07-20

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-20.parquet
  size:    9 KB
  rows:    111

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-07-20	ES	Futures	2685.54	2691.24	2679.56	2685.81	1106684.0
2017-07-20	NQ	Futures	6958.62	6980.95	6932.17	6965.38	265354.0
2017-07-20	YM	Futures	22813.5	22858.9	22754.3	22813.5	99138.0
2017-07-20	CL	Futures	48.62	49.11	48.15	48.26	720621.0
2017-07-20	GC	Futures	1583.7	1592.1	1576.1	1590.0	269021.0
2017-07-20	ZN	Futures	124.119249	124.365487	124.073079	124.165419	1162716.0
2017-07-20	A6	Futures	0.81656	0.82026	0.81081	0.81718	132454.0
2017-07-20	AD	Futures	0.80787	0.81174	0.80528	0.80884	80729.0
2017-07-20	ALI	Futures	2535.32	2535.32	2535.32	2535.32	0.0
2017-07-20	B	Futures	35.1	35.49	34.78	34.86	315337.0
2017-07-20	B6	Futures	1.3638	1.3645	1.354	1.3585	130856.0
2017-07-20	BFX	Futures	4712.7	4712.7	4698.2	4698.2	3.0
2017-07-20	BR	Futures	0.23384	0.23566	0.23384	0.23514	310.0
2017-07-20	BZ	Futures	34.84	35.25	34.56	34.63	26566.0
2017-07-20	C	Futures	1553.0	1571.0	1547.0	1560.0	8710.0
2017-07-20	CB	Futures	326.002	326.002	324.755	324.755	2.0
2017-07-20	CC	Futures	1477.0	1498.0	1468.0	1485.0	22302.0
2017-07-20	CNH	Futures	7.0173	7.02	7.0018	7.0018	30.0
2017-07-20	CSC	Futures	3.495	3.501	3.452	3.456	43.0
2017-07-20	CT	Futures	81.14	81.43	80.96	81.17	10.0
2017-07-20	DC	Futures	29.23	29.37	28.92	28.95	287.0
2017-07-20	DX	Futures	88.297	88.689	87.671	87.883	48227.0
2017-07-20	E1	Futures	1.29028	1.29851	1.27567	1.29532	48986.0
2017-07-20	E6	Futures	1.32372	1.33982	1.31914	1.33581	368819.0
2017-07-20	E7	Futures	1.3168	1.3326	1.3122	1.3288	8797.0
2017-07-20	EBM	Futures	189.84	190.68	189.29	189.57	15895.0
2017-07-20	ED	Futures	95.5886	95.5886	95.5789	95.5789	203111.0
2017-07-20	ER	Futures	98.342	98.342	98.337	98.342	43151.0
2017-07-20	EW	Futures	1890.6	1894.5	1885.3	1888.9	9339.0
2017-07-20	FBON	Futures	123.79	124.62	123.67	124.44	791.0
2017-07-20	FBTP	Futures	107.28	108.37	107.18	108.04	138186.0
2017-07-20	FBTS	Futures	102.763	102.881	102.754	102.836	40968.0
2017-07-20	FCE	Futures	4696.2	4715.1	4646.9	4667.1	126111.0
2017-07-20	FDAX	Futures	13154.0	13232.0	13036.1	13079.3	94422.0
2017-07-20	FDXM	Futures	13069.9	13150.5	12955.9	12998.8	27598.0
2017-07-20	FESX	Futures	2859.4	2877.3	2839.8	2848.7	1071183.0
2017-07-20	FEU3	Futures	99.016	99.016	99.016	99.016	50.0
2017-07-20	FGBL	Futures	147.01	147.29	146.76	147.1	908189.0
2017-07-20	FGBM	Futures	128.52	128.79	128.44	128.61	570678.0
2017-07-20	FGBS	Futures	112.177	112.232	112.151	112.172	402931.0
2017-07-20	FGBX	Futures	164.44	164.65	163.39	163.92	47772.0
2017-07-20	FMWO	Futures	6549.6	6557.9	6538.8	6551.9	3247.0
2017-07-20	FOAT	Futures	134.78	135.26	134.68	135.07	144250.0
2017-07-20	FTDX	Futures	2299.2	2299.2	2279.7	2293.2	141.0
2017-07-20	FTI	Futures	482.28	486.63	481.73	483.3	19299.0
2017-07-20	FTUK	Futures	6370.5	6429.7	6369.2	6417.6	96149.0
2017-07-20	FVSA	Futures	449.43	455.37	433.12	444.98	23747.0
2017-07-20	FXXP	Futures	328.2	328.9	325.0	325.9	45285.0
2017-07-20	G	Futures	114.71	114.83	114.46	114.59	141395.0
2017-07-20	GF	Futures	339.485	340.199	333.723	334.272	4491.0

> showing 50 of 111 rows — these rows as CSV

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