PREVIEW / futures_daily / 2018-08-17

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-17.parquet
  size:    10 KB
  rows:    117

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-17	ES	Futures	3088.32	3102.98	3079.09	3097.82	1202980.0
2018-08-17	NQ	Futures	8607.27	8635.84	8536.44	8613.39	366862.0
2018-08-17	YM	Futures	26951.3	27112.6	26875.5	27052.5	148777.0
2018-08-17	CL	Futures	67.55	68.5	67.38	67.92	309208.0
2018-08-17	GC	Futures	1496.4	1510.8	1493.7	1500.9	255792.0
2018-08-17	ZN	Futures	119.649926	119.836393	119.556692	119.58777	1312548.0
2018-08-17	A6	Futures	0.7467	0.75287	0.74598	0.75267	98203.0
2018-08-17	AD	Futures	0.77006	0.77639	0.76951	0.77629	70423.0
2018-08-17	B	Futures	52.01	52.84	51.94	52.36	217156.0
2018-08-17	B6	Futures	1.3129	1.3173	1.3114	1.3166	79069.0
2018-08-17	BR	Futures	0.19428	0.19508	0.19233	0.19374	3125.0
2018-08-17	BTC	Futures	8925.1	9324.0	8896.6	9231.4	4288.0
2018-08-17	BZ	Futures	51.94	52.76	51.88	52.29	15051.0
2018-08-17	C	Futures	1467.0	1475.0	1458.0	1462.0	3147.0
2018-08-17	CB	Futures	277.53	277.53	271.653	273.452	70.0
2018-08-17	CC	Futures	1507.0	1510.0	1491.0	1501.0	15073.0
2018-08-17	CNH	Futures	6.958	6.9604	6.9051	6.9051	758.0
2018-08-17	CSC	Futures	3.27	3.272	3.248	3.252	72.0
2018-08-17	CT	Futures	91.54	91.73	91.54	91.73	7.0
2018-08-17	DC	Futures	26.41	26.59	26.26	26.35	341.0
2018-08-17	DX	Futures	91.395	91.452	90.893	90.904	17167.0
2018-08-17	E1	Futures	1.20122	1.20588	1.20038	1.20361	25092.0
2018-08-17	E6	Futures	1.27455	1.2826	1.27377	1.28249	251028.0
2018-08-17	E7	Futures	1.2674	1.2761	1.2672	1.276	3481.0
2018-08-17	EBM	Futures	217.34	223.88	216.56	221.27	16998.0
2018-08-17	ED	Futures	95.0643	95.0813	95.0619	95.0765	201339.0
2018-08-17	ER	Futures	98.367	98.367	98.362	98.367	23743.0
2018-08-17	EW	Futures	2120.8	2133.5	2112.9	2130.5	9175.0
2018-08-17	FBON	Futures	128.77	128.92	128.62	128.71	162.0
2018-08-17	FBTP	Futures	104.33	104.5	103.84	104.17	44686.0
2018-08-17	FBTS	Futures	101.668	101.696	101.483	101.594	30763.0
2018-08-17	FCE	Futures	4818.4	4835.5	4786.4	4814.8	69368.0
2018-08-17	FDAX	Futures	12795.9	12803.2	12677.3	12753.6	72349.0
2018-08-17	FDIV	Futures	145.59	145.59	145.54	145.54	76.0
2018-08-17	FDXM	Futures	12629.4	12638.7	12514.8	12590.7	34504.0
2018-08-17	FESX	Futures	2821.3	2826.3	2798.8	2813.8	914044.0
2018-08-17	FEU3	Futures	99.011	99.016	99.011	99.016	9.0
2018-08-17	FGBL	Futures	154.09	154.42	153.99	154.22	435264.0
2018-08-17	FGBM	Futures	131.52	131.66	131.49	131.59	272295.0
2018-08-17	FGBS	Futures	112.744	112.764	112.729	112.759	239550.0
2018-08-17	FGBX	Futures	179.94	180.84	179.68	180.24	32265.0
2018-08-17	FMWO	Futures	7105.5	7139.3	7082.2	7102.0	2282.0
2018-08-17	FOAT	Futures	141.25	141.47	141.23	141.37	68023.0
2018-08-17	FTDX	Futures	2838.7	2842.1	2812.2	2825.0	86.0
2018-08-17	FTI	Futures	515.7	516.35	509.3	512.36	27730.0
2018-08-17	FTUK	Futures	6719.0	6747.5	6686.4	6723.0	85812.0
2018-08-17	FVSA	Futures	280.47	288.31	276.98	284.82	20182.0
2018-08-17	FXXP	Futures	329.8	330.2	327.5	329.2	32918.0
2018-08-17	G	Futures	116.13	116.41	116.01	116.1	178851.0
2018-08-17	GF	Futures	312.145	316.254	311.625	315.838	4186.0

> showing 50 of 117 rows — these rows as CSV

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