PREVIEW / futures_daily / 2019-09-18

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-18.parquet
  size:    10 KB
  rows:    119

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-18	ES	Futures	3257.17	3262.59	3226.86	3256.9	1623840.0
2019-09-18	NQ	Futures	9122.85	9138.12	9004.44	9124.87	402501.0
2019-09-18	YM	Futures	28465.1	28535.4	28239.4	28494.5	144191.0
2019-09-18	CL	Futures	60.18	60.85	59.12	59.59	654343.0
2019-09-18	GC	Futures	1862.3	1874.4	1838.9	1869.8	364956.0
2019-09-18	ZN	Futures	128.210932	128.690948	128.025119	128.226416	1643122.0
2019-09-18	A6	Futures	0.70635	0.70666	0.70101	0.70214	91840.0
2019-09-18	AD	Futures	0.76121	0.76262	0.75773	0.75864	70603.0
2019-09-18	ALI	Futures	2160.13	2173.41	2156.21	2166.77	215.0
2019-09-18	B	Futures	49.61	50.19	48.69	49.12	295047.0
2019-09-18	B6	Futures	1.2755	1.2765	1.269	1.2716	96626.0
2019-09-18	BR	Futures	0.19647	0.19647	0.1959	0.19602	3.0
2019-09-18	BTC	Futures	14644.5	14730.2	14458.8	14580.2	1581.0
2019-09-18	BZ	Futures	48.89	49.45	47.99	48.4	37459.0
2019-09-18	C	Futures	1610.0	1619.0	1603.0	1618.0	11138.0
2019-09-18	CB	Futures	253.888	255.364	253.888	254.773	11.0
2019-09-18	CC	Futures	1574.0	1584.0	1562.0	1576.0	23595.0
2019-09-18	CNH	Futures	7.0863	7.0904	7.0753	7.0856	727.0
2019-09-18	CSC	Futures	3.057	3.093	3.032	3.086	40.0
2019-09-18	CT	Futures	59.02	59.02	58.51	58.62	36.0
2019-09-18	DC	Futures	25.98	26.12	25.58	25.98	358.0
2019-09-18	DX	Futures	94.478	94.981	94.478	94.849	14068.0
2019-09-18	E1	Futures	1.16715	1.16772	1.16082	1.16232	36982.0
2019-09-18	E6	Futures	1.20797	1.2083	1.20147	1.20347	159348.0
2019-09-18	E7	Futures	1.2017	1.2022	1.1952	1.1973	3058.0
2019-09-18	EBM	Futures	187.7	188.25	186.61	187.7	19203.0
2019-09-18	ED	Futures	95.2063	95.2694	95.1771	95.2014	594804.0
2019-09-18	ER	Futures	98.435	98.445	98.431	98.435	112390.0
2019-09-18	EW	Futures	2062.3	2062.3	2037.6	2055.1	17221.0
2019-09-18	FBON	Futures	144.65	145.34	144.55	145.23	282.0
2019-09-18	FBTP	Futures	131.37	132.23	131.37	131.99	64773.0
2019-09-18	FBTS	Futures	108.327	108.5	108.327	108.462	34354.0
2019-09-18	FCE	Futures	5073.9	5096.6	5062.6	5080.7	94869.0
2019-09-18	FDAX	Futures	13057.6	13094.5	13012.7	13070.7	51277.0
2019-09-18	FDXM	Futures	12880.8	12924.6	12842.3	12900.1	4417.0
2019-09-18	FESX	Futures	3075.5	3089.5	3070.3	3084.3	1237207.0
2019-09-18	FGBL	Futures	166.99	167.58	166.78	167.48	505963.0
2019-09-18	FGBM	Futures	134.73	134.89	134.68	134.84	277935.0
2019-09-18	FGBS	Futures	112.9	112.946	112.89	112.935	308821.0
2019-09-18	FGBX	Futures	218.87	222.32	218.5	221.61	52750.0
2019-09-18	FMWO	Futures	7401.8	7401.8	7324.4	7326.7	15696.0
2019-09-18	FOAT	Futures	153.77	154.51	153.77	154.41	97856.0
2019-09-18	FTDX	Futures	2843.9	2854.2	2843.9	2851.8	828.0
2019-09-18	FTI	Futures	544.71	548.31	544.33	546.74	34721.0
2019-09-18	FTUK	Futures	6742.6	6779.6	6731.4	6750.4	208864.0
2019-09-18	FVSA	Futures	185.81	187.5	181.32	184.69	29795.0
2019-09-18	FXXP	Futures	350.2	351.8	350.0	350.9	120762.0
2019-09-18	G	Futures	120.79	121.56	120.77	121.38	171908.0
2019-09-18	GF	Futures	287.4	290.278	286.72	289.702	4272.0
2019-09-18	GSCI	Futures	468.39	468.51	467.89	467.89	27.0

> showing 50 of 119 rows — these rows as CSV

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