PREVIEW / futures_daily / 2019-09-19

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-19.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
2019-09-19	ES	Futures	3258.53	3274.23	3238.23	3256.36	1323245.0
2019-09-19	NQ	Futures	9132.93	9189.11	9049.38	9124.87	400780.0
2019-09-19	YM	Futures	28522.8	28619.4	28334.9	28426.2	143859.0
2019-09-19	CL	Futures	59.72	61.08	59.57	59.74	722337.0
2019-09-19	GC	Futures	1852.8	1865.3	1845.8	1858.0	291302.0
2019-09-19	ZN	Futures	128.13351	128.536104	127.947697	128.427713	1440535.0
2019-09-19	A6	Futures	0.70245	0.70276	0.69763	0.69958	93565.0
2019-09-19	AD	Futures	0.75899	0.76176	0.75794	0.76101	75989.0
2019-09-19	ALI	Futures	2173.11	2183.98	2171.3	2183.98	185.0
2019-09-19	B	Futures	49.05	50.64	49.01	49.74	258848.0
2019-09-19	B6	Futures	1.2724	1.2813	1.2687	1.2788	117196.0
2019-09-19	BR	Futures	0.19477	0.19493	0.19348	0.19388	97.0
2019-09-19	BTC	Futures	14737.4	14930.3	13723.0	14508.8	4344.0
2019-09-19	BZ	Futures	48.43	49.89	48.3	49.0	36971.0
2019-09-19	C	Futures	1617.0	1651.0	1614.0	1649.0	10597.0
2019-09-19	CC	Futures	1581.0	1622.0	1578.0	1620.0	29399.0
2019-09-19	CNH	Futures	7.0916	7.1084	7.0884	7.1007	708.0
2019-09-19	CSC	Futures	3.109	3.114	3.098	3.107	31.0
2019-09-19	CT	Futures	58.36	58.64	58.25	58.25	30.0
2019-09-19	DC	Futures	26.01	26.37	26.01	26.22	198.0
2019-09-19	DX	Futures	94.865	94.923	94.502	94.572	12895.0
2019-09-19	E1	Futures	1.16301	1.17037	1.16071	1.16807	36351.0
2019-09-19	E6	Futures	1.20353	1.20786	1.20239	1.20564	151643.0
2019-09-19	E7	Futures	1.1973	1.2016	1.1961	1.1994	2696.0
2019-09-19	EBM	Futures	187.43	188.8	187.16	187.98	20516.0
2019-09-19	ED	Futures	95.1868	95.2257	95.1771	95.216	488671.0
2019-09-19	ER	Futures	98.435	98.44	98.426	98.431	71040.0
2019-09-19	EW	Futures	2055.6	2068.0	2043.3	2050.7	12255.0
2019-09-19	FBON	Futures	145.11	145.2	144.82	144.95	284.0
2019-09-19	FBTP	Futures	132.1	132.13	131.48	131.87	59734.0
2019-09-19	FBTS	Futures	108.481	108.51	108.317	108.413	42762.0
2019-09-19	FCE	Futures	5084.4	5121.0	5076.2	5115.6	69064.0
2019-09-19	FDAX	Futures	13086.0	13145.7	13013.8	13125.6	60401.0
2019-09-19	FDIV	Futures	148.87	149.57	148.87	149.57	4796.0
2019-09-19	FDXM	Futures	12926.6	12973.5	12846.4	12954.2	4259.0
2019-09-19	FESX	Futures	3087.8	3105.3	3075.5	3100.9	1092446.0
2019-09-19	FGBL	Futures	167.19	167.51	166.98	167.41	535141.0
2019-09-19	FGBM	Futures	134.79	134.84	134.64	134.76	339648.0
2019-09-19	FGBS	Futures	112.91	112.93	112.88	112.91	311070.0
2019-09-19	FGBX	Futures	221.32	222.59	219.91	222.07	48285.0
2019-09-19	FMWO	Futures	7317.6	7375.6	7317.6	7374.5	6021.0
2019-09-19	FOAT	Futures	154.3	154.4	153.82	154.27	122780.0
2019-09-19	FTDX	Futures	2849.8	2856.7	2842.9	2849.3	76.0
2019-09-19	FTI	Futures	546.65	549.93	545.42	549.07	17141.0
2019-09-19	FTUK	Futures	6737.9	6800.5	6720.3	6791.7	105031.0
2019-09-19	FVSA	Futures	183.57	185.25	174.02	175.15	32451.0
2019-09-19	FXXP	Futures	350.8	353.3	350.2	352.9	74985.0
2019-09-19	G	Futures	121.15	121.68	121.01	121.51	161173.0
2019-09-19	GF	Futures	289.388	291.325	288.08	290.801	3705.0
2019-09-19	HE	Futures	56.822	59.91	56.78	57.887	31644.0

> showing 50 of 117 rows — these rows as CSV

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