PREVIEW / futures_daily / 2018-08-07

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-07.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-07	ES	Futures	3094.56	3110.31	3093.48	3105.97	780222.0
2018-08-07	NQ	Futures	8677.23	8728.82	8674.6	8717.74	260630.0
2018-08-07	YM	Futures	26840.7	27038.8	26827.0	26974.5	108087.0
2018-08-07	CL	Futures	71.29	72.25	71.19	71.57	485027.0
2018-08-07	GC	Futures	1540.9	1551.7	1540.7	1544.1	205380.0
2018-08-07	ZN	Futures	119.043907	119.090523	118.748667	118.810822	840015.0
2018-08-07	A6	Futures	0.75977	0.76532	0.75946	0.76357	91156.0
2018-08-07	AD	Futures	0.77933	0.78186	0.77513	0.77568	68339.0
2018-08-07	B	Futures	53.66	54.6	53.63	54.42	228992.0
2018-08-07	B6	Futures	1.3375	1.3405	1.3355	1.3366	82365.0
2018-08-07	BR	Futures	0.20414	0.2051	0.20155	0.20216	4640.0
2018-08-07	BTC	Futures	9751.4	10193.0	9722.9	9957.9	5037.0
2018-08-07	BZ	Futures	53.62	54.52	53.58	54.34	18289.0
2018-08-07	C	Futures	1507.0	1509.0	1466.0	1470.0	7031.0
2018-08-07	CB	Futures	279.509	279.509	277.71	277.71	6.0
2018-08-07	CC	Futures	1508.0	1513.0	1485.0	1495.0	43735.0
2018-08-07	CNH	Futures	6.943	6.9524	6.8955	6.8955	1004.0
2018-08-07	CSC	Futures	3.2	3.214	3.2	3.214	38.0
2018-08-07	CT	Futures	99.33	100.21	98.53	98.99	25.0
2018-08-07	DC	Futures	25.76	26.01	25.76	25.98	209.0
2018-08-07	DX	Futures	90.136	90.188	89.795	90.018	15096.0
2018-08-07	E1	Futures	1.20325	1.20743	1.20289	1.20433	17522.0
2018-08-07	E6	Futures	1.29597	1.30206	1.29563	1.30044	215677.0
2018-08-07	E7	Futures	1.2894	1.2954	1.2893	1.2938	2066.0
2018-08-07	EBM	Futures	227.02	229.64	224.4	226.24	20044.0
2018-08-07	ED	Futures	95.0253	95.0351	95.0253	95.0253	137010.0
2018-08-07	ER	Futures	98.362	98.367	98.357	98.362	52783.0
2018-08-07	EW	Futures	2128.7	2144.2	2127.9	2134.5	7924.0
2018-08-07	FBON	Futures	129.08	129.14	129.05	129.05	21.0
2018-08-07	FBTP	Futures	106.12	106.48	105.89	106.33	45656.0
2018-08-07	FBTS	Futures	102.141	102.355	102.141	102.29	21851.0
2018-08-07	FCE	Futures	4918.2	4969.3	4916.4	4952.3	52469.0
2018-08-07	FDAX	Futures	13181.1	13311.3	13180.1	13227.1	71684.0
2018-08-07	FDIV	Futures	152.09	152.09	151.69	151.69	4.0
2018-08-07	FDXM	Futures	13012.2	13141.2	13008.1	13058.2	27343.0
2018-08-07	FESX	Futures	2908.2	2934.9	2908.2	2928.2	628370.0
2018-08-07	FGBL	Futures	152.86	153.02	152.62	152.66	341621.0
2018-08-07	FGBM	Futures	130.94	130.98	130.84	130.86	204715.0
2018-08-07	FGBS	Futures	112.613	112.633	112.603	112.603	132969.0
2018-08-07	FGBX	Futures	177.34	177.56	176.61	176.81	23516.0
2018-08-07	FMWO	Futures	7212.7	7227.8	7206.9	7220.8	1095.0
2018-08-07	FOAT	Futures	140.44	140.6	140.33	140.39	52170.0
2018-08-07	FTDX	Futures	2891.7	2896.1	2864.7	2865.7	272.0
2018-08-07	FTI	Futures	528.18	530.58	528.0	529.2	15490.0
2018-08-07	FTUK	Futures	6783.6	6854.4	6772.4	6830.8	85177.0
2018-08-07	FVSA	Futures	263.69	263.69	253.18	256.05	21133.0
2018-08-07	FXXP	Futures	336.1	337.8	335.9	337.1	24475.0
2018-08-07	G	Futures	115.34	115.5	115.04	115.1	150322.0
2018-08-07	GF	Futures	314.361	314.931	307.835	310.425	4321.0
2018-08-07	GSCI	Futures	528.04	528.04	525.45	525.45	2067.0

> showing 50 of 114 rows — these rows as CSV

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