PREVIEW / futures_daily / 2018-01-19

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-19.parquet
  size:    10 KB
  rows:    112

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-19	ES	Futures	3040.0	3059.56	3034.29	3055.22	1363990.0
2018-01-19	NQ	Futures	7983.35	8030.78	7965.78	8017.6	324203.0
2018-01-19	YM	Futures	27360.7	27510.5	27289.0	27468.3	166335.0
2018-01-19	CL	Futures	63.66	63.71	62.76	63.29	674501.0
2018-01-19	GC	Futures	1682.3	1696.5	1681.8	1690.1	275299.0
2018-01-19	ZN	Futures	120.818222	120.941632	120.555976	120.725665	1617134.0
2018-01-19	A6	Futures	0.82281	0.82672	0.82096	0.82281	94133.0
2018-01-19	AD	Futures	0.81843	0.81935	0.81219	0.81402	55766.0
2018-01-19	B	Futures	49.41	49.46	48.89	49.13	278360.0
2018-01-19	B6	Futures	1.4481	1.4531	1.442	1.4457	113563.0
2018-01-19	BFX	Futures	4929.2	4953.6	4929.2	4953.6	7.0
2018-01-19	BR	Futures	0.23575	0.23605	0.23533	0.23605	120.0
2018-01-19	BTC	Futures	14516.8	15406.9	14075.0	14548.9	979.0
2018-01-19	BZ	Futures	48.83	48.84	48.22	48.46	22077.0
2018-01-19	C	Futures	1275.0	1278.0	1250.0	1262.0	9663.0
2018-01-19	CB	Futures	269.943	269.943	268.831	268.862	35.0
2018-01-19	CC	Futures	1470.0	1470.0	1430.0	1441.0	26447.0
2018-01-19	CNH	Futures	6.5418	6.5494	6.536	6.5457	31.0
2018-01-19	CSC	Futures	3.157	3.174	3.133	3.152	87.0
2018-01-19	CT	Futures	96.39	97.83	96.19	97.43	19303.0
2018-01-19	DC	Futures	25.07	25.13	24.7	25.05	226.0
2018-01-19	DX	Futures	84.82	84.998	84.482	84.867	24171.0
2018-01-19	E1	Futures	1.27158	1.27813	1.26345	1.26709	28481.0
2018-01-19	E6	Futures	1.39266	1.39861	1.38942	1.39158	236184.0
2018-01-19	E7	Futures	1.3855	1.3916	1.3826	1.3846	6355.0
2018-01-19	EBM	Futures	168.04	168.04	166.96	167.5	8421.0
2018-01-19	ED	Futures	95.3213	95.3213	95.3116	95.3165	318257.0
2018-01-19	ER	Futures	98.332	98.337	98.332	98.337	31824.0
2018-01-19	EW	Futures	2076.1	2103.1	2072.9	2101.3	15661.0
2018-01-19	FBON	Futures	126.28	126.86	126.22	126.78	429.0
2018-01-19	FBTP	Futures	111.21	111.76	111.16	111.69	94679.0
2018-01-19	FBTS	Futures	103.576	103.622	103.576	103.604	41551.0
2018-01-19	FCE	Futures	4896.9	4933.9	4888.4	4925.4	67630.0
2018-01-19	FDAX	Futures	13755.9	13973.2	13748.1	13932.2	85242.0
2018-01-19	FDXM	Futures	13778.2	13998.5	13770.9	13955.9	30631.0
2018-01-19	FESX	Futures	2946.6	2981.8	2945.0	2972.8	1028582.0
2018-01-19	FGBL	Futures	148.68	149.07	148.57	148.9	530199.0
2018-01-19	FGBM	Futures	128.9	129.11	128.86	129.05	497034.0
2018-01-19	FGBS	Futures	112.296	112.342	112.286	112.336	321561.0
2018-01-19	FGBX	Futures	166.77	167.43	166.29	166.89	48647.0
2018-01-19	FMWO	Futures	7257.3	7287.6	7257.3	7272.5	1974.0
2018-01-19	FOAT	Futures	137.38	137.73	137.29	137.54	78159.0
2018-01-19	FTDX	Futures	2677.5	2702.9	2676.5	2692.5	185.0
2018-01-19	FTI	Futures	524.6	528.74	523.86	527.3	26841.0
2018-01-19	FTUK	Futures	6679.0	6714.0	6668.1	6704.4	96439.0
2018-01-19	FVSA	Futures	255.51	258.09	250.35	254.65	18632.0
2018-01-19	FXXP	Futures	338.7	341.0	338.5	340.4	37590.0
2018-01-19	G	Futures	113.88	114.19	113.81	113.99	171704.0
2018-01-19	GF	Futures	323.795	324.729	318.196	319.733	6321.0
2018-01-19	GSCI	Futures	519.71	522.6	519.71	520.52	76.0

> showing 50 of 112 rows — these rows as CSV

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