PREVIEW / futures_daily / 2018-11-08

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-08.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-11-08	ES	Futures	3053.71	3056.15	3031.21	3046.12	1317225.0
2018-11-08	NQ	Futures	8377.8	8398.99	8284.0	8323.49	477828.0
2018-11-08	YM	Futures	27570.8	27661.3	27451.8	27589.7	177079.0
2018-11-08	CL	Futures	64.24	65.05	62.95	63.23	764546.0
2018-11-08	GC	Futures	1556.0	1557.0	1547.3	1552.7	239016.0
2018-11-08	ZN	Futures	117.331796	117.534119	117.238416	117.316233	1354498.0
2018-11-08	A6	Futures	0.74877	0.75175	0.74599	0.7463	100968.0
2018-11-08	AD	Futures	0.77148	0.7731	0.76743	0.76764	67639.0
2018-11-08	B	Futures	53.29	54.01	52.15	52.22	350468.0
2018-11-08	B6	Futures	1.3523	1.3546	1.3438	1.3443	114661.0
2018-11-08	BR	Futures	0.2038	0.2046	0.20212	0.2022	3321.0
2018-11-08	BTC	Futures	9423.6	9445.3	9220.9	9278.8	4418.0
2018-11-08	BZ	Futures	52.96	53.63	51.76	51.86	39896.0
2018-11-08	C	Futures	1572.0	1573.0	1516.0	1526.0	7343.0
2018-11-08	CB	Futures	267.031	267.061	264.838	265.559	31.0
2018-11-08	CC	Futures	1646.0	1651.0	1572.0	1579.0	46245.0
2018-11-08	CNH	Futures	6.9631	6.9776	6.9618	6.9776	298.0
2018-11-08	CSC	Futures	2.952	2.952	2.91	2.914	193.0
2018-11-08	CT	Futures	88.75	90.36	88.34	88.69	29323.0
2018-11-08	DC	Futures	24.46	24.56	24.03	24.16	722.0
2018-11-08	DX	Futures	91.194	91.749	91.099	91.721	17933.0
2018-11-08	E1	Futures	1.18632	1.18809	1.18039	1.18075	18223.0
2018-11-08	E6	Futures	1.27405	1.27622	1.26555	1.26616	204363.0
2018-11-08	E7	Futures	1.268	1.27	1.2591	1.2599	4284.0
2018-11-08	EBM	Futures	209.24	210.01	207.16	207.94	23197.0
2018-11-08	ED	Futures	94.9597	94.9694	94.9499	94.9548	252501.0
2018-11-08	ER	Futures	98.386	98.386	98.381	98.386	16438.0
2018-11-08	EW	Futures	2011.9	2013.0	1993.1	2001.1	13938.0
2018-11-08	FBON	Futures	127.21	127.28	126.97	127.21	2066.0
2018-11-08	FBTP	Futures	105.31	105.48	104.89	105.07	61773.0
2018-11-08	FBTS	Futures	102.836	102.883	102.658	102.771	66984.0
2018-11-08	FCE	Futures	4607.9	4626.7	4581.9	4594.0	74514.0
2018-11-08	FDAX	Futures	12213.5	12240.9	12076.3	12096.3	88366.0
2018-11-08	FDXM	Futures	12003.1	12028.9	11867.7	11886.8	39450.0
2018-11-08	FESX	Futures	2726.0	2735.2	2705.0	2708.3	885926.0
2018-11-08	FGBL	Futures	152.44	152.65	152.35	152.52	536074.0
2018-11-08	FGBM	Futures	130.8	130.89	130.77	130.85	269910.0
2018-11-08	FGBS	Futures	112.638	112.648	112.618	112.638	188622.0
2018-11-08	FGBX	Futures	176.16	176.44	175.72	176.2	37124.0
2018-11-08	FMWO	Futures	6952.0	6955.5	6910.3	6931.2	4912.0
2018-11-08	FOAT	Futures	139.75	139.87	139.67	139.81	177007.0
2018-11-08	FTDX	Futures	2660.9	2663.3	2614.7	2615.2	398.0
2018-11-08	FTI	Futures	493.78	494.81	490.51	491.92	22380.0
2018-11-08	FTUK	Futures	6371.2	6392.2	6339.9	6357.7	96057.0
2018-11-08	FVSA	Futures	319.65	320.6	308.23	310.13	53629.0
2018-11-08	FXXP	Futures	319.8	319.9	316.9	317.1	86902.0
2018-11-08	G	Futures	114.02	114.2	113.9	113.95	223572.0
2018-11-08	GF	Futures	311.736	313.192	311.217	312.256	1266.0
2018-11-08	GSCI	Futures	508.98	508.98	504.06	505.15	2543.0
2018-11-08	HE	Futures	74.022	74.827	72.982	74.659	35637.0

> showing 50 of 112 rows — these rows as CSV

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