PREVIEW / futures_daily / 2019-10-02

all futures daily files

  file:    by_date/futures_daily/2019/2019-10-02.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-10-02	ES	Futures	3185.18	3192.49	3111.3	3118.34	2126769.0
2019-10-02	NQ	Futures	8886.32	8908.79	8672.54	8696.45	586568.0
2019-10-02	YM	Futures	27875.1	27942.3	27222.1	27278.8	240232.0
2019-10-02	CL	Futures	55.44	55.87	53.56	54.04	590306.0
2019-10-02	GC	Futures	1832.3	1864.4	1826.3	1860.1	393098.0
2019-10-02	ZN	Futures	129.511622	130.069061	129.263872	129.96067	1824231.0
2019-10-02	A6	Futures	0.68932	0.69116	0.68624	0.68973	100279.0
2019-10-02	AD	Futures	0.76252	0.76358	0.75643	0.75713	112502.0
2019-10-02	ALI	Futures	2097.35	2097.35	2076.52	2077.12	75.0
2019-10-02	B	Futures	46.94	47.14	45.33	45.7	307905.0
2019-10-02	B6	Futures	1.2529	1.2566	1.2466	1.2546	127565.0
2019-10-02	BR	Futures	0.19247	0.19477	0.19247	0.19445	76.0
2019-10-02	BTC	Futures	11980.8	12081.4	11772.2	11894.5	1861.0
2019-10-02	BZ	Futures	46.26	46.47	44.7	45.06	40386.0
2019-10-02	C	Futures	1692.0	1707.0	1692.0	1702.0	9562.0
2019-10-02	CB	Futures	255.659	255.836	254.773	255.659	37.0
2019-10-02	CC	Futures	1620.0	1641.0	1614.0	1629.0	19126.0
2019-10-02	CNH	Futures	7.1434	7.1564	7.1432	7.1446	194.0
2019-10-02	CSC	Futures	3.127	3.136	3.124	3.136	29.0
2019-10-02	CT	Futures	59.38	59.89	58.77	59.7	12070.0
2019-10-02	DC	Futures	26.31	26.43	26.28	26.39	93.0
2019-10-02	DX	Futures	95.488	95.763	95.319	95.386	13663.0
2019-10-02	E1	Futures	1.16519	1.16646	1.15427	1.1599	34735.0
2019-10-02	E6	Futures	1.19117	1.19453	1.18814	1.19404	166893.0
2019-10-02	E7	Futures	1.1849	1.1883	1.1819	1.1879	2826.0
2019-10-02	EBM	Futures	191.81	192.9	190.71	190.99	33958.0
2019-10-02	ED	Futures	95.3229	95.3763	95.2986	95.3666	393136.0
2019-10-02	ER	Futures	98.465	98.475	98.465	98.47	29560.0
2019-10-02	EW	Futures	1996.7	2002.8	1955.8	1970.0	21419.0
2019-10-02	FBON	Futures	145.76	146.07	145.65	145.91	177.0
2019-10-02	FBTP	Futures	132.07	132.26	131.75	131.81	91866.0
2019-10-02	FBTS	Futures	108.568	108.597	108.452	108.51	33328.0
2019-10-02	FCE	Futures	5064.4	5064.9	4897.0	4907.4	124821.0
2019-10-02	FDAX	Futures	12924.6	12925.1	12546.9	12602.3	152107.0
2019-10-02	FDIV	Futures	146.42	146.42	144.19	144.51	143.0
2019-10-02	FDXM	Futures	12746.5	12756.9	12383.0	12437.7	59738.0
2019-10-02	FESX	Futures	3074.6	3076.4	2973.8	2988.7	1647710.0
2019-10-02	FGBL	Futures	167.95	168.12	167.7	167.88	614301.0
2019-10-02	FGBM	Futures	135.13	135.18	135.06	135.11	391693.0
2019-10-02	FGBS	Futures	113.011	113.031	113.001	113.016	225498.0
2019-10-02	FGBX	Futures	224.23	224.83	223.33	223.96	42995.0
2019-10-02	FMWO	Futures	7197.0	7197.0	7031.0	7064.0	3878.0
2019-10-02	FOAT	Futures	154.61	154.86	154.42	154.6	137408.0
2019-10-02	FTDX	Futures	2731.8	2731.8	2680.5	2684.0	113.0
2019-10-02	FTI	Futures	543.62	544.0	527.07	529.08	44721.0
2019-10-02	FTUK	Futures	6755.1	6762.9	6536.3	6569.7	177882.0
2019-10-02	FVSA	Futures	191.99	223.99	191.99	218.37	55613.0
2019-10-02	FXXP	Futures	349.1	349.2	338.9	340.5	99698.0
2019-10-02	G	Futures	122.88	123.1	122.62	122.99	224061.0
2019-10-02	GF	Futures	295.302	298.285	294.098	297.395	2451.0

> showing 50 of 119 rows — these rows as CSV

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