PREVIEW / futures_daily / 2019-09-05

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-05.parquet
  size:    10 KB
  rows:    120

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
2019-09-05	ES	Futures	3170.27	3222.6	3168.65	3206.96	1669999.0
2019-09-05	NQ	Futures	8890.53	9080.21	8885.06	9044.23	478413.0
2019-09-05	YM	Futures	27691.3	28186.9	27673.4	28036.7	222265.0
2019-09-05	CL	Futures	57.46	59.32	57.26	57.82	712466.0
2019-09-05	GC	Futures	1926.1	1926.7	1868.0	1881.8	606398.0
2019-09-05	ZN	Futures	130.924196	130.955302	129.851047	130.053234	43583.0
2019-09-05	A6	Futures	0.69956	0.70296	0.69925	0.70152	93474.0
2019-09-05	AD	Futures	0.76262	0.76423	0.76111	0.76171	91448.0
2019-09-05	ALI	Futures	2160.21	2178.73	2160.21	2172.96	108.0
2019-09-05	B	Futures	46.72	48.19	46.53	47.07	292058.0
2019-09-05	B6	Futures	1.2516	1.2615	1.2469	1.2581	156926.0
2019-09-05	BR	Futures	0.1955	0.1972	0.19522	0.19598	37.0
2019-09-05	BTC	Futures	15416.0	15444.6	15044.6	15180.3	3606.0
2019-09-05	BZ	Futures	46.04	47.47	45.85	46.38	37813.0
2019-09-05	C	Futures	1579.0	1579.0	1562.0	1563.0	1588.0
2019-09-05	CB	Futures	264.339	264.339	262.361	262.361	10.0
2019-09-05	CC	Futures	1495.0	1498.0	1463.0	1473.0	20897.0
2019-09-05	CNH	Futures	7.1501	7.1521	7.1291	7.1398	1112.0
2019-09-05	CSC	Futures	3.0	3.011	2.998	2.998	25.0
2019-09-05	CT	Futures	58.06	58.7	58.06	58.42	23.0
2019-09-05	DC	Futures	25.4	25.46	25.26	25.44	110.0
2019-09-05	DX	Futures	94.692	94.851	94.389	94.723	16281.0
2019-09-05	E1	Futures	1.18371	1.18383	1.17548	1.17606	28815.0
2019-09-05	E6	Futures	1.20482	1.21005	1.20253	1.20465	225438.0
2019-09-05	E7	Futures	1.1985	1.2036	1.1963	1.1984	3939.0
2019-09-05	EBM	Futures	182.23	183.33	181.96	182.78	14969.0
2019-09-05	ED	Futures	95.3817	95.3817	95.3233	95.3428	398183.0
2019-09-05	ER	Futures	98.553	98.553	98.538	98.538	91540.0
2019-09-05	EW	Futures	1975.8	2017.5	1975.3	2009.0	14961.0
2019-09-05	FBON	Futures	145.86	146.04	144.87	145.09	1033.0
2019-09-05	FBTP	Futures	132.29	132.64	130.85	131.31	150472.0
2019-09-05	FBTS	Futures	108.539	108.732	108.442	108.548	157033.0
2019-09-05	FCE	Futures	5054.9	5078.5	5035.4	5066.7	90549.0
2019-09-05	FDAX	Futures	12692.2	12808.0	12686.4	12769.0	92326.0
2019-09-05	FDIV	Futures	145.02	145.02	144.7	144.88	95.0
2019-09-05	FDXM	Futures	12529.1	12648.7	12521.8	12611.7	32463.0
2019-09-05	FESX	Futures	3018.6	3045.7	3017.8	3040.5	1074116.0
2019-09-05	FGBL	Futures	169.75	169.79	168.22	168.57	1087489.0
2019-09-05	FGBM	Futures	136.01	136.11	135.61	135.72	659745.0
2019-09-05	FGBS	Futures	113.323	113.353	113.217	113.242	462239.0
2019-09-05	FGBX	Futures	229.42	229.42	222.09	223.27	142796.0
2019-09-05	FMWO	Futures	7286.4	7341.8	7277.1	7326.8	3866.0
2019-09-05	FOAT	Futures	156.03	156.43	154.87	155.29	293379.0
2019-09-05	FTDX	Futures	2792.5	2809.8	2779.7	2809.8	60.0
2019-09-05	FTI	Futures	537.74	538.6	535.7	538.6	27414.0
2019-09-05	FTUK	Futures	6737.7	6789.9	6695.2	6711.8	104638.0
2019-09-05	FVSA	Futures	208.82	210.07	200.67	203.17	29975.0
2019-09-05	FXXP	Futures	346.3	346.6	344.5	346.0	62117.0
2019-09-05	G	Futures	122.54	122.87	121.37	121.81	278596.0
2019-09-05	GF	Futures	275.324	275.629	270.847	273.493	1484.0

> showing 50 of 120 rows — these rows as CSV

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