PREVIEW / futures_daily / 2017-01-19

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-19.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
2017-01-19	ES	Futures	2456.03	2460.36	2442.48	2451.69	1386240.0
2017-01-19	NQ	Futures	5955.8	5981.14	5936.06	5956.1	185603.0
2017-01-19	YM	Futures	20779.5	20811.0	20652.0	20743.6	119383.0
2017-01-19	CL	Futures	55.85	56.36	55.44	55.78	577762.0
2017-01-19	GC	Futures	1545.0	1549.3	1535.1	1543.0	247403.0
2017-01-19	ZN	Futures	121.583851	121.751953	121.140672	121.446312	1809571.0
2017-01-19	A6	Futures	0.76849	0.77474	0.76644	0.7729	96194.0
2017-01-19	AD	Futures	0.7704	0.77112	0.76529	0.76729	75461.0
2017-01-19	ALI	Futures	2493.11	2498.25	2470.97	2498.25	162.0
2017-01-19	B	Futures	40.45	40.8	40.16	40.35	346867.0
2017-01-19	B6	Futures	1.2879	1.2965	1.2863	1.2953	95730.0
2017-01-19	BFX	Futures	4371.2	4371.2	4357.2	4357.2	3.0
2017-01-19	BR	Futures	0.21977	0.22041	0.21963	0.22041	9.0
2017-01-19	BZ	Futures	40.16	40.49	39.86	40.05	33327.0
2017-01-19	C	Futures	1864.0	1880.0	1818.0	1823.0	11340.0
2017-01-19	CB	Futures	280.306	280.55	278.902	278.902	26.0
2017-01-19	CC	Futures	1703.0	1712.0	1632.0	1647.0	22882.0
2017-01-19	CNH	Futures	7.2863	7.2887	7.2833	7.2833	143.0
2017-01-19	CSC	Futures	4.018	4.027	4.008	4.02	42.0
2017-01-19	CT	Futures	83.16	84.19	83.02	83.5	13675.0
2017-01-19	DC	Futures	33.0	33.4	33.0	33.32	131.0
2017-01-19	DX	Futures	94.375	94.701	93.998	94.174	53384.0
2017-01-19	E1	Futures	1.23405	1.23764	1.22785	1.23392	25426.0
2017-01-19	E6	Futures	1.23073	1.23593	1.22571	1.23385	241553.0
2017-01-19	E7	Futures	1.2244	1.2295	1.2193	1.2275	5688.0
2017-01-19	EBM	Futures	193.42	193.42	192.28	193.13	10129.0
2017-01-19	ED	Futures	95.5423	95.552	95.523	95.5375	405006.0
2017-01-19	ER	Futures	98.308	98.313	98.308	98.313	43064.0
2017-01-19	EW	Futures	1785.5	1793.8	1766.5	1773.3	18447.0
2017-01-19	FBON	Futures	122.08	122.18	121.75	122.04	582.0
2017-01-19	FBTP	Futures	105.86	105.95	105.47	105.82	112862.0
2017-01-19	FBTS	Futures	101.837	101.846	101.8	101.828	29901.0
2017-01-19	FCE	Futures	4282.7	4286.2	4247.0	4262.4	100615.0
2017-01-19	FDAX	Futures	12276.9	12292.2	12201.4	12236.7	70508.0
2017-01-19	FDXM	Futures	12222.1	12243.2	12153.8	12187.4	21998.0
2017-01-19	FESX	Futures	2636.7	2639.1	2615.1	2623.1	850266.0
2017-01-19	FGBL	Futures	147.0	147.14	146.66	147.03	867913.0
2017-01-19	FGBM	Futures	128.83	128.88	128.73	128.83	663843.0
2017-01-19	FGBS	Futures	112.112	112.127	112.082	112.092	363211.0
2017-01-19	FGBX	Futures	166.14	166.69	165.27	166.0	50258.0
2017-01-19	FMWO	Futures	5952.8	5952.8	5943.1	5946.7	201.0
2017-01-19	FOAT	Futures	132.37	132.5	132.01	132.29	128551.0
2017-01-19	FTDX	Futures	1798.9	1802.9	1790.1	1799.4	139.0
2017-01-19	FTI	Futures	442.24	442.56	438.82	440.6	19853.0
2017-01-19	FTUK	Futures	6100.8	6102.5	6043.2	6052.1	111099.0
2017-01-19	FVSA	Futures	847.9	852.63	824.21	836.05	11930.0
2017-01-19	FXXP	Futures	300.8	300.8	298.7	299.5	24523.0
2017-01-19	G	Futures	111.26	111.38	110.77	111.0	178725.0
2017-01-19	GF	Futures	295.967	297.791	294.314	296.708	3933.0
2017-01-19	GSCI	Futures	522.94	523.87	516.61	520.96	182.0

> showing 50 of 109 rows — these rows as CSV

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