PREVIEW / futures_daily / 2018-08-15

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-15.parquet
  size:    10 KB
  rows:    114

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-08-15	ES	Futures	3086.42	3087.78	3044.33	3064.15	1871800.0
2018-08-15	NQ	Futures	8698.21	8703.17	8530.32	8597.36	521164.0
2018-08-15	YM	Futures	26677.4	26677.4	26294.9	26539.4	222573.0
2018-08-15	CL	Futures	68.66	68.98	66.59	67.14	291030.0
2018-08-15	GC	Futures	1522.8	1523.4	1495.6	1501.9	377682.0
2018-08-15	ZN	Futures	119.401303	119.898549	119.385764	119.774237	1829448.0
2018-08-15	A6	Futures	0.74465	0.74547	0.74084	0.74444	110247.0
2018-08-15	AD	Futures	0.77594	0.7765	0.7691	0.77128	61329.0
2018-08-15	B	Futures	52.65	52.81	51.25	51.58	298105.0
2018-08-15	B6	Futures	1.3141	1.3155	1.308	1.3112	100676.0
2018-08-15	BR	Futures	0.19649	0.19649	0.19363	0.19489	4905.0
2018-08-15	BTC	Futures	8697.2	9402.4	8654.4	9081.8	6993.0
2018-08-15	BZ	Futures	52.54	52.73	51.18	51.51	25245.0
2018-08-15	C	Futures	1458.0	1497.0	1456.0	1460.0	3878.0
2018-08-15	CB	Futures	286.825	288.444	283.646	285.445	80.0
2018-08-15	CC	Futures	1504.0	1533.0	1490.0	1495.0	22533.0
2018-08-15	CNH	Futures	6.9784	7.0326	6.9742	7.0219	558.0
2018-08-15	CSC	Futures	3.301	3.303	3.284	3.292	36.0
2018-08-15	CT	Futures	92.58	92.58	90.98	90.98	5.0
2018-08-15	DC	Futures	26.81	26.91	26.66	26.69	230.0
2018-08-15	DX	Futures	91.443	91.741	91.424	91.468	19018.0
2018-08-15	E1	Futures	1.20564	1.20719	1.20002	1.20684	29580.0
2018-08-15	E6	Futures	1.2717	1.27287	1.26683	1.27187	289694.0
2018-08-15	E7	Futures	1.2656	1.2664	1.2603	1.2654	3817.0
2018-08-15	EBM	Futures	213.94	214.73	212.11	214.2	12834.0
2018-08-15	ED	Futures	95.0594	95.0838	95.0594	95.0813	356345.0
2018-08-15	ER	Futures	98.362	98.367	98.357	98.362	68414.0
2018-08-15	EW	Futures	2125.5	2125.5	2086.7	2102.7	13615.0
2018-08-15	FBON	Futures	129.03	129.24	128.84	128.91	138.0
2018-08-15	FBTP	Futures	104.6	105.2	103.49	103.68	70355.0
2018-08-15	FBTS	Futures	101.557	101.826	101.279	101.399	38642.0
2018-08-15	FCE	Futures	4882.4	4882.4	4757.6	4779.2	103727.0
2018-08-15	FDAX	Futures	12939.1	12990.4	12653.8	12678.9	106702.0
2018-08-15	FDXM	Futures	12772.8	12823.4	12492.1	12516.9	53770.0
2018-08-15	FESX	Futures	2855.6	2858.1	2786.2	2792.1	1235580.0
2018-08-15	FGBL	Futures	153.9	154.36	153.68	154.26	506862.0
2018-08-15	FGBM	Futures	131.43	131.63	131.36	131.59	336349.0
2018-08-15	FGBS	Futures	112.718	112.764	112.708	112.754	339736.0
2018-08-15	FGBX	Futures	179.54	180.58	178.86	180.34	32774.0
2018-08-15	FMWO	Futures	7110.2	7110.2	7008.9	7022.9	4672.0
2018-08-15	FOAT	Futures	141.08	141.36	141.03	141.34	65843.0
2018-08-15	FTDX	Futures	2861.3	2864.7	2775.0	2781.3	309.0
2018-08-15	FTI	Futures	521.45	521.5	510.18	512.08	43870.0
2018-08-15	FTUK	Futures	6784.4	6794.7	6638.3	6644.6	136083.0
2018-08-15	FVSA	Futures	278.72	302.24	276.98	297.02	21542.0
2018-08-15	FXXP	Futures	333.2	333.4	326.3	326.8	41507.0
2018-08-15	G	Futures	115.8	116.27	115.74	116.18	206095.0
2018-08-15	GF	Futures	308.193	312.718	308.193	310.273	3737.0
2018-08-15	GSCI	Futures	507.02	508.6	500.99	502.01	129.0
2018-08-15	HE	Futures	70.178	71.43	69.399	71.058	14651.0

> showing 50 of 114 rows — these rows as CSV

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