PREVIEW / futures_daily / 2018-01-26

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-26.parquet
  size:    9 KB
  rows:    110

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-26	ES	Futures	3089.18	3125.86	3088.09	3124.23	1286287.0
2018-01-26	NQ	Futures	8125.64	8238.66	8121.25	8233.69	326274.0
2018-01-26	YM	Futures	27821.6	28061.0	27821.6	28056.8	145941.0
2018-01-26	CL	Futures	65.23	66.33	64.89	66.12	678186.0
2018-01-26	GC	Futures	1727.9	1738.5	1722.6	1733.6	142268.0
2018-01-26	ZN	Futures	120.879927	120.895353	120.432566	120.509697	1484833.0
2018-01-26	A6	Futures	0.82353	0.8368	0.82332	0.83515	141489.0
2018-01-26	AD	Futures	0.82021	0.82635	0.81975	0.82457	82772.0
2018-01-26	B	Futures	50.01	50.55	49.96	50.34	232715.0
2018-01-26	B6	Futures	1.4706	1.4885	1.4705	1.4752	178324.0
2018-01-26	BR	Futures	0.2422	0.24232	0.24	0.24034	11662.0
2018-01-26	BTC	Futures	14391.6	15120.3	13337.6	14268.0	573.0
2018-01-26	BZ	Futures	49.25	49.88	49.25	49.68	25532.0
2018-01-26	C	Futures	1244.0	1270.0	1231.0	1263.0	10263.0
2018-01-26	CB	Futures	267.472	268.275	265.989	266.854	29.0
2018-01-26	CC	Futures	1460.0	1491.0	1455.0	1482.0	20215.0
2018-01-26	CNH	Futures	6.4856	6.4865	6.4628	6.4685	88.0
2018-01-26	CSC	Futures	3.125	3.137	3.125	3.127	21.0
2018-01-26	CT	Futures	95.61	95.75	93.81	94.0	26965.0
2018-01-26	DC	Futures	24.85	25.02	24.81	24.87	66.0
2018-01-26	DX	Futures	83.74	83.749	83.171	83.478	33158.0
2018-01-26	E1	Futures	1.29258	1.30666	1.29234	1.30278	49916.0
2018-01-26	E6	Futures	1.40734	1.4206	1.40688	1.41255	332212.0
2018-01-26	E7	Futures	1.4001	1.4133	1.4001	1.4055	8775.0
2018-01-26	EBM	Futures	168.84	169.92	168.84	169.65	16498.0
2018-01-26	ED	Futures	95.3116	95.3165	95.297	95.3019	333192.0
2018-01-26	ER	Futures	98.332	98.337	98.332	98.332	43873.0
2018-01-26	EW	Futures	2107.8	2117.8	2098.9	2116.6	10820.0
2018-01-26	FBON	Futures	127.08	127.4	126.85	127.01	509.0
2018-01-26	FBTP	Futures	111.77	111.78	111.22	111.34	140694.0
2018-01-26	FBTS	Futures	103.64	103.659	103.558	103.595	61608.0
2018-01-26	FCE	Futures	4901.3	4950.8	4894.2	4928.1	62240.0
2018-01-26	FDAX	Futures	13815.0	13886.6	13755.9	13829.0	64211.0
2018-01-26	FDXM	Futures	13839.5	13910.1	13779.2	13852.5	20403.0
2018-01-26	FESX	Futures	2964.6	2987.5	2958.1	2972.0	694821.0
2018-01-26	FGBL	Futures	148.43	148.62	148.05	148.09	752799.0
2018-01-26	FGBM	Futures	128.63	128.7	128.41	128.45	810284.0
2018-01-26	FGBS	Futures	112.286	112.296	112.231	112.246	461069.0
2018-01-26	FGBX	Futures	167.78	168.91	167.51	167.84	85513.0
2018-01-26	FMWO	Futures	7372.8	7421.9	7371.7	7390.4	992.0
2018-01-26	FOAT	Futures	137.23	137.4	136.76	136.81	115623.0
2018-01-26	FTDX	Futures	2628.1	2668.0	2598.7	2655.1	361.0
2018-01-26	FTI	Futures	524.33	527.3	522.84	525.16	18329.0
2018-01-26	FTUK	Futures	6623.1	6677.3	6611.3	6649.3	84043.0
2018-01-26	FVSA	Futures	249.49	252.93	246.91	251.21	11119.0
2018-01-26	FXXP	Futures	339.1	341.3	338.6	340.1	55663.0
2018-01-26	G	Futures	113.36	113.55	113.0	113.09	182923.0
2018-01-26	GF	Futures	316.0	323.85	314.572	322.203	6452.0
2018-01-26	GSCI	Futures	530.22	536.52	530.22	535.53	143.0
2018-01-26	HE	Futures	94.829	95.503	94.09	94.765	13911.0

> showing 50 of 110 rows — these rows as CSV

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