PREVIEW / futures_daily / 2019-07-22

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-22.parquet
  size:    10 KB
  rows:    118

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-07-22	ES	Futures	3209.65	3230.16	3207.5	3225.3	1098399.0
2019-07-22	NQ	Futures	9014.87	9137.49	9010.56	9123.96	355209.0
2019-07-22	YM	Futures	28462.0	28577.5	28432.6	28535.5	144409.0
2019-07-22	CL	Futures	57.35	58.2	56.97	57.37	619483.0
2019-07-22	GC	Futures	1777.9	1780.8	1771.1	1776.0	255354.0
2019-07-22	ZN	Futures	126.895998	127.098186	126.756022	127.004869	816913.0
2019-07-22	A6	Futures	0.72631	0.72723	0.72456	0.72507	51614.0
2019-07-22	AD	Futures	0.7729	0.77376	0.76902	0.76952	53093.0
2019-07-22	ALI	Futures	2274.27	2274.27	2274.27	2274.27	0.0
2019-07-22	B	Futures	47.4	48.14	47.19	47.56	267778.0
2019-07-22	B6	Futures	1.2798	1.2807	1.2747	1.2774	64466.0
2019-07-22	BFX	Futures	4134.7	4134.7	4101.0	4120.7	9.0
2019-07-22	BR	Futures	0.21246	0.21334	0.21246	0.21334	178.0
2019-07-22	BTC	Futures	14880.8	15006.8	14096.9	14201.9	5223.0
2019-07-22	BZ	Futures	46.7	47.52	46.59	46.96	33851.0
2019-07-22	C	Futures	1740.0	1759.0	1734.0	1756.0	6201.0
2019-07-22	CB	Futures	287.894	287.953	283.576	284.743	75.0
2019-07-22	CC	Futures	1656.0	1691.0	1647.0	1687.0	20589.0
2019-07-22	CNH	Futures	6.8844	6.8878	6.8812	6.8856	617.0
2019-07-22	CSC	Futures	3.127	3.139	3.119	3.129	70.0
2019-07-22	CT	Futures	61.92	62.92	61.86	62.01	66.0
2019-07-22	DC	Futures	26.42	26.51	26.3	26.39	195.0
2019-07-22	DX	Futures	93.185	93.378	93.185	93.335	6901.0
2019-07-22	E1	Futures	1.18684	1.18881	1.18441	1.18754	17325.0
2019-07-22	E6	Futures	1.22958	1.23002	1.22789	1.22844	116579.0
2019-07-22	E7	Futures	1.223	1.2236	1.2215	1.222	1997.0
2019-07-22	EBM	Futures	202.09	202.38	200.94	201.23	14077.0
2019-07-22	ED	Futures	95.3233	95.3282	95.299	95.3087	250156.0
2019-07-22	ER	Futures	98.524	98.533	98.524	98.533	50318.0
2019-07-22	EW	Futures	2033.7	2045.9	2033.0	2035.8	9011.0
2019-07-22	FBON	Futures	143.5	143.5	143.17	143.3	169.0
2019-07-22	FBTP	Futures	124.95	125.2	124.27	124.33	73259.0
2019-07-22	FBTS	Futures	107.628	107.695	107.485	107.523	40724.0
2019-07-22	FCE	Futures	5058.3	5079.7	5049.2	5070.6	67236.0
2019-07-22	FDAX	Futures	12862.8	12992.8	12862.8	12929.6	85924.0
2019-07-22	FDIV	Futures	146.23	146.51	146.18	146.42	51.0
2019-07-22	FDXM	Futures	12704.8	12832.7	12704.8	12770.3	31169.0
2019-07-22	FESX	Futures	3026.5	3051.0	3025.6	3040.5	638105.0
2019-07-22	FGBL	Futures	164.87	165.25	164.77	165.24	408763.0
2019-07-22	FGBM	Futures	134.68	134.81	134.63	134.81	209567.0
2019-07-22	FGBS	Futures	113.126	113.142	113.106	113.137	129933.0
2019-07-22	FGBX	Futures	209.34	210.33	208.81	210.25	31228.0
2019-07-22	FMWO	Futures	7389.1	7404.1	7374.1	7390.2	910.0
2019-07-22	FOAT	Futures	152.1	152.33	152.02	152.3	80866.0
2019-07-22	FTDX	Futures	2826.6	2856.2	2825.1	2844.4	75.0
2019-07-22	FTI	Futures	540.0	544.41	539.33	543.39	19789.0
2019-07-22	FTUK	Futures	6880.3	6910.3	6854.0	6874.3	64370.0
2019-07-22	FVSA	Futures	176.83	177.45	172.51	174.98	27249.0
2019-07-22	FXXP	Futures	345.7	347.2	345.2	346.1	41534.0
2019-07-22	G	Futures	120.79	121.22	120.79	121.17	146158.0

> showing 50 of 118 rows — these rows as CSV

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