PREVIEW / futures_daily / 2018-02-05

all futures daily files

  file:    by_date/futures_daily/2018/2018-02-05.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
2018-02-05	ES	Futures	2996.52	3003.05	2821.27	2834.31	4009557.0
2018-02-05	NQ	Futures	7908.1	7979.83	7481.2	7529.81	931677.0
2018-02-05	YM	Futures	26819.7	26868.2	24984.7	25245.2	596827.0
2018-02-05	CL	Futures	65.08	65.38	63.4	64.13	891063.0
2018-02-05	GC	Futures	1704.7	1717.8	1700.9	1707.2	305677.0
2018-02-05	ZN	Futures	119.275599	120.509697	119.028779	119.72296	2851851.0
2018-02-05	A6	Futures	0.81273	0.81808	0.80995	0.81262	172991.0
2018-02-05	AD	Futures	0.8161	0.81935	0.8097	0.81209	100688.0
2018-02-05	B	Futures	48.9	49.13	48.01	48.52	335637.0
2018-02-05	B6	Futures	1.4676	1.4741	1.4535	1.4585	140889.0
2018-02-05	BR	Futures	0.23435	0.23511	0.23142	0.2334	5794.0
2018-02-05	BTC	Futures	10806.7	10819.8	8939.5	9447.0	2186.0
2018-02-05	BZ	Futures	48.3	48.48	47.45	47.89	32399.0
2018-02-05	C	Futures	1327.0	1346.0	1325.0	1333.0	17786.0
2018-02-05	CB	Futures	265.124	266.051	265.001	265.001	52.0
2018-02-05	CC	Futures	1526.0	1538.0	1514.0	1522.0	31529.0
2018-02-05	CNH	Futures	6.4557	6.4599	6.4245	6.4388	48.0
2018-02-05	CSC	Futures	3.174	3.21	3.169	3.206	73.0
2018-02-05	CT	Futures	90.35	91.0	89.29	89.43	25997.0
2018-02-05	DC	Futures	25.26	25.48	25.04	25.41	555.0
2018-02-05	DX	Futures	83.754	84.125	83.463	83.96	37140.0
2018-02-05	E1	Futures	1.3063	1.31103	1.29865	1.30205	35731.0
2018-02-05	E6	Futures	1.41312	1.41799	1.40513	1.40932	283581.0
2018-02-05	E7	Futures	1.4057	1.4109	1.398	1.4023	4886.0
2018-02-05	EBM	Futures	168.57	169.65	168.3	169.11	9684.0
2018-02-05	ED	Futures	95.2776	95.3067	95.2728	95.2825	473071.0
2018-02-05	ER	Futures	98.337	98.342	98.332	98.337	133888.0
2018-02-05	EW	Futures	2031.5	2031.9	1911.5	1958.9	41563.0
2018-02-05	FBON	Futures	126.28	126.69	126.18	126.44	389.0
2018-02-05	FBTP	Futures	110.63	111.28	110.47	110.88	97278.0
2018-02-05	FBTS	Futures	103.595	103.668	103.576	103.65	41330.0
2018-02-05	FCE	Futures	4732.8	4760.0	4547.3	4711.9	109020.0
2018-02-05	FDAX	Futures	13083.6	13224.7	12592.9	13162.9	139221.0
2018-02-05	FDXM	Futures	13111.0	13248.2	12612.1	13185.3	64695.0
2018-02-05	FESX	Futures	2845.3	2862.5	2738.3	2840.4	1802157.0
2018-02-05	FGBL	Futures	146.13	147.64	146.08	146.52	871650.0
2018-02-05	FGBM	Futures	128.09	128.77	128.09	128.28	756926.0
2018-02-05	FGBS	Futures	112.246	112.347	112.241	112.261	374931.0
2018-02-05	FGBX	Futures	163.27	166.62	162.96	163.95	80421.0
2018-02-05	FMWO	Futures	7119.6	7130.1	6858.1	7097.4	7285.0
2018-02-05	FOAT	Futures	135.27	135.95	135.27	135.62	108932.0
2018-02-05	FTDX	Futures	2571.3	2571.3	2453.6	2550.3	288.0
2018-02-05	FTI	Futures	504.58	506.02	485.76	502.77	37883.0
2018-02-05	FTUK	Futures	6353.1	6406.0	6160.9	6361.0	181118.0
2018-02-05	FVSA	Futures	324.33	430.15	297.66	303.69	58382.0
2018-02-05	FXXP	Futures	326.1	327.6	314.4	324.5	66564.0
2018-02-05	G	Futures	111.9	112.18	111.77	111.96	204033.0
2018-02-05	GF	Futures	331.152	333.677	325.113	328.681	7700.0
2018-02-05	GSCI	Futures	524.22	524.39	518.73	520.17	629.0
2018-02-05	HE	Futures	94.572	94.989	92.806	94.155	18592.0

> showing 50 of 111 rows — these rows as CSV

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