PREVIEW / futures_daily / 2019-10-29

all futures daily files

  file:    by_date/futures_daily/2019/2019-10-29.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-29	ES	Futures	3289.11	3297.77	3279.64	3286.4	1040149.0
2019-10-29	NQ	Futures	9345.27	9356.22	9277.85	9283.04	351246.0
2019-10-29	YM	Futures	28409.4	28460.9	28309.7	28388.4	125026.0
2019-10-29	CL	Futures	57.01	57.12	55.79	56.74	521457.0
2019-10-29	GC	Futures	1843.3	1846.7	1832.6	1838.9	291980.0
2019-10-29	ZN	Futures	128.009634	128.195447	127.885759	128.102541	1107499.0
2019-10-29	A6	Futures	0.70245	0.70604	0.70235	0.70522	68562.0
2019-10-29	AD	Futures	0.77194	0.77259	0.76917	0.76982	70628.0
2019-10-29	ALI	Futures	2121.43	2121.43	2121.43	2121.43	2.0
2019-10-29	B	Futures	48.89	49.17	48.1	48.84	266281.0
2019-10-29	B6	Futures	1.3096	1.3141	1.3041	1.3095	96769.0
2019-10-29	BR	Futures	0.20225	0.20285	0.20148	0.2016	7962.0
2019-10-29	BTC	Futures	13841.3	13942.4	13220.4	13451.4	3035.0
2019-10-29	BZ	Futures	48.18	48.49	47.46	48.17	25176.0
2019-10-29	C	Futures	1693.0	1695.0	1675.0	1686.0	6711.0
2019-10-29	CB	Futures	245.061	247.393	244.441	246.507	21.0
2019-10-29	CC	Futures	1615.0	1637.0	1607.0	1631.0	27999.0
2019-10-29	CNH	Futures	7.0542	7.0602	7.0467	7.0591	507.0
2019-10-29	CSC	Futures	3.357	3.415	3.357	3.412	47.0
2019-10-29	CT	Futures	63.18	63.74	62.98	63.0	13548.0
2019-10-29	DC	Futures	27.95	28.46	27.9	28.4	770.0
2019-10-29	DX	Futures	94.261	94.43	94.12	94.206	10426.0
2019-10-29	E1	Futures	1.16048	1.16209	1.15852	1.16163	19471.0
2019-10-29	E6	Futures	1.20699	1.20889	1.20396	1.20802	146337.0
2019-10-29	E7	Futures	1.2008	1.2027	1.1978	1.2018	2444.0
2019-10-29	EBM	Futures	196.73	197.83	196.19	196.46	30358.0
2019-10-29	ED	Futures	95.318	95.3326	95.3083	95.3229	290339.0
2019-10-29	ER	Futures	98.401	98.411	98.401	98.406	54953.0
2019-10-29	EW	Futures	2070.9	2080.7	2061.3	2075.1	12366.0
2019-10-29	FBON	Futures	144.27	144.58	144.27	144.55	198.0
2019-10-29	FBTP	Futures	130.56	130.94	130.56	130.89	64435.0
2019-10-29	FBTS	Futures	108.24	108.336	108.24	108.327	29853.0
2019-10-29	FCE	Futures	5200.0	5220.0	5184.6	5207.7	64855.0
2019-10-29	FDAX	Futures	13684.3	13684.3	13599.9	13647.9	74862.0
2019-10-29	FDIV	Futures	158.71	158.71	158.01	158.29	51.0
2019-10-29	FDXM	Futures	13498.4	13498.4	13420.2	13469.7	28792.0
2019-10-29	FESX	Futures	3178.1	3178.1	3157.9	3166.7	657291.0
2019-10-29	FGBL	Futures	164.88	165.32	164.8	165.23	507809.0
2019-10-29	FGBM	Futures	133.91	134.0	133.87	133.94	351030.0
2019-10-29	FGBS	Futures	112.724	112.749	112.709	112.724	220547.0
2019-10-29	FGBX	Futures	213.57	215.48	213.2	215.09	39055.0
2019-10-29	FMWO	Futures	7433.6	7450.7	7418.8	7446.1	1245.0
2019-10-29	FOAT	Futures	152.43	152.89	152.41	152.8	128793.0
2019-10-29	FTDX	Futures	2783.7	2783.7	2766.4	2769.8	40.0
2019-10-29	FTI	Futures	555.18	556.37	551.89	553.27	22999.0
2019-10-29	FTUK	Futures	6788.0	6788.0	6710.6	6743.9	84772.0
2019-10-29	FVSA	Futures	155.56	159.81	155.56	158.75	17670.0
2019-10-29	FXXP	Futures	360.1	360.2	358.1	359.4	40633.0
2019-10-29	G	Futures	120.76	121.08	120.58	120.81	177587.0
2019-10-29	GF	Futures	305.088	305.14	303.413	304.565	1141.0

> showing 50 of 119 rows — these rows as CSV

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