PREVIEW / futures_daily / 2018-07-20

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-20.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-07-20	ES	Futures	3047.05	3052.48	3033.47	3041.89	1013663.0
2018-07-20	NQ	Futures	8604.65	8643.71	8570.25	8581.04	302839.0
2018-07-20	YM	Futures	26402.4	26458.2	26249.6	26373.9	141062.0
2018-07-20	CL	Futures	70.39	71.3	70.03	70.62	500967.0
2018-07-20	GC	Futures	1561.3	1573.4	1551.5	1571.7	355232.0
2018-07-20	ZN	Futures	119.665465	119.712082	119.29253	119.323608	1329203.0
2018-07-20	A6	Futures	0.75658	0.76429	0.75267	0.76378	130868.0
2018-07-20	AD	Futures	0.76399	0.773	0.76277	0.77199	91924.0
2018-07-20	B	Futures	53.59	54.19	53.3	53.9	231507.0
2018-07-20	B6	Futures	1.346	1.3589	1.3438	1.3582	140964.0
2018-07-20	BR	Futures	0.19809	0.20129	0.19809	0.2011	328.0
2018-07-20	BTC	Futures	10591.9	10969.4	10356.8	10456.6	6978.0
2018-07-20	BZ	Futures	53.26	53.9	53.04	53.61	24861.0
2018-07-20	C	Futures	1623.0	1638.0	1607.0	1620.0	9064.0
2018-07-20	CB	Futures	275.251	276.24	275.251	275.911	59.0
2018-07-20	CC	Futures	1653.0	1675.0	1634.0	1664.0	22930.0
2018-07-20	CNH	Futures	6.8601	6.9167	6.8601	6.8613	76.0
2018-07-20	CSC	Futures	3.242	3.242	3.194	3.206	132.0
2018-07-20	CT	Futures	99.22	99.32	97.51	98.45	33.0
2018-07-20	DC	Futures	25.81	26.03	25.6	25.7	236.0
2018-07-20	DX	Futures	89.885	90.065	89.146	89.242	34634.0
2018-07-20	E1	Futures	1.2017	1.21078	1.19943	1.20982	30527.0
2018-07-20	E6	Futures	1.30754	1.31828	1.30564	1.31671	290909.0
2018-07-20	E7	Futures	1.3012	1.3116	1.299	1.3101	3415.0
2018-07-20	EBM	Futures	197.2	200.6	197.2	200.08	20689.0
2018-07-20	ED	Futures	94.9864	95.001	94.9767	94.9961	485380.0
2018-07-20	ER	Futures	98.367	98.372	98.362	98.367	98185.0
2018-07-20	EW	Futures	2129.7	2133.2	2116.3	2117.5	18408.0
2018-07-20	FBON	Futures	129.72	129.72	129.13	129.2	91.0
2018-07-20	FBTP	Futures	109.78	109.78	108.84	108.95	71930.0
2018-07-20	FBTS	Futures	103.106	103.106	102.809	102.958	36899.0
2018-07-20	FCE	Futures	4853.6	4863.9	4789.0	4840.6	114789.0
2018-07-20	FDAX	Futures	13224.5	13273.6	13019.1	13131.0	108683.0
2018-07-20	FDXM	Futures	13056.6	13104.1	12853.3	12963.2	44698.0
2018-07-20	FESX	Futures	2885.6	2901.5	2858.9	2887.3	1151502.0
2018-07-20	FGBL	Futures	153.74	153.96	153.06	153.15	597137.0
2018-07-20	FGBM	Futures	131.26	131.34	131.04	131.06	360464.0
2018-07-20	FGBS	Futures	112.703	112.723	112.673	112.678	207048.0
2018-07-20	FGBX	Futures	178.62	179.28	177.14	177.32	39661.0
2018-07-20	FMWO	Futures	7107.9	7139.3	7091.6	7138.2	1644.0
2018-07-20	FOAT	Futures	141.66	141.66	140.83	140.97	107691.0
2018-07-20	FTDX	Futures	2809.8	2842.6	2808.3	2822.5	212.0
2018-07-20	FTI	Futures	522.96	526.79	520.74	525.64	43220.0
2018-07-20	FTUK	Futures	6794.7	6809.8	6742.6	6786.7	89826.0
2018-07-20	FVSA	Futures	273.25	282.8	269.42	278.02	30208.0
2018-07-20	FXXP	Futures	332.1	333.4	329.9	332.4	59199.0
2018-07-20	G	Futures	116.55	116.59	115.91	115.98	201219.0
2018-07-20	GF	Futures	319.902	319.902	316.899	318.349	4788.0
2018-07-20	GSCI	Futures	515.36	515.36	514.18	515.08	106.0
2018-07-20	HE	Futures	74.213	74.715	73.155	74.046	12037.0

> showing 50 of 114 rows — these rows as CSV

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