PREVIEW / futures_daily / 2018-11-20

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-20.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-11-20	ES	Futures	2924.11	2924.66	2854.16	2863.11	2533128.0
2018-11-20	NQ	Futures	7745.63	7747.38	7491.26	7587.67	910469.0
2018-11-20	YM	Futures	26353.5	26370.3	25646.9	25733.2	338527.0
2018-11-20	CL	Futures	60.72	60.77	55.83	56.53	983120.0
2018-11-20	GC	Futures	1552.1	1558.3	1546.6	1547.8	255195.0
2018-11-20	ZN	Futures	118.763621	118.965944	118.716931	118.872564	2225246.0
2018-11-20	A6	Futures	0.75041	0.75144	0.74228	0.74301	118189.0
2018-11-20	AD	Futures	0.76799	0.769	0.75955	0.75975	90384.0
2018-11-20	B	Futures	49.45	49.45	45.61	46.22	417010.0
2018-11-20	B6	Futures	1.324	1.3265	1.3155	1.3164	93787.0
2018-11-20	BR	Futures	0.20258	0.20418	0.20113	0.20174	1704.0
2018-11-20	BTC	Futures	6861.4	7049.6	5811.9	6137.6	12827.0
2018-11-20	BZ	Futures	49.12	49.15	45.34	45.9	44030.0
2018-11-20	C	Futures	1474.0	1474.0	1459.0	1461.0	1825.0
2018-11-20	CB	Futures	267.962	267.962	266.641	266.761	8.0
2018-11-20	CC	Futures	1507.0	1527.0	1496.0	1509.0	17536.0
2018-11-20	CNH	Futures	6.9759	6.9857	6.9752	6.9838	551.0
2018-11-20	CSC	Futures	2.93	2.944	2.906	2.912	130.0
2018-11-20	CT	Futures	85.07	85.52	84.43	84.49	10575.0
2018-11-20	DC	Futures	24.46	24.46	24.03	24.13	647.0
2018-11-20	DX	Futures	91.289	91.93	91.132	91.878	19072.0
2018-11-20	E1	Futures	1.19604	1.19876	1.19295	1.1939	27496.0
2018-11-20	E6	Futures	1.27578	1.27806	1.26538	1.26644	197119.0
2018-11-20	E7	Futures	1.2698	1.2718	1.2591	1.2603	3693.0
2018-11-20	EBM	Futures	205.08	206.9	204.56	206.64	26045.0
2018-11-20	ED	Futures	94.9963	94.9987	94.9914	94.9939	281087.0
2018-11-20	ER	Futures	98.381	98.386	98.381	98.386	25011.0
2018-11-20	EW	Futures	1938.0	1938.9	1892.6	1901.6	21264.0
2018-11-20	FBON	Futures	126.75	126.89	126.64	126.85	561.0
2018-11-20	FBTP	Futures	103.39	103.86	102.68	103.57	109549.0
2018-11-20	FBTS	Futures	102.162	102.359	101.937	102.284	76029.0
2018-11-20	FCE	Futures	4431.5	4440.5	4366.6	4394.8	105865.0
2018-11-20	FDAX	Futures	11765.6	11772.9	11569.0	11633.1	145062.0
2018-11-20	FDIV	Futures	136.43	136.43	136.25	136.25	2.0
2018-11-20	FDXM	Futures	11559.8	11569.1	11368.6	11431.6	72281.0
2018-11-20	FESX	Futures	2637.8	2642.0	2597.4	2610.9	1538606.0
2018-11-20	FGBL	Futures	153.74	154.12	153.64	153.98	777260.0
2018-11-20	FGBM	Futures	131.38	131.48	131.33	131.43	380448.0
2018-11-20	FGBS	Futures	112.724	112.749	112.713	112.734	262231.0
2018-11-20	FGBX	Futures	177.84	179.19	177.67	178.87	59359.0
2018-11-20	FMWO	Futures	6660.0	6664.7	6543.0	6584.7	3733.0
2018-11-20	FOAT	Futures	140.42	140.71	140.37	140.65	136095.0
2018-11-20	FTDX	Futures	2443.8	2451.2	2387.8	2435.5	487.0
2018-11-20	FTI	Futures	479.63	480.28	470.12	473.53	31628.0
2018-11-20	FTUK	Futures	6240.2	6259.0	6163.8	6208.1	130051.0
2018-11-20	FVSA	Futures	344.73	365.9	342.72	356.83	61355.0
2018-11-20	FXXP	Futures	306.5	306.5	302.0	303.7	85554.0
2018-11-20	G	Futures	115.68	115.92	115.48	115.67	276109.0
2018-11-20	GF	Futures	316.486	317.024	314.656	316.163	2754.0
2018-11-20	GSCI	Futures	475.48	475.48	470.57	471.59	57.0

> showing 50 of 114 rows — these rows as CSV

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