PREVIEW / futures_daily / 2017-10-09

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-09.parquet
  size:    9 KB
  rows:    105

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
2017-10-09	ES	Futures	2766.28	2774.16	2761.93	2766.82	735488.0
2017-10-09	NQ	Futures	7121.08	7146.34	7111.98	7123.43	155751.0
2017-10-09	YM	Futures	23945.7	24024.9	23945.7	23982.7	62206.0
2017-10-09	CL	Futures	49.91	50.45	49.78	50.24	505079.0
2017-10-09	GC	Futures	1626.9	1638.9	1625.8	1635.0	200991.0
2017-10-09	ZN	Futures	123.285695	123.408934	123.224075	123.331909	248732.0
2017-10-09	A6	Futures	0.79926	0.80008	0.79638	0.79751	53860.0
2017-10-09	AD	Futures	0.81208	0.81264	0.8105	0.81122	26148.0
2017-10-09	B	Futures	39.2	39.53	38.88	39.4	301152.0
2017-10-09	B6	Futures	1.3668	1.3774	1.3659	1.374	94039.0
2017-10-09	BR	Futures	0.23615	0.23615	0.23547	0.23547	816.0
2017-10-09	BZ	Futures	38.87	39.21	38.57	39.08	23056.0
2017-10-09	C	Futures	1550.0	1563.0	1495.0	1500.0	18146.0
2017-10-09	CB	Futures	299.848	300.005	298.021	298.588	25.0
2017-10-09	CC	Futures	1553.0	1558.0	1484.0	1491.0	35316.0
2017-10-09	CNH	Futures	6.8544	6.8544	6.8134	6.8166	31.0
2017-10-09	CSC	Futures	3.528	3.528	3.493	3.493	63.0
2017-10-09	CT	Futures	80.67	81.13	79.93	80.99	9241.0
2017-10-09	DC	Futures	28.92	28.94	28.39	28.56	71.0
2017-10-09	DX	Futures	87.554	87.596	87.395	87.442	12435.0
2017-10-09	E1	Futures	1.25536	1.25658	1.25206	1.25377	14351.0
2017-10-09	E6	Futures	1.34403	1.34637	1.34209	1.34562	106731.0
2017-10-09	E7	Futures	1.337	1.3393	1.3352	1.3386	1950.0
2017-10-09	EBM	Futures	177.75	178.01	176.67	176.94	12976.0
2017-10-09	ED	Futures	95.4891	95.4939	95.4794	95.4842	30531.0
2017-10-09	ER	Futures	98.337	98.342	98.337	98.337	22777.0
2017-10-09	EW	Futures	1930.2	1938.5	1924.6	1927.3	7793.0
2017-10-09	FBON	Futures	124.04	124.53	123.96	124.2	911.0
2017-10-09	FBTP	Futures	108.46	109.11	108.44	108.84	88680.0
2017-10-09	FBTS	Futures	103.228	103.292	103.228	103.246	30533.0
2017-10-09	FCE	Futures	4817.2	4817.2	4792.1	4805.5	49010.0
2017-10-09	FDAX	Futures	13641.2	13651.2	13586.1	13630.2	45956.0
2017-10-09	FDXM	Futures	13517.8	13535.5	13469.8	13515.2	12682.0
2017-10-09	FESX	Futures	2938.5	2944.2	2927.0	2936.8	440367.0
2017-10-09	FGBL	Futures	148.93	149.32	148.93	149.27	363607.0
2017-10-09	FGBM	Futures	129.49	129.61	129.48	129.6	244505.0
2017-10-09	FGBS	Futures	112.412	112.447	112.412	112.437	135659.0
2017-10-09	FGBX	Futures	166.5	167.4	166.48	167.24	23713.0
2017-10-09	FMWO	Futures	6703.7	6708.5	6699.0	6707.3	1859.0
2017-10-09	FOAT	Futures	136.13	136.52	136.13	136.5	59456.0
2017-10-09	FTDX	Futures	2488.0	2494.5	2480.0	2481.0	79.0
2017-10-09	FTI	Futures	498.02	499.95	496.77	498.48	15424.0
2017-10-09	FTUK	Futures	6508.5	6515.4	6460.8	6479.4	67817.0
2017-10-09	FVSA	Futures	380.27	383.11	371.76	377.43	12205.0
2017-10-09	FXXP	Futures	330.4	331.4	330.1	330.6	15350.0
2017-10-09	G	Futures	113.31	113.54	113.22	113.5	102958.0
2017-10-09	GF	Futures	336.325	336.98	333.924	335.616	1422.0
2017-10-09	GSCI	Futures	468.38	468.56	467.55	468.56	1762.0
2017-10-09	HE	Futures	89.959	90.55	89.479	89.996	14604.0
2017-10-09	HG	Futures	3.6463	3.668	3.6384	3.6614	77522.0

> showing 50 of 105 rows — these rows as CSV

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