PREVIEW / futures_daily / 2018-08-31

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-31.parquet
  size:    10 KB
  rows:    113

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-31	ES	Futures	3147.51	3157.83	3140.72	3151.86	1323038.0
2018-08-31	NQ	Futures	8909.53	8956.75	8899.62	8932.27	346901.0
2018-08-31	YM	Futures	27368.6	27447.6	27286.4	27383.4	133440.0
2018-08-31	CL	Futures	72.97	73.29	72.54	72.7	419739.0
2018-08-31	GC	Futures	1528.9	1539.8	1526.1	1529.4	265106.0
2018-08-31	ZN	Futures	119.649926	119.836393	119.618848	119.72762	246954.0
2018-08-31	A6	Futures	0.74711	0.74742	0.73806	0.73847	132516.0
2018-08-31	AD	Futures	0.7808	0.7808	0.77396	0.77629	117833.0
2018-08-31	B	Futures	56.71	57.01	56.29	56.59	240820.0
2018-08-31	B6	Futures	1.3429	1.345	1.3362	1.3375	111984.0
2018-08-31	BR	Futures	0.18132	0.18582	0.18132	0.18582	7.0
2018-08-31	BTC	Futures	9939.8	10140.0	9818.2	10075.6	4632.0
2018-08-31	BZ	Futures	56.43	56.77	56.06	56.35	17690.0
2018-08-31	C	Futures	1541.0	1560.0	1531.0	1559.0	7539.0
2018-08-31	CB	Futures	270.366	270.366	266.761	268.203	17.0
2018-08-31	CC	Futures	1586.0	1637.0	1574.0	1631.0	24696.0
2018-08-31	CNH	Futures	6.9429	6.9581	6.9039	6.9174	224.0
2018-08-31	CSC	Futures	3.343	3.349	3.337	3.349	22.0
2018-08-31	CT	Futures	92.8	93.11	92.36	92.36	15.0
2018-08-31	DC	Futures	27.3	27.41	27.23	27.4	65.0
2018-08-31	DX	Futures	89.648	90.136	89.487	90.053	21915.0
2018-08-31	E1	Futures	1.23444	1.23958	1.23301	1.23408	34349.0
2018-08-31	E6	Futures	1.30603	1.30883	1.29692	1.29832	266773.0
2018-08-31	E7	Futures	1.2995	1.302	1.2904	1.2917	3946.0
2018-08-31	EBM	Futures	211.07	214.47	210.8	214.2	7625.0
2018-08-31	ED	Futures	95.0813	95.0886	95.0813	95.0838	149509.0
2018-08-31	ER	Futures	98.362	98.367	98.362	98.367	24296.0
2018-08-31	EW	Futures	2157.8	2169.9	2154.8	2165.7	12050.0
2018-08-31	FBON	Futures	128.59	128.88	128.5	128.57	625.0
2018-08-31	FBTP	Futures	104.27	104.56	103.65	103.84	257992.0
2018-08-31	FBTS	Futures	101.706	101.743	101.233	101.353	90121.0
2018-08-31	FCE	Futures	4929.3	4934.2	4853.6	4872.0	83061.0
2018-08-31	FDAX	Futures	13020.2	13031.7	12863.9	12909.3	88474.0
2018-08-31	FDXM	Futures	12848.1	12864.7	12699.5	12744.4	37701.0
2018-08-31	FESX	Futures	2858.1	2862.2	2819.6	2830.5	1058804.0
2018-08-31	FGBL	Futures	153.51	153.89	153.43	153.84	1041441.0
2018-08-31	FGBM	Futures	131.24	131.34	131.16	131.3	865783.0
2018-08-31	FGBS	Futures	112.668	112.688	112.643	112.678	734471.0
2018-08-31	FGBX	Futures	178.2	178.98	177.78	178.94	89355.0
2018-08-31	FMWO	Futures	7261.6	7261.6	7220.8	7233.7	725.0
2018-08-31	FOAT	Futures	141.02	141.2	140.86	141.15	216192.0
2018-08-31	FTDX	Futures	2944.1	2954.9	2936.3	2954.4	470.0
2018-08-31	FTI	Futures	521.5	521.64	516.58	517.88	23117.0
2018-08-31	FTUK	Futures	6663.3	6686.0	6604.5	6614.3	109386.0
2018-08-31	FVSA	Futures	270.01	280.47	269.14	276.98	40671.0
2018-08-31	FXXP	Futures	332.6	332.8	329.7	330.6	42862.0
2018-08-31	G	Futures	114.83	115.18	114.74	115.04	250205.0
2018-08-31	GF	Futures	312.405	313.29	310.585	310.897	978.0
2018-08-31	GSCI	Futures	527.98	528.94	527.87	528.09	85.0
2018-08-31	HE	Futures	67.435	70.178	67.3	68.282	29014.0

> showing 50 of 113 rows — these rows as CSV

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