PREVIEW / futures_daily / 2018-01-23

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-23.parquet
  size:    9 KB
  rows:    111

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
2018-01-23	ES	Futures	3081.57	3091.9	3074.51	3086.19	1282163.0
2018-01-23	NQ	Futures	8115.98	8176.3	8104.27	8158.14	336204.0
2018-01-23	YM	Futures	27631.8	27752.0	27562.2	27631.8	183153.0
2018-01-23	CL	Futures	63.86	64.86	63.68	64.45	662456.0
2018-01-23	GC	Futures	1690.0	1700.7	1687.0	1694.6	370174.0
2018-01-23	ZN	Futures	120.617681	120.957058	120.571402	120.864501	1539444.0
2018-01-23	A6	Futures	0.82415	0.82579	0.81828	0.8225	124849.0
2018-01-23	AD	Futures	0.81625	0.81803	0.8133	0.81701	64728.0
2018-01-23	B	Futures	49.43	50.09	49.31	49.9	297329.0
2018-01-23	B6	Futures	1.4568	1.462	1.45	1.4588	125435.0
2018-01-23	BR	Futures	0.23514	0.23514	0.2334	0.23344	355.0
2018-01-23	BTC	Futures	13607.5	14536.1	12634.2	14209.5	1241.0
2018-01-23	BZ	Futures	48.76	49.43	48.69	49.25	13492.0
2018-01-23	C	Futures	1257.0	1266.0	1247.0	1248.0	7974.0
2018-01-23	CB	Futures	268.954	269.418	268.954	269.325	10.0
2018-01-23	CC	Futures	1454.0	1470.0	1435.0	1439.0	16983.0
2018-01-23	CNH	Futures	6.5493	6.559	6.5487	6.5492	57.0
2018-01-23	CSC	Futures	3.18	3.189	3.135	3.148	76.0
2018-01-23	CT	Futures	97.43	97.73	95.78	96.08	21793.0
2018-01-23	DC	Futures	25.15	25.44	24.98	25.18	288.0
2018-01-23	DX	Futures	84.665	84.89	84.374	84.439	20361.0
2018-01-23	E1	Futures	1.26685	1.27401	1.2649	1.27207	23191.0
2018-01-23	E6	Futures	1.39447	1.39974	1.39027	1.39844	221040.0
2018-01-23	E7	Futures	1.3873	1.3928	1.3833	1.3915	4785.0
2018-01-23	EBM	Futures	167.5	168.57	167.23	167.77	15522.0
2018-01-23	ED	Futures	95.3213	95.331	95.3213	95.331	265777.0
2018-01-23	ER	Futures	98.337	98.337	98.332	98.332	18939.0
2018-01-23	EW	Futures	2111.8	2119.0	2105.2	2116.0	12848.0
2018-01-23	FBON	Futures	127.28	127.76	127.28	127.58	404.0
2018-01-23	FBTP	Futures	112.12	112.55	112.05	112.35	108156.0
2018-01-23	FBTS	Futures	103.686	103.714	103.659	103.695	45421.0
2018-01-23	FCE	Futures	4974.0	4974.9	4920.9	4933.9	62584.0
2018-01-23	FDAX	Futures	14055.7	14105.5	14018.3	14063.0	77734.0
2018-01-23	FDIV	Futures	156.1	156.1	155.81	155.81	50.0
2018-01-23	FDXM	Futures	14074.3	14129.4	14042.1	14086.8	24581.0
2018-01-23	FESX	Futures	3002.2	3007.1	2984.2	2989.1	866287.0
2018-01-23	FGBL	Futures	148.93	149.33	148.92	149.03	608180.0
2018-01-23	FGBM	Futures	129.06	129.22	129.02	129.06	473573.0
2018-01-23	FGBS	Futures	112.331	112.352	112.321	112.331	306381.0
2018-01-23	FGBX	Futures	167.08	168.25	167.06	167.51	40924.0
2018-01-23	FMWO	Futures	7346.0	7361.2	7343.7	7353.0	2318.0
2018-01-23	FOAT	Futures	137.52	137.96	137.5	137.59	96926.0
2018-01-23	FTDX	Futures	2699.0	2716.9	2678.0	2693.5	231.0
2018-01-23	FTI	Futures	531.25	531.67	527.35	528.6	19047.0
2018-01-23	FTUK	Futures	6708.7	6720.1	6688.6	6706.5	93400.0
2018-01-23	FVSA	Futures	244.33	247.77	243.47	246.05	11040.0
2018-01-23	FXXP	Futures	343.3	343.5	341.5	342.0	39336.0
2018-01-23	G	Futures	113.91	114.16	113.8	113.83	200192.0
2018-01-23	GF	Futures	320.831	323.905	318.745	322.752	5099.0
2018-01-23	GSCI	Futures	523.93	528.14	523.93	525.83	97.0

> showing 50 of 111 rows — these rows as CSV

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