PREVIEW / futures_daily / 2016-12-29

all futures daily files

  file:    by_date/futures_daily/2016/2016-12-29.parquet
  size:    9 KB
  rows:    109

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-29	ES	Futures	2434.35	2439.22	2427.84	2433.8	913220.0
2016-12-29	NQ	Futures	5803.17	5814.66	5776.65	5796.98	121556.0
2016-12-29	YM	Futures	20833.2	20873.2	20780.5	20812.1	86353.0
2016-12-29	CL	Futures	57.42	58.01	57.21	57.54	360194.0
2016-12-29	GC	Futures	1468.0	1490.4	1467.3	1487.2	158029.0
2016-12-29	ZN	Futures	120.926723	121.35462	120.896159	121.217082	766254.0
2016-12-29	A6	Futures	0.73418	0.73849	0.73377	0.73685	52077.0
2016-12-29	AD	Futures	0.75426	0.75845	0.75401	0.75763	42178.0
2016-12-29	ALI	Futures	2310.0	2310.0	2310.0	2310.0	0.0
2016-12-29	B	Futures	42.26	42.71	42.21	42.35	229913.0
2016-12-29	B6	Futures	1.2844	1.2895	1.2827	1.2875	70110.0
2016-12-29	BR	Futures	0.21394	0.21565	0.21394	0.21536	84.0
2016-12-29	BZ	Futures	41.94	42.38	41.79	42.04	21420.0
2016-12-29	C	Futures	1871.0	1876.0	1825.0	1832.0	12963.0
2016-12-29	CB	Futures	276.461	278.322	274.233	278.322	10.0
2016-12-29	CC	Futures	1679.0	1681.0	1631.0	1648.0	11235.0
2016-12-29	CNH	Futures	7.4911	7.4985	7.4702	7.4702	54.0
2016-12-29	CSC	Futures	4.061	4.061	4.05	4.052	16.0
2016-12-29	CT	Futures	80.13	81.72	80.0	80.99	13997.0
2016-12-29	DC	Futures	33.44	33.57	33.21	33.34	100.0
2016-12-29	DX	Futures	96.084	96.098	95.576	95.633	31939.0
2016-12-29	E1	Futures	1.21087	1.21942	1.21037	1.2157	15513.0
2016-12-29	E6	Futures	1.20786	1.21635	1.20711	1.21525	139611.0
2016-12-29	E7	Futures	1.2012	1.21	1.2008	1.209	6676.0
2016-12-29	EBM	Futures	189.71	191.99	189.43	191.42	5625.0
2016-12-29	ED	Futures	95.581	95.5955	95.581	95.5955	153525.0
2016-12-29	ER	Futures	98.283	98.293	98.283	98.293	46812.0
2016-12-29	EW	Futures	1769.7	1778.8	1766.7	1773.9	7908.0
2016-12-29	FBON	Futures	123.21	123.38	123.06	123.29	46.0
2016-12-29	FBTP	Futures	107.18	107.37	106.88	107.25	58687.0
2016-12-29	FBTS	Futures	101.954	101.981	101.891	101.909	16148.0
2016-12-29	FCE	Futures	4251.9	4262.9	4241.0	4256.8	43890.0
2016-12-29	FDAX	Futures	12088.4	12102.7	12047.3	12078.9	39718.0
2016-12-29	FDXM	Futures	12032.9	12051.8	11998.2	12030.3	7242.0
2016-12-29	FESX	Futures	2609.5	2613.5	2599.9	2608.7	409238.0
2016-12-29	FEU3	Futures	98.956	98.961	98.956	98.961	29.0
2016-12-29	FGBL	Futures	148.3	148.49	148.15	148.44	262782.0
2016-12-29	FGBM	Futures	129.33	129.34	129.15	129.24	182262.0
2016-12-29	FGBS	Futures	112.217	112.232	112.162	112.167	158470.0
2016-12-29	FGBX	Futures	173.73	174.2	173.11	174.0	12969.0
2016-12-29	FMWO	Futures	5851.4	5862.3	5851.4	5856.3	673.0
2016-12-29	FOAT	Futures	134.41	134.45	134.06	134.3	33963.0
2016-12-29	FTDX	Futures	1763.6	1778.8	1763.6	1778.8	266.0
2016-12-29	FTI	Futures	439.15	439.56	437.87	438.96	14751.0
2016-12-29	FTUK	Futures	5950.7	5988.5	5946.1	5980.0	52882.0
2016-12-29	FVSA	Futures	1090.72	1104.42	1066.06	1085.24	4302.0
2016-12-29	FXXP	Futures	296.8	298.1	296.3	297.6	22462.0
2016-12-29	G	Futures	112.0	112.64	111.98	112.54	85631.0
2016-12-29	GF	Futures	293.852	294.466	292.179	294.298	2039.0
2016-12-29	GSCI	Futures	530.18	530.18	527.67	527.67	117.0

> showing 50 of 109 rows — these rows as CSV

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