PREVIEW / futures_daily / 2014-10-09

all futures daily files

  file:    by_date/futures_daily/2014/2014-10-09.parquet
  size:    9 KB
  rows:    106

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-10-09	ES	Futures	2048.96	2056.27	2000.64	2010.83	3103761.0
2014-10-09	NQ	Futures	4669.51	4691.24	4574.48	4601.42	595699.0
2014-10-09	YM	Futures	17148.5	17195.2	16777.2	16851.2	342630.0
2014-10-09	CL	Futures	165.26	165.67	158.34	161.57	345020.0
2014-10-09	GC	Futures	1601.7	1618.6	1599.3	1607.2	165358.0
2014-10-09	ZN	Futures	118.510098	118.920117	118.407594	118.495455	2289596.0
2014-10-09	A6	Futures	0.85421	0.86082	0.8477	0.84857	147307.0
2014-10-09	AD	Futures	0.91276	0.91519	0.90636	0.90818	75226.0
2014-10-09	ALI	Futures	2942.24	2942.24	2942.24	2942.24	9.0
2014-10-09	B	Futures	95.52	95.73	92.14	93.8	295251.0
2014-10-09	B6	Futures	1.6977	1.7047	1.6915	1.6935	116443.0
2014-10-09	BFX	Futures	3765.6	3765.6	3734.8	3734.8	2.0
2014-10-09	BR	Futures	0.22462	0.2253	0.2216	0.2226	2054.0
2014-10-09	BZ	Futures	96.4	96.4	92.85	94.49	26111.0
2014-10-09	C	Futures	2106.0	2117.0	2097.0	2112.0	11900.0
2014-10-09	CB	Futures	141.051	142.593	141.051	142.593	19.0
2014-10-09	CC	Futures	2250.0	2267.0	2244.0	2257.0	9821.0
2014-10-09	CNH	Futures	7.0589	7.0694	7.0589	7.0645	1.0
2014-10-09	CSC	Futures	5.108	5.198	5.108	5.192	13.0
2014-10-09	CT	Futures	82.17	82.28	79.98	81.02	14524.0
2014-10-09	DC	Futures	41.22	42.11	41.05	42.09	168.0
2014-10-09	DX	Futures	81.035	81.433	80.702	81.31	55450.0
2014-10-09	E1	Futures	1.34323	1.35077	1.33811	1.34067	64062.0
2014-10-09	E6	Futures	1.49917	1.50635	1.49116	1.4941	339907.0
2014-10-09	E7	Futures	1.4896	1.4968	1.4819	1.4847	4468.0
2014-10-09	ED	Futures	95.447	95.4565	95.4422	95.4422	276807.0
2014-10-09	ER	Futures	98.004	98.009	97.999	98.004	29795.0
2014-10-09	EW	Futures	1412.0	1415.6	1374.8	1380.9	39609.0
2014-10-09	FBTP	Futures	95.53	95.91	95.45	95.64	76842.0
2014-10-09	FBTS	Futures	98.588	98.694	98.535	98.57	12009.0
2014-10-09	FCE	Futures	3359.1	3360.3	3255.6	3296.6	173055.0
2014-10-09	FDAX	Futures	9974.1	10016.2	9739.1	9882.6	205642.0
2014-10-09	FESX	Futures	2233.2	2234.7	2167.3	2199.2	1975204.0
2014-10-09	FEU3	Futures	98.626	98.626	98.626	98.626	15.0
2014-10-09	FGBL	Futures	132.43	132.83	132.27	132.33	945169.0
2014-10-09	FGBM	Futures	122.99	123.17	122.94	122.98	517626.0
2014-10-09	FGBS	Futures	110.933	110.948	110.918	110.928	150541.0
2014-10-09	FGBX	Futures	143.51	144.2	143.05	143.15	29963.0
2014-10-09	FMWO	Futures	5579.6	5594.6	5526.9	5526.9	1697.0
2014-10-09	FOAT	Futures	122.03	122.43	121.93	122.0	66069.0
2014-10-09	FTDX	Futures	1129.4	1137.0	1108.1	1119.5	455.0
2014-10-09	FTI	Futures	352.36	352.66	344.54	347.78	52344.0
2014-10-09	FTUK	Futures	5037.0	5049.3	4906.3	4954.6	153358.0
2014-10-09	FVSA	Futures	1550.75	1591.34	1526.39	1579.16	22164.0
2014-10-09	FXXP	Futures	250.5	250.9	244.4	247.2	11027.0
2014-10-09	G	Futures	98.82	99.0	98.34	98.38	239668.0
2014-10-09	GF	Futures	378.008	381.47	372.836	375.947	2523.0
2014-10-09	GSCI	Futures	945.57	945.57	927.47	931.68	1676.0
2014-10-09	HE	Futures	128.803	130.654	128.399	128.702	15827.0
2014-10-09	HG	Futures	3.8357	3.8801	3.8287	3.8433	57724.0

> showing 50 of 106 rows — these rows as CSV

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