PREVIEW / futures_daily / 2018-08-29

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-29.parquet
  size:    10 KB
  rows:    114

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-08-29	ES	Futures	3150.23	3168.69	3146.97	3165.7	1113797.0
2018-08-29	NQ	Futures	8838.7	8947.71	8838.7	8941.01	311623.0
2018-08-29	YM	Futures	27492.9	27590.9	27448.7	27550.9	104664.0
2018-08-29	CL	Futures	71.39	72.66	71.21	72.4	497095.0
2018-08-29	GC	Futures	1529.3	1538.3	1529.3	1535.5	241896.0
2018-08-29	ZN	Futures	119.463458	119.58777	119.308069	119.43238	2379987.0
2018-08-29	A6	Futures	0.75421	0.75596	0.74825	0.75082	107384.0
2018-08-29	AD	Futures	0.78338	0.78526	0.78151	0.78445	76903.0
2018-08-29	B	Futures	55.64	56.67	55.4	56.46	242175.0
2018-08-29	B6	Futures	1.3287	1.3457	1.3263	1.3443	160554.0
2018-08-29	BFX	Futures	4461.0	4461.0	4449.9	4449.9	48.0
2018-08-29	BR	Futures	0.18258	0.18376	0.18186	0.18304	1017.0
2018-08-29	BTC	Futures	10097.1	10154.3	9854.0	10004.1	853.0
2018-08-29	BZ	Futures	55.35	56.41	55.16	56.22	13427.0
2018-08-29	C	Futures	1569.0	1574.0	1556.0	1566.0	2698.0
2018-08-29	CC	Futures	1617.0	1647.0	1612.0	1640.0	12461.0
2018-08-29	CNH	Futures	6.8813	6.9072	6.8778	6.8943	394.0
2018-08-29	CSC	Futures	3.325	3.341	3.325	3.325	22.0
2018-08-29	CT	Futures	94.23	94.23	93.1	93.1	4.0
2018-08-29	DC	Futures	27.3	27.48	27.21	27.3	84.0
2018-08-29	DX	Futures	89.624	89.842	89.444	89.522	18772.0
2018-08-29	E1	Futures	1.22572	1.2336	1.2244	1.23205	30498.0
2018-08-29	E6	Futures	1.30939	1.31146	1.30491	1.31011	247248.0
2018-08-29	E7	Futures	1.3027	1.3047	1.2983	1.3035	2970.0
2018-08-29	EBM	Futures	206.62	213.68	206.62	212.11	10859.0
2018-08-29	ED	Futures	95.0789	95.0862	95.0789	95.0838	240526.0
2018-08-29	ER	Futures	98.367	98.372	98.362	98.367	53911.0
2018-08-29	EW	Futures	2167.7	2175.2	2158.6	2172.3	9712.0
2018-08-29	FBON	Futures	128.81	128.84	128.51	128.61	578.0
2018-08-29	FBTP	Futures	103.95	104.77	103.95	104.66	88856.0
2018-08-29	FBTS	Futures	101.687	101.965	101.659	101.928	77510.0
2018-08-29	FCE	Futures	4953.2	4965.8	4933.8	4956.8	43222.0
2018-08-29	FDAX	Futures	13114.8	13141.4	13058.8	13129.4	57341.0
2018-08-29	FDXM	Futures	12948.3	12974.1	12891.5	12961.7	26727.0
2018-08-29	FESX	Futures	2883.1	2889.0	2869.8	2886.5	598361.0
2018-08-29	FGBL	Futures	153.23	153.29	152.74	152.82	708362.0
2018-08-29	FGBM	Futures	131.09	131.11	130.91	130.95	643776.0
2018-08-29	FGBS	Futures	112.633	112.643	112.608	112.623	401527.0
2018-08-29	FGBX	Futures	177.18	177.44	175.97	176.19	46579.0
2018-08-29	FMWO	Futures	7280.2	7309.4	7265.1	7304.7	1204.0
2018-08-29	FOAT	Futures	140.83	140.89	140.41	140.51	160184.0
2018-08-29	FTDX	Futures	2973.0	2982.4	2962.3	2980.4	271.0
2018-08-29	FTI	Futures	523.03	524.93	521.04	524.1	16425.0
2018-08-29	FTUK	Futures	6786.2	6807.2	6715.8	6733.2	100727.0
2018-08-29	FVSA	Futures	253.47	258.69	250.85	254.34	29552.0
2018-08-29	FXXP	Futures	333.9	334.8	332.6	334.4	37117.0
2018-08-29	G	Futures	114.96	115.02	114.34	114.44	288258.0
2018-08-29	GF	Futures	310.221	310.689	308.297	310.325	1626.0
2018-08-29	GSCI	Futures	524.37	528.21	523.47	527.25	475.0
2018-08-29	HE	Futures	70.076	72.175	69.399	69.805	24973.0

> showing 50 of 114 rows — these rows as CSV

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