PREVIEW / futures_daily / 2016-12-19

all futures daily files

  file:    by_date/futures_daily/2016/2016-12-19.parquet
  size:    9 KB
  rows:    110

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-19	ES	Futures	2445.73	2454.13	2443.56	2450.07	928690.0
2016-12-19	NQ	Futures	5793.74	5853.26	5789.91	5820.85	146138.0
2016-12-19	YM	Futures	20855.3	20918.5	20846.9	20894.3	87037.0
2016-12-19	CL	Futures	56.99	57.35	56.26	56.78	482552.0
2016-12-19	GC	Futures	1459.0	1469.6	1458.2	1467.5	119183.0
2016-12-19	ZN	Futures	120.132058	120.712775	120.116776	120.559954	1015374.0
2016-12-19	A6	Futures	0.74412	0.7474	0.74023	0.74125	73324.0
2016-12-19	AD	Futures	0.76678	0.7679	0.76187	0.76228	41041.0
2016-12-19	ALI	Futures	2349.73	2349.73	2347.47	2347.47	10.0
2016-12-19	B	Futures	41.27	41.57	40.74	40.92	228387.0
2016-12-19	B6	Futures	1.313	1.3143	1.2989	1.3036	90848.0
2016-12-19	BFX	Futures	4268.9	4279.1	4268.9	4279.1	7.0
2016-12-19	BR	Futures	0.20793	0.20793	0.20708	0.20708	18.0
2016-12-19	BZ	Futures	41.04	41.26	40.44	40.61	30608.0
2016-12-19	C	Futures	1890.0	1936.0	1887.0	1932.0	13778.0
2016-12-19	CB	Futures	272.189	273.226	272.189	273.226	30.0
2016-12-19	CC	Futures	1729.0	1757.0	1710.0	1753.0	13593.0
2016-12-19	CNH	Futures	7.5053	7.5053	7.4442	7.4442	100.0
2016-12-19	CSC	Futures	4.094	4.112	4.091	4.091	23.0
2016-12-19	CT	Futures	81.45	81.56	79.87	79.92	27404.0
2016-12-19	DC	Futures	33.28	33.68	33.28	33.47	99.0
2016-12-19	DX	Futures	95.734	96.046	95.436	95.995	24735.0
2016-12-19	E1	Futures	1.21409	1.21942	1.21211	1.2136	18970.0
2016-12-19	E6	Futures	1.21202	1.21577	1.20578	1.20694	154407.0
2016-12-19	E7	Futures	1.2041	1.2096	1.1997	1.2007	3312.0
2016-12-19	EBM	Futures	191.71	192.56	190.28	191.14	13015.0
2016-12-19	ED	Futures	95.5665	95.581	95.5617	95.5713	298083.0
2016-12-19	ER	Futures	98.279	98.283	98.274	98.279	63999.0
2016-12-19	EW	Futures	1778.8	1787.1	1776.3	1785.5	10879.0
2016-12-19	FBON	Futures	122.31	122.84	122.23	122.59	84.0
2016-12-19	FBTP	Futures	106.38	107.03	106.35	106.88	57320.0
2016-12-19	FBTS	Futures	101.773	101.837	101.773	101.809	14100.0
2016-12-19	FCE	Futures	4245.8	4247.5	4226.0	4236.6	65769.0
2016-12-19	FDAX	Futures	12054.1	12067.3	12009.8	12052.0	52070.0
2016-12-19	FDXM	Futures	12006.6	12017.1	11962.4	12003.5	13285.0
2016-12-19	FESX	Futures	2599.1	2599.1	2588.7	2595.1	577993.0
2016-12-19	FEU3	Futures	98.952	98.952	98.952	98.952	2.0
2016-12-19	FGBL	Futures	146.21	147.47	146.13	147.14	506448.0
2016-12-19	FGBM	Futures	128.64	129.03	128.63	128.93	296853.0
2016-12-19	FGBS	Futures	112.162	112.212	112.162	112.202	149209.0
2016-12-19	FGBX	Futures	167.28	171.3	166.71	170.25	32559.0
2016-12-19	FMWO	Futures	5881.6	5884.0	5870.7	5882.8	806.0
2016-12-19	FOAT	Futures	132.69	133.6	132.58	133.54	60821.0
2016-12-19	FTDX	Futures	1738.6	1754.3	1737.2	1747.5	201.0
2016-12-19	FTI	Futures	435.01	437.46	434.6	437.01	18752.0
2016-12-19	FTUK	Futures	5888.0	5907.9	5870.6	5892.7	68469.0
2016-12-19	FVSA	Futures	1109.91	1112.65	1063.32	1082.5	16418.0
2016-12-19	FXXP	Futures	296.8	297.1	296.0	296.6	22391.0
2016-12-19	G	Futures	110.01	110.64	110.01	110.51	92764.0
2016-12-19	GF	Futures	289.781	292.067	288.331	291.956	3490.0

> showing 50 of 110 rows — these rows as CSV

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