PREVIEW / futures_daily / 2014-12-31

all futures daily files

  file:    by_date/futures_daily/2014/2014-12-31.parquet
  size:    9 KB
  rows:    92

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-12-31	ES	Futures	2176.18	2182.99	2149.45	2151.28	836223.0
2014-12-31	NQ	Futures	4969.53	4995.05	4905.71	4911.22	146914.0
2014-12-31	YM	Futures	18268.4	18316.3	18066.8	18080.0	69573.0
2014-12-31	CL	Futures	105.51	105.8	102.71	104.33	233516.0
2014-12-31	GC	Futures	1570.4	1575.8	1543.9	1549.9	70517.0
2014-12-31	ZN	Futures	119.290036	119.481419	119.245871	119.466697	270132.0
2014-12-31	A6	Futures	0.79719	0.80062	0.79493	0.79562	34353.0
2014-12-31	AD	Futures	0.87575	0.87931	0.87442	0.87564	27987.0
2014-12-31	ALI	Futures	2827.09	2827.09	2827.09	2827.09	0.0
2014-12-31	B	Futures	59.43	59.79	57.85	59.45	67589.0
2014-12-31	B6	Futures	1.6353	1.6416	1.634	1.6371	41628.0
2014-12-31	BFX	Futures	3984.3	3984.3	3980.7	3980.7	43.0
2014-12-31	BR	Futures	0.20615	0.20615	0.20204	0.20356	26.0
2014-12-31	BZ	Futures	59.63	60.1	58.21	59.77	8786.0
2014-12-31	C	Futures	2167.0	2171.0	2155.0	2161.0	3751.0
2014-12-31	CB	Futures	132.448	132.448	132.057	132.057	10.0
2014-12-31	CC	Futures	2193.0	2198.0	2142.0	2147.0	11779.0
2014-12-31	CNH	Futures	7.1053	7.1189	7.1053	7.1063	1.0
2014-12-31	CSC	Futures	4.574	4.574	4.56	4.574	10.0
2014-12-31	CT	Futures	79.17	79.29	76.91	76.98	18962.0
2014-12-31	DC	Futures	36.23	36.68	36.04	36.04	99.0
2014-12-31	DX	Futures	85.433	85.821	85.338	85.804	18526.0
2014-12-31	E1	Futures	1.2925	1.29416	1.28573	1.28637	15479.0
2014-12-31	E6	Futures	1.43079	1.43244	1.42374	1.42409	111793.0
2014-12-31	E7	Futures	1.4223	1.4238	1.4152	1.4156	1770.0
2014-12-31	EBM	Futures	324.82	327.25	324.01	326.44	2720.0
2014-12-31	ED	Futures	95.4354	95.445	95.4354	95.4402	34742.0
2014-12-31	ER	Futures	98.019	98.023	98.014	98.019	7915.0
2014-12-31	EW	Futures	1535.4	1540.2	1514.2	1514.8	17405.0
2014-12-31	FCE	Futures	3484.3	3494.9	3478.2	3490.9	12828.0
2014-12-31	FTI	Futures	366.37	368.53	366.15	367.88	2723.0
2014-12-31	FTUK	Futures	5090.6	5091.0	5062.1	5084.7	15379.0
2014-12-31	G	Futures	102.77	103.13	102.76	103.07	25785.0
2014-12-31	GF	Futures	351.142	353.549	349.016	352.105	2123.0
2014-12-31	GSCI	Futures	710.89	719.24	708.33	714.73	164.0
2014-12-31	HE	Futures	109.874	110.645	108.432	108.935	12687.0
2014-12-31	HG	Futures	3.6241	3.6343	3.5765	3.5892	21858.0
2014-12-31	HH	Futures	36.695	36.695	34.701	34.701	1584.0
2014-12-31	HO	Futures	1.475	1.4926	1.4424	1.4762	12080.0
2014-12-31	HRC	Futures	2368.7	2368.7	2368.7	2368.7	0.0
2014-12-31	J1	Futures	0.0104908	0.0105058	0.0104432	0.0104532	50390.0
2014-12-31	J7	Futures	0.010478	0.010492	0.010433	0.010441	341.0
2014-12-31	JB	Futures	133.61	133.75	133.61	133.72	280.0
2014-12-31	KC	Futures	282.52	293.4	280.9	285.35	8575.0
2014-12-31	KE	Futures	2039.17	2051.22	1995.82	2011.88	8543.0
2014-12-31	L	Futures	99.025	99.035	99.025	99.035	7827.0
2014-12-31	LBS	Futures	529.5	530.0	522.5	523.3	321.0
2014-12-31	LE	Futures	193.944	194.824	190.921	191.948	24741.0
2014-12-31	MFS	Futures	1711.6	1711.6	1688.4	1692.5	11783.0
2014-12-31	MGC	Futures	1538.8	1543.3	1512.6	1518.4	935.0

> showing 50 of 92 rows — these rows as CSV

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