PREVIEW / futures_daily / 2018-04-19

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-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-04-19	ES	Futures	2948.94	2950.57	2916.05	2928.55	1577913.0
2018-04-19	NQ	Futures	8023.61	8036.49	7906.57	7935.54	376428.0
2018-04-19	YM	Futures	26063.2	26104.3	25823.1	25952.6	192290.0
2018-04-19	CL	Futures	68.98	69.8	68.25	68.58	860388.0
2018-04-19	GC	Futures	1726.6	1733.3	1714.8	1722.0	342542.0
2018-04-19	ZN	Futures	119.245488	119.307522	118.826756	118.935316	1531393.0
2018-04-19	A6	Futures	0.8007	0.80337	0.7937	0.79422	117153.0
2018-04-19	AD	Futures	0.80225	0.80478	0.79896	0.79937	77192.0
2018-04-19	B	Futures	53.59	54.33	53.4	53.63	393964.0
2018-04-19	B6	Futures	1.4748	1.4788	1.4603	1.4613	152695.0
2018-04-19	BFX	Futures	4458.4	4472.9	4458.4	4465.3	20.0
2018-04-19	BR	Futures	0.22407	0.22407	0.22315	0.22403	143.0
2018-04-19	BTC	Futures	11631.1	11808.6	11503.3	11730.5	2718.0
2018-04-19	BZ	Futures	52.92	53.62	52.71	52.93	37579.0
2018-04-19	C	Futures	1720.0	1726.0	1705.0	1716.0	4568.0
2018-04-19	CB	Futures	295.887	296.504	295.887	296.504	15.0
2018-04-19	CC	Futures	2036.0	2065.0	2025.0	2041.0	18586.0
2018-04-19	CNH	Futures	6.3623	6.3817	6.3563	6.3817	126.0
2018-04-19	CSC	Futures	3.419	3.429	3.417	3.419	29.0
2018-04-19	CT	Futures	95.07	95.59	94.9	95.37	3536.0
2018-04-19	DC	Futures	27.5	27.71	27.5	27.55	130.0
2018-04-19	DX	Futures	84.274	84.608	84.16	84.594	24763.0
2018-04-19	E1	Futures	1.24934	1.25187	1.24428	1.24465	29164.0
2018-04-19	E6	Futures	1.40034	1.40282	1.3946	1.39561	214391.0
2018-04-19	E7	Futures	1.3929	1.3953	1.3871	1.3882	2962.0
2018-04-19	EBM	Futures	177.2	177.47	175.86	176.13	13123.0
2018-04-19	ED	Futures	94.9306	94.9403	94.9257	94.9257	267621.0
2018-04-19	ER	Futures	98.342	98.342	98.337	98.337	33307.0
2018-04-19	EW	Futures	2040.2	2042.9	2017.8	2027.1	11744.0
2018-04-19	FBON	Futures	130.04	130.04	129.53	129.56	653.0
2018-04-19	FBTP	Futures	116.24	116.35	115.7	115.77	118900.0
2018-04-19	FBTS	Futures	104.26	104.269	104.186	104.223	45404.0
2018-04-19	FCE	Futures	4751.3	4760.2	4740.6	4754.4	93340.0
2018-04-19	FDAX	Futures	13099.3	13124.2	13024.4	13069.6	88423.0
2018-04-19	FDXM	Futures	12980.0	13005.8	12909.0	12953.3	25063.0
2018-04-19	FESX	Futures	2847.3	2851.4	2830.6	2842.3	870924.0
2018-04-19	FEU3	Futures	99.03	99.03	99.021	99.026	2.0
2018-04-19	FGBL	Futures	149.65	149.66	148.74	148.84	1096285.0
2018-04-19	FGBM	Futures	129.57	129.58	129.26	129.32	773967.0
2018-04-19	FGBS	Futures	112.487	112.492	112.452	112.467	463021.0
2018-04-19	FGBX	Futures	170.14	170.22	168.36	168.61	74224.0
2018-04-19	FMWO	Futures	7054.2	7054.2	6986.5	7021.5	1966.0
2018-04-19	FOAT	Futures	138.89	138.91	138.11	138.19	139437.0
2018-04-19	FTDX	Futures	2646.9	2646.9	2603.3	2609.7	63.0
2018-04-19	FTI	Futures	506.01	506.19	500.65	503.14	17473.0
2018-04-19	FTUK	Futures	6422.2	6451.3	6397.9	6427.5	100076.0
2018-04-19	FVSA	Futures	334.09	359.34	329.49	351.31	34757.0
2018-04-19	FXXP	Futures	325.6	326.0	324.1	325.5	30524.0
2018-04-19	G	Futures	113.72	113.72	112.8	112.94	312294.0
2018-04-19	GF	Futures	302.356	302.84	297.138	297.891	6932.0

> showing 50 of 112 rows — these rows as CSV

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