PREVIEW / futures_daily / 2017-04-05

all futures daily files

  file:    by_date/futures_daily/2017/2017-04-05.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
2017-04-05	ES	Futures	2561.7	2579.35	2545.41	2548.4	1938825.0
2017-04-05	NQ	Futures	6415.42	6455.76	6370.66	6379.2	301129.0
2017-04-05	YM	Futures	21797.7	21977.0	21691.1	21712.2	184153.0
2017-04-05	CL	Futures	53.64	54.38	53.18	53.61	651398.0
2017-04-05	GC	Futures	1609.0	1610.4	1592.6	1596.6	236740.0
2017-04-05	ZN	Futures	122.82966	123.19838	122.660664	122.952567	1479991.0
2017-04-05	A6	Futures	0.77568	0.77783	0.77475	0.77732	79619.0
2017-04-05	AD	Futures	0.76156	0.76309	0.75952	0.76125	59012.0
2017-04-05	ALI	Futures	2582.47	2582.47	2582.47	2582.47	0.0
2017-04-05	B	Futures	39.32	39.95	39.14	39.42	353017.0
2017-04-05	B6	Futures	1.3071	1.3126	1.3047	1.3113	96377.0
2017-04-05	BFX	Futures	4618.3	4618.3	4613.4	4613.4	5.0
2017-04-05	BR	Futures	0.23147	0.23154	0.23096	0.23136	36.0
2017-04-05	BZ	Futures	39.25	39.83	39.04	39.31	33157.0
2017-04-05	C	Futures	1756.0	1765.0	1742.0	1754.0	11658.0
2017-04-05	CB	Futures	267.276	267.276	266.055	266.055	1.0
2017-04-05	CC	Futures	1613.0	1628.0	1601.0	1615.0	25648.0
2017-04-05	CNH	Futures	7.2094	7.2135	7.2084	7.2084	3.0
2017-04-05	CSC	Futures	3.596	3.596	3.558	3.567	54.0
2017-04-05	CT	Futures	83.21	83.81	83.21	83.45	16967.0
2017-04-05	DC	Futures	29.55	29.79	29.23	29.31	243.0
2017-04-05	DX	Futures	93.553	94.089	93.451	93.577	26548.0
2017-04-05	E1	Futures	1.23885	1.23946	1.23057	1.23502	22507.0
2017-04-05	E6	Futures	1.23423	1.23543	1.22881	1.23279	184581.0
2017-04-05	E7	Futures	1.2279	1.2291	1.2228	1.2266	3341.0
2017-04-05	EBM	Futures	183.98	184.82	183.42	183.7	13176.0
2017-04-05	ED	Futures	95.5542	95.5639	95.5494	95.5542	260625.0
2017-04-05	ER	Futures	98.332	98.332	98.323	98.328	50016.0
2017-04-05	EW	Futures	1817.0	1830.1	1794.2	1799.5	24187.0
2017-04-05	FBON	Futures	122.35	122.42	122.11	122.28	231.0
2017-04-05	FBTP	Futures	105.32	105.36	105.03	105.21	61570.0
2017-04-05	FBTS	Futures	101.891	101.9	101.855	101.873	22508.0
2017-04-05	FCE	Futures	4506.9	4516.6	4467.2	4488.4	85926.0
2017-04-05	FDAX	Futures	13013.2	13013.2	12872.2	12921.9	80642.0
2017-04-05	FDIV	Futures	146.24	146.42	145.63	145.63	50.0
2017-04-05	FDXM	Futures	12898.3	12898.3	12763.3	12808.3	23690.0
2017-04-05	FESX	Futures	2791.6	2796.5	2763.0	2776.1	922660.0
2017-04-05	FEU3	Futures	99.001	99.001	99.001	99.001	16.0
2017-04-05	FGBL	Futures	149.37	149.52	148.9	149.25	654236.0
2017-04-05	FGBM	Futures	129.75	129.89	129.63	129.82	424131.0
2017-04-05	FGBS	Futures	112.432	112.472	112.402	112.462	247465.0
2017-04-05	FGBX	Futures	170.82	171.12	169.55	170.37	41188.0
2017-04-05	FMWO	Futures	6209.7	6244.7	6189.2	6230.2	615.0
2017-04-05	FOAT	Futures	132.29	132.43	131.94	132.13	106642.0
2017-04-05	FTDX	Futures	2007.3	2007.3	1999.9	2004.3	134.0
2017-04-05	FTI	Futures	467.38	469.48	465.25	467.16	27238.0
2017-04-05	FTUK	Futures	6227.4	6242.0	6182.5	6217.2	92704.0
2017-04-05	FVSA	Futures	650.26	650.26	632.24	646.1	13930.0
2017-04-05	FXXP	Futures	316.5	317.3	314.4	315.8	25334.0
2017-04-05	G	Futures	115.94	115.95	115.26	115.51	157546.0

> showing 50 of 112 rows — these rows as CSV

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