PREVIEW / futures_daily / 2014-08-20

all futures daily files

  file:    by_date/futures_daily/2014/2014-08-20.parquet
  size:    9 KB
  rows:    104

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
2014-08-20	ES	Futures	2054.48	2063.05	2049.55	2060.19	1058754.0
2014-08-20	NQ	Futures	4657.23	4668.77	4648.29	4660.69	163157.0
2014-08-20	YM	Futures	17036.7	17122.5	17006.4	17102.3	100390.0
2014-08-20	CL	Futures	172.86	174.31	172.73	174.07	207152.0
2014-08-20	GC	Futures	1701.5	1704.2	1690.3	1698.9	83304.0
2014-08-20	ZN	Futures	117.877911	117.921678	117.454834	117.571545	1185117.0
2014-08-20	A6	Futures	0.89721	0.89895	0.89479	0.89624	112474.0
2014-08-20	AD	Futures	0.92769	0.9285	0.92484	0.92555	50705.0
2014-08-20	ALI	Futures	2989.04	2989.04	2989.04	2989.04	0.0
2014-08-20	B	Futures	106.6	107.51	106.54	107.42	166194.0
2014-08-20	B6	Futures	1.7462	1.7533	1.7437	1.7446	124887.0
2014-08-20	BFX	Futures	3806.8	3807.9	3802.9	3807.9	2.0
2014-08-20	BR	Futures	0.23326	0.23342	0.23221	0.2326	3140.0
2014-08-20	BZ	Futures	107.68	108.35	107.36	108.26	10201.0
2014-08-20	C	Futures	2160.0	2188.0	2152.0	2175.0	2501.0
2014-08-20	CB	Futures	148.052	149.254	148.052	149.24	13.0
2014-08-20	CC	Futures	2366.0	2403.0	2365.0	2381.0	12606.0
2014-08-20	CNH	Futures	7.0534	7.0558	7.0496	7.0522	16.0
2014-08-20	CSC	Futures	4.917	4.917	4.917	4.917	5.0
2014-08-20	CT	Futures	80.22	82.6	80.22	82.4	26.0
2014-08-20	DC	Futures	39.27	40.36	38.94	40.09	625.0
2014-08-20	DX	Futures	77.78	78.15	77.77	78.102	22184.0
2014-08-20	E1	Futures	1.40981	1.41045	1.40302	1.40417	35527.0
2014-08-20	E6	Futures	1.57155	1.57238	1.56424	1.56518	176085.0
2014-08-20	E7	Futures	1.5617	1.562	1.554	1.555	1738.0
2014-08-20	ED	Futures	95.4186	95.4186	95.4162	95.4186	80320.0
2014-08-20	ER	Futures	97.916	97.925	97.916	97.92	26440.0
2014-08-20	EW	Futures	1474.6	1479.3	1468.7	1477.4	11660.0
2014-08-20	FBTP	Futures	93.46	93.74	93.45	93.49	42282.0
2014-08-20	FBTS	Futures	98.703	98.748	98.703	98.703	6069.0
2014-08-20	FCE	Futures	3383.9	3389.1	3356.9	3376.8	68075.0
2014-08-20	FDAX	Futures	10272.5	10288.4	10182.1	10258.1	84127.0
2014-08-20	FESX	Futures	2223.2	2225.3	2202.3	2216.0	728839.0
2014-08-20	FGBL	Futures	130.49	130.76	130.38	130.71	476678.0
2014-08-20	FGBM	Futures	122.2	122.3	122.18	122.29	245279.0
2014-08-20	FGBS	Futures	110.833	110.843	110.823	110.833	149889.0
2014-08-20	FGBX	Futures	140.56	141.47	140.48	141.37	18692.0
2014-08-20	FMWO	Futures	5755.0	5767.6	5755.0	5767.6	42.0
2014-08-20	FOAT	Futures	120.42	120.72	120.42	120.65	60605.0
2014-08-20	FTDX	Futures	1143.0	1147.7	1137.9	1142.5	213.0
2014-08-20	FTI	Futures	347.26	348.51	346.22	347.17	19277.0
2014-08-20	FTUK	Futures	5211.5	5211.5	5180.4	5192.7	76538.0
2014-08-20	FVSA	Futures	1446.52	1480.76	1446.52	1459.36	7482.0
2014-08-20	FXXP	Futures	252.6	253.0	251.7	252.5	3982.0
2014-08-20	G	Futures	96.29	96.37	95.97	96.21	139091.0
2014-08-20	GF	Futures	331.247	331.557	327.718	327.718	2081.0
2014-08-20	GSCI	Futures	1007.39	1009.15	1004.71	1007.22	231.0
2014-08-20	HE	Futures	114.397	114.669	111.193	111.828	20515.0
2014-08-20	HG	Futures	3.953	4.0576	3.9486	4.0557	29534.0
2014-08-20	HH	Futures	48.531	48.531	48.531	48.531	4122.0

> showing 50 of 104 rows — these rows as CSV

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