PREVIEW / futures_daily / 2019-08-02

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-02.parquet
  size:    10 KB
  rows:    120

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-08-02	ES	Futures	3183.49	3195.09	3143.83	3164.33	2447014.0
2019-08-02	NQ	Futures	8976.88	8987.24	8807.92	8867.79	736453.0
2019-08-02	YM	Futures	27843.5	27996.8	27524.3	27772.1	359330.0
2019-08-02	CL	Futures	55.65	57.19	55.25	56.8	739810.0
2019-08-02	GC	Futures	1797.9	1803.3	1779.4	1797.9	493051.0
2019-08-02	ZN	Futures	127.969148	128.544604	127.860277	128.264652	2311855.0
2019-08-02	A6	Futures	0.70038	0.70244	0.69668	0.70018	134203.0
2019-08-02	AD	Futures	0.76342	0.76448	0.75944	0.76358	79753.0
2019-08-02	ALI	Futures	2193.95	2193.95	2177.16	2178.38	73.0
2019-08-02	B	Futures	46.14	47.49	46.0	46.69	364137.0
2019-08-02	B6	Futures	1.2397	1.2447	1.2366	1.2436	94226.0
2019-08-02	BR	Futures	0.20739	0.20739	0.20475	0.20531	6548.0
2019-08-02	BTC	Futures	14587.5	14966.1	14442.9	14594.4	2699.0
2019-08-02	BZ	Futures	45.5	46.86	45.34	46.09	47421.0
2019-08-02	C	Futures	1721.0	1735.0	1712.0	1715.0	8112.0
2019-08-02	CB	Futures	277.45	277.45	275.232	275.816	52.0
2019-08-02	CC	Futures	1559.0	1568.0	1537.0	1545.0	25701.0
2019-08-02	CNH	Futures	6.9673	6.9865	6.958	6.9844	1950.0
2019-08-02	CSC	Futures	3.078	3.104	3.078	3.104	61.0
2019-08-02	CT	Futures	60.73	60.73	58.11	58.21	36.0
2019-08-02	DC	Futures	25.95	26.13	25.94	26.11	271.0
2019-08-02	DX	Futures	94.538	94.572	94.177	94.213	18150.0
2019-08-02	E1	Futures	1.17559	1.18615	1.17501	1.1851	36575.0
2019-08-02	E6	Futures	1.21311	1.21671	1.21164	1.21616	215301.0
2019-08-02	E7	Futures	1.2069	1.2104	1.205	1.2099	4243.0
2019-08-02	EBM	Futures	199.5	200.08	199.22	199.5	17720.0
2019-08-02	ED	Futures	95.3087	95.3574	95.3087	95.3525	662775.0
2019-08-02	ER	Futures	98.543	98.543	98.533	98.538	54958.0
2019-08-02	EW	Futures	2028.7	2031.9	1998.6	2011.5	16914.0
2019-08-02	FBON	Futures	144.34	145.08	144.34	144.86	206.0
2019-08-02	FBTP	Futures	125.62	125.77	124.82	125.59	88510.0
2019-08-02	FBTS	Futures	107.724	107.743	107.523	107.638	34906.0
2019-08-02	FCE	Futures	4962.2	4971.3	4872.9	4880.6	185433.0
2019-08-02	FDAX	Futures	12686.9	12709.5	12452.6	12515.3	182307.0
2019-08-02	FDIV	Futures	142.61	142.61	141.59	141.59	333.0
2019-08-02	FDXM	Futures	12534.3	12551.9	12299.2	12361.1	109607.0
2019-08-02	FESX	Futures	2993.3	2996.8	2934.8	2948.8	1868036.0
2019-08-02	FGBL	Futures	167.09	167.45	166.99	167.18	865274.0
2019-08-02	FGBM	Futures	135.16	135.23	135.04	135.07	459615.0
2019-08-02	FGBS	Futures	113.147	113.177	113.131	113.137	179536.0
2019-08-02	FGBX	Futures	218.2	221.32	217.98	219.83	96696.0
2019-08-02	FMWO	Futures	7271.4	7291.0	7192.9	7212.5	3203.0
2019-08-02	FOAT	Futures	153.92	154.26	153.79	154.02	137807.0
2019-08-02	FTDX	Futures	2860.2	2865.6	2817.2	2817.2	148.0
2019-08-02	FTI	Futures	529.18	531.03	521.96	523.28	61910.0
2019-08-02	FTUK	Futures	6862.3	6871.1	6750.6	6773.2	181773.0
2019-08-02	FVSA	Futures	193.53	211.46	192.91	208.99	85036.0
2019-08-02	FXXP	Futures	340.3	341.6	336.8	337.8	176326.0
2019-08-02	G	Futures	123.0	123.08	122.61	122.75	253905.0
2019-08-02	GF	Futures	278.268	278.268	271.792	274.0	2412.0

> showing 50 of 120 rows — these rows as CSV

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