PREVIEW / futures_daily / 2016-12-20

all futures daily files

  file:    by_date/futures_daily/2016/2016-12-20.parquet
  size:    9 KB
  rows:    108

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
2016-12-20	ES	Futures	2450.34	2460.36	2450.07	2457.11	814005.0
2016-12-20	NQ	Futures	5821.73	5849.73	5820.56	5841.18	109979.0
2016-12-20	YM	Futures	20895.3	20995.4	20890.0	20959.6	81800.0
2016-12-20	CL	Futures	56.87	57.54	56.55	57.04	416592.0
2016-12-20	GC	Futures	1463.7	1466.2	1447.7	1455.8	146050.0
2016-12-20	ZN	Futures	120.575236	120.651647	120.208468	120.422416	804891.0
2016-12-20	A6	Futures	0.74064	0.74227	0.73818	0.74125	64214.0
2016-12-20	AD	Futures	0.76264	0.7654	0.76121	0.76473	43011.0
2016-12-20	ALI	Futures	2355.87	2355.87	2355.87	2355.87	0.0
2016-12-20	B	Futures	40.99	41.66	40.79	41.24	257022.0
2016-12-20	B6	Futures	1.3028	1.3046	1.2944	1.3002	85174.0
2016-12-20	BR	Futures	0.2096	0.2096	0.20843	0.20843	69.0
2016-12-20	BZ	Futures	40.76	41.35	40.49	40.93	37241.0
2016-12-20	C	Futures	1923.0	1934.0	1904.0	1912.0	9007.0
2016-12-20	CB	Futures	273.714	274.05	273.714	274.05	56.0
2016-12-20	CC	Futures	1744.0	1746.0	1711.0	1717.0	10741.0
2016-12-20	CNH	Futures	7.4709	7.4749	7.436	7.436	16.0
2016-12-20	CSC	Futures	4.091	4.091	4.068	4.082	37.0
2016-12-20	CT	Futures	79.88	80.23	79.63	79.65	13748.0
2016-12-20	DC	Futures	33.38	33.53	33.26	33.32	154.0
2016-12-20	DX	Futures	95.986	96.484	95.879	96.17	29634.0
2016-12-20	E1	Futures	1.21298	1.21471	1.20777	1.21186	16207.0
2016-12-20	E6	Futures	1.20671	1.20867	1.20105	1.20538	148136.0
2016-12-20	E7	Futures	1.2007	1.2023	1.1949	1.1992	3052.0
2016-12-20	EBM	Futures	191.42	191.99	190.28	191.42	13616.0
2016-12-20	ED	Futures	95.5713	95.581	95.5665	95.5762	204271.0
2016-12-20	ER	Futures	98.283	98.283	98.279	98.283	34684.0
2016-12-20	EW	Futures	1787.0	1798.1	1785.6	1795.6	10156.0
2016-12-20	FBON	Futures	122.66	123.23	122.36	123.06	634.0
2016-12-20	FBTP	Futures	106.91	107.01	106.38	106.78	60905.0
2016-12-20	FBTS	Futures	101.819	101.855	101.782	101.837	19027.0
2016-12-20	FCE	Futures	4236.6	4263.4	4230.0	4260.3	66417.0
2016-12-20	FDAX	Futures	12050.4	12114.8	12043.0	12106.4	58201.0
2016-12-20	FDXM	Futures	11999.2	12063.4	11992.9	12057.6	12341.0
2016-12-20	FESX	Futures	2595.1	2615.1	2591.1	2614.3	686811.0
2016-12-20	FGBL	Futures	147.18	147.26	146.86	147.04	419382.0
2016-12-20	FGBM	Futures	128.98	128.99	128.83	128.85	320751.0
2016-12-20	FGBS	Futures	112.202	112.207	112.157	112.167	116286.0
2016-12-20	FGBX	Futures	170.29	170.92	169.36	169.99	23254.0
2016-12-20	FMWO	Futures	5884.0	5898.5	5880.4	5893.6	256.0
2016-12-20	FOAT	Futures	133.39	133.71	133.27	133.47	67662.0
2016-12-20	FTDX	Futures	1749.9	1756.3	1749.9	1751.9	134.0
2016-12-20	FTI	Futures	437.28	440.47	436.96	440.37	22033.0
2016-12-20	FTUK	Futures	5893.9	5922.8	5877.4	5918.9	66223.0
2016-12-20	FVSA	Futures	1071.54	1074.28	1041.39	1052.35	28921.0
2016-12-20	FXXP	Futures	296.8	298.3	296.3	298.2	21655.0
2016-12-20	G	Futures	110.37	110.69	110.08	110.43	91624.0
2016-12-20	GF	Futures	291.789	293.462	288.554	290.004	5815.0
2016-12-20	GSCI	Futures	520.25	521.58	518.66	518.73	186.0
2016-12-20	HE	Futures	89.033	89.811	86.059	86.532	19463.0

> showing 50 of 108 rows — these rows as CSV

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