PREVIEW / futures_daily / 2018-07-19

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-19.parquet
  size:    10 KB
  rows:    112

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-07-19	ES	Futures	3056.82	3060.62	3041.35	3046.78	1082645.0
2018-07-19	NQ	Futures	8627.67	8646.33	8574.92	8590.07	321505.0
2018-07-19	YM	Futures	26515.1	26562.5	26378.1	26404.5	141010.0
2018-07-19	CL	Futures	70.31	71.17	68.93	70.6	719522.0
2018-07-19	GC	Futures	1566.9	1569.8	1545.7	1562.7	428879.0
2018-07-19	ZN	Futures	119.416841	119.758698	119.199296	119.634387	1757197.0
2018-07-19	A6	Futures	0.76079	0.76563	0.75308	0.75689	139889.0
2018-07-19	AD	Futures	0.76976	0.77037	0.76282	0.765	85641.0
2018-07-19	B	Futures	53.89	54.43	52.98	53.54	313811.0
2018-07-19	B6	Futures	1.3523	1.353	1.34	1.3461	149732.0
2018-07-19	BR	Futures	0.19668	0.19809	0.19492	0.19637	304.0
2018-07-19	BTC	Futures	10435.2	10698.7	10364.0	10613.3	4580.0
2018-07-19	BZ	Futures	53.54	54.14	52.7	53.25	31672.0
2018-07-19	C	Futures	1627.0	1661.0	1609.0	1614.0	9792.0
2018-07-19	CC	Futures	1667.0	1691.0	1640.0	1643.0	26154.0
2018-07-19	CNH	Futures	6.8287	6.8866	6.8287	6.8665	173.0
2018-07-19	CSC	Futures	3.278	3.294	3.212	3.22	123.0
2018-07-19	CT	Futures	99.65	99.65	99.08	99.08	12.0
2018-07-19	DC	Futures	26.16	26.2	25.63	25.78	248.0
2018-07-19	DX	Futures	89.804	90.391	89.657	89.92	40045.0
2018-07-19	E1	Futures	1.20218	1.20564	1.19548	1.20229	29042.0
2018-07-19	E6	Futures	1.30793	1.31162	1.29983	1.30777	280556.0
2018-07-19	E7	Futures	1.3013	1.3048	1.2933	1.3012	5424.0
2018-07-19	EBM	Futures	194.07	196.94	193.54	196.68	15874.0
2018-07-19	ED	Futures	94.9767	94.9913	94.9669	94.9815	294817.0
2018-07-19	ER	Futures	98.367	98.367	98.362	98.367	30654.0
2018-07-19	EW	Futures	2119.7	2134.8	2111.3	2130.9	13755.0
2018-07-19	FBON	Futures	129.52	129.73	129.52	129.6	448.0
2018-07-19	FBTP	Futures	109.54	110.03	109.53	109.66	51824.0
2018-07-19	FBTS	Futures	102.883	103.217	102.883	103.125	32659.0
2018-07-19	FCE	Futures	4880.9	4882.7	4849.5	4857.6	65079.0
2018-07-19	FDAX	Futures	13325.9	13330.1	13221.4	13251.7	71881.0
2018-07-19	FDXM	Futures	13152.6	13157.7	13052.5	13082.4	29972.0
2018-07-19	FESX	Futures	2900.7	2906.5	2886.5	2892.3	866719.0
2018-07-19	FGBL	Futures	153.38	153.84	153.31	153.67	457583.0
2018-07-19	FGBM	Futures	131.18	131.29	131.12	131.24	294634.0
2018-07-19	FGBS	Futures	112.713	112.718	112.693	112.708	232227.0
2018-07-19	FGBX	Futures	177.94	178.96	177.62	178.58	32727.0
2018-07-19	FMWO	Futures	7130.0	7130.0	7098.6	7113.7	2583.0
2018-07-19	FOAT	Futures	141.4	141.64	141.32	141.56	103592.0
2018-07-19	FTDX	Futures	2839.7	2839.7	2802.4	2809.8	198.0
2018-07-19	FTI	Futures	522.04	524.35	521.02	523.88	16614.0
2018-07-19	FTUK	Futures	6780.9	6808.9	6768.9	6794.7	82694.0
2018-07-19	FVSA	Futures	265.6	273.25	261.78	269.42	21707.0
2018-07-19	FXXP	Futures	333.6	334.0	332.0	332.8	43957.0
2018-07-19	G	Futures	115.88	116.51	115.84	116.41	252503.0
2018-07-19	GF	Futures	320.058	320.938	318.608	319.954	4446.0
2018-07-19	GSCI	Futures	507.75	515.08	507.75	513.33	148.0
2018-07-19	HE	Futures	75.244	76.303	74.492	74.938	17311.0
2018-07-19	HG	Futures	3.2435	3.2587	3.1356	3.1614	148360.0

> showing 50 of 112 rows — these rows as CSV

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