PREVIEW / futures_daily / 2019-10-04

all futures daily files

  file:    by_date/futures_daily/2019/2019-10-04.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-04	ES	Futures	3151.89	3197.09	3135.93	3194.66	1497975.0
2019-10-04	NQ	Futures	8823.8	8958.63	8786.06	8951.14	420539.0
2019-10-04	YM	Futures	27462.5	27870.9	27357.6	27845.7	190606.0
2019-10-04	CL	Futures	53.68	54.77	53.43	54.22	541104.0
2019-10-04	GC	Futures	1864.6	1877.7	1852.1	1866.2	344786.0
2019-10-04	ZN	Futures	130.518109	130.843282	130.301327	130.719406	1601440.0
2019-10-04	A6	Futures	0.69342	0.6966	0.69291	0.69609	90314.0
2019-10-04	AD	Futures	0.75597	0.75804	0.75572	0.75653	75063.0
2019-10-04	ALI	Futures	2085.57	2094.93	2084.97	2087.08	100.0
2019-10-04	B	Futures	45.7	46.71	45.69	46.24	299922.0
2019-10-04	B6	Futures	1.258	1.2595	1.2513	1.257	102389.0
2019-10-04	BR	Futures	0.19732	0.19881	0.19728	0.19821	812.0
2019-10-04	BTC	Futures	11743.5	11952.0	11534.9	11829.7	1994.0
2019-10-04	BZ	Futures	44.99	46.05	44.99	45.59	41717.0
2019-10-04	C	Futures	1735.0	1754.0	1716.0	1722.0	13766.0
2019-10-04	CB	Futures	253.917	253.917	253.888	253.888	7.0
2019-10-04	CC	Futures	1662.0	1664.0	1620.0	1624.0	19126.0
2019-10-04	CNH	Futures	7.1265	7.1265	7.1035	7.1035	586.0
2019-10-04	CSC	Futures	3.131	3.131	3.097	3.097	50.0
2019-10-04	CT	Futures	60.11	60.52	59.59	60.03	11576.0
2019-10-04	DC	Futures	26.48	26.48	26.07	26.07	144.0
2019-10-04	DX	Futures	95.261	95.387	95.048	95.191	10907.0
2019-10-04	E1	Futures	1.15852	1.16531	1.15599	1.16266	35403.0
2019-10-04	E6	Futures	1.19507	1.19854	1.19355	1.19626	151742.0
2019-10-04	E7	Futures	1.1884	1.1921	1.1874	1.1901	3415.0
2019-10-04	EBM	Futures	192.9	193.18	192.08	192.9	14426.0
2019-10-04	ED	Futures	95.4249	95.4249	95.3666	95.4006	494946.0
2019-10-04	ER	Futures	98.48	98.48	98.47	98.475	28675.0
2019-10-04	EW	Futures	1979.6	2001.2	1970.7	2000.3	10642.0
2019-10-04	FBON	Futures	146.3	146.5	146.25	146.44	95.0
2019-10-04	FBTP	Futures	132.53	132.9	132.37	132.47	62953.0
2019-10-04	FBTS	Futures	108.597	108.683	108.548	108.616	26742.0
2019-10-04	FCE	Futures	4949.0	4984.3	4910.1	4966.7	87513.0
2019-10-04	FDAX	Futures	12633.4	12721.0	12518.9	12644.5	110133.0
2019-10-04	FDXM	Futures	12450.7	12554.9	12354.9	12479.4	47717.0
2019-10-04	FESX	Futures	2999.2	3024.6	2975.5	3006.2	1157189.0
2019-10-04	FGBL	Futures	168.6	168.81	168.4	168.56	429513.0
2019-10-04	FGBM	Futures	135.3	135.37	135.24	135.29	239849.0
2019-10-04	FGBS	Futures	113.031	113.056	113.031	113.041	185833.0
2019-10-04	FGBX	Futures	226.18	227.07	225.62	226.14	29260.0
2019-10-04	FMWO	Futures	7090.1	7193.6	7078.8	7144.7	1834.0
2019-10-04	FOAT	Futures	155.2	155.45	155.12	155.16	89372.0
2019-10-04	FTDX	Futures	2689.9	2730.3	2689.9	2726.9	101.0
2019-10-04	FTI	Futures	533.28	537.36	530.01	535.33	31604.0
2019-10-04	FTUK	Futures	6566.5	6617.4	6529.4	6595.7	109917.0
2019-10-04	FVSA	Futures	211.07	216.69	194.23	199.29	45105.0
2019-10-04	FXXP	Futures	341.4	344.4	339.4	342.4	62938.0
2019-10-04	G	Futures	123.36	123.67	123.29	123.62	165916.0
2019-10-04	GF	Futures	298.494	298.703	296.191	297.186	1447.0
2019-10-04	GSCI	Futures	446.72	449.64	446.66	448.23	89.0

> showing 50 of 119 rows — these rows as CSV

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