PREVIEW / futures_daily / 2018-07-12

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-12.parquet
  size:    10 KB
  rows:    113

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-07-12	ES	Futures	3015.82	3042.16	3012.56	3039.44	1120424.0
2018-07-12	NQ	Futures	8464.16	8612.52	8452.21	8607.56	304341.0
2018-07-12	YM	Futures	26036.7	26265.4	26005.1	26230.6	168031.0
2018-07-12	CL	Futures	71.51	72.16	70.12	71.24	707887.0
2018-07-12	GC	Futures	1586.0	1594.3	1584.9	1591.5	220956.0
2018-07-12	ZN	Futures	119.510075	119.58777	119.354686	119.494536	998978.0
2018-07-12	A6	Futures	0.7574	0.76316	0.75668	0.76151	76640.0
2018-07-12	AD	Futures	0.76733	0.77103	0.76713	0.76981	54443.0
2018-07-12	B	Futures	54.71	55.4	53.6	54.92	416412.0
2018-07-12	B6	Futures	1.3661	1.3701	1.3635	1.3665	86507.0
2018-07-12	BR	Futures	0.19626	0.19721	0.19435	0.19447	121.0
2018-07-12	BTC	Futures	9053.3	9067.6	8704.3	8775.5	3076.0
2018-07-12	BZ	Futures	54.13	55.12	53.32	54.62	46443.0
2018-07-12	C	Futures	1721.0	1734.0	1707.0	1726.0	5831.0
2018-07-12	CB	Futures	268.685	271.053	268.685	270.933	16.0
2018-07-12	CC	Futures	1770.0	1786.0	1754.0	1781.0	14938.0
2018-07-12	CNH	Futures	6.8247	6.8247	6.7583	6.7625	37.0
2018-07-12	CSC	Futures	3.2	3.24	3.2	3.234	151.0
2018-07-12	CT	Futures	96.64	100.13	96.64	100.13	44.0
2018-07-12	DC	Futures	25.33	25.7	25.33	25.65	128.0
2018-07-12	DX	Futures	89.487	89.705	89.406	89.562	14680.0
2018-07-12	E1	Futures	1.20648	1.20755	1.19799	1.19847	28655.0
2018-07-12	E6	Futures	1.31185	1.31414	1.30894	1.31134	169174.0
2018-07-12	E7	Futures	1.3052	1.3074	1.3023	1.3047	2482.0
2018-07-12	EBM	Futures	187.79	191.45	187.27	189.88	20849.0
2018-07-12	ED	Futures	94.9815	94.9815	94.9718	94.9767	163366.0
2018-07-12	ER	Futures	98.367	98.367	98.362	98.367	17523.0
2018-07-12	EW	Futures	2113.2	2124.6	2104.9	2117.4	11828.0
2018-07-12	FBON	Futures	129.32	129.4	129.07	129.4	365.0
2018-07-12	FBTP	Futures	108.04	108.48	107.68	108.24	63473.0
2018-07-12	FBTS	Futures	102.698	102.716	102.438	102.605	29188.0
2018-07-12	FCE	Futures	4810.5	4856.3	4805.6	4847.3	529.0
2018-07-12	FDAX	Futures	13014.4	13069.8	12954.8	13044.2	80539.0
2018-07-12	FDXM	Futures	12849.2	12904.9	12790.4	12877.6	27361.0
2018-07-12	FESX	Futures	2856.4	2878.1	2848.0	2871.4	826972.0
2018-07-12	FGBL	Futures	153.17	153.42	153.07	153.37	412717.0
2018-07-12	FGBM	Futures	131.13	131.22	131.07	131.19	286004.0
2018-07-12	FGBS	Futures	112.703	112.718	112.693	112.713	169368.0
2018-07-12	FGBX	Futures	177.94	178.42	177.52	178.3	30981.0
2018-07-12	FMWO	Futures	7063.6	7102.0	7061.3	7086.9	1284.0
2018-07-12	FOAT	Futures	141.31	141.46	141.15	141.44	78444.0
2018-07-12	FTDX	Futures	2759.8	2769.1	2751.4	2766.1	43.0
2018-07-12	FTI	Futures	509.1	511.96	508.22	511.36	115.0
2018-07-12	FTUK	Futures	6705.2	6783.6	6705.2	6764.8	71216.0
2018-07-12	FVSA	Futures	281.84	286.62	276.11	279.93	13590.0
2018-07-12	FXXP	Futures	329.2	332.0	328.5	331.4	52432.0
2018-07-12	G	Futures	115.34	115.57	115.3	115.54	128258.0
2018-07-12	GF	Futures	310.425	314.205	310.373	312.859	7705.0
2018-07-12	GSCI	Futures	517.73	519.59	514.57	519.47	2003.0
2018-07-12	HE	Futures	77.445	79.172	77.166	78.476	28284.0

> showing 50 of 113 rows — these rows as CSV

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