PREVIEW / futures_daily / 2014-10-27

all futures daily files

  file:    by_date/futures_daily/2014/2014-10-27.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-10-27	ES	Futures	2047.65	2053.39	2031.2	2044.25	1452059.0
2014-10-27	NQ	Futures	4677.34	4693.56	4646.91	4680.23	275993.0
2014-10-27	YM	Futures	16989.2	17041.0	16893.9	16999.4	132768.0
2014-10-27	CL	Futures	156.04	156.08	152.52	155.52	285327.0
2014-10-27	GC	Futures	1614.1	1616.1	1607.0	1612.4	86313.0
2014-10-27	ZN	Futures	118.993335	119.256918	118.832256	119.154414	908123.0
2014-10-27	A6	Futures	0.85246	0.85469	0.8511	0.85295	53380.0
2014-10-27	AD	Futures	0.9027	0.90473	0.90138	0.9029	34184.0
2014-10-27	ALI	Futures	3021.81	3021.81	3021.81	3021.81	0.0
2014-10-27	B	Futures	89.4	89.53	87.83	89.15	90910.0
2014-10-27	B6	Futures	1.69	1.6966	1.6899	1.6946	51404.0
2014-10-27	BFX	Futures	3713.7	3728.3	3705.0	3706.5	9.0
2014-10-27	BR	Futures	0.21463	0.21463	0.20924	0.2122	3166.0
2014-10-27	BZ	Futures	90.06	90.42	88.72	90.06	12886.0
2014-10-27	C	Futures	2108.0	2114.0	2056.0	2058.0	15638.0
2014-10-27	CB	Futures	133.922	134.114	132.573	134.114	18.0
2014-10-27	CC	Futures	2250.0	2262.0	2183.0	2193.0	22479.0
2014-10-27	CNH	Futures	7.0419	7.0419	7.0372	7.0372	6.0
2014-10-27	CT	Futures	80.84	81.43	80.22	80.68	8615.0
2014-10-27	DC	Futures	38.85	39.76	38.85	39.66	185.0
2014-10-27	DX	Futures	81.448	81.448	81.139	81.221	22239.0
2014-10-27	E1	Futures	1.34374	1.34962	1.34335	1.34834	29064.0
2014-10-27	E6	Futures	1.49222	1.49811	1.49128	1.49634	143232.0
2014-10-27	E7	Futures	1.4828	1.4886	1.4819	1.4869	2201.0
2014-10-27	ED	Futures	95.4374	95.447	95.4374	95.4374	82176.0
2014-10-27	ER	Futures	97.974	97.989	97.97	97.979	47757.0
2014-10-27	EW	Futures	1434.5	1438.2	1417.7	1433.3	17744.0
2014-10-27	FBTP	Futures	94.21	94.66	93.8	94.07	73571.0
2014-10-27	FBTS	Futures	98.215	98.286	98.117	98.171	14741.0
2014-10-27	FCE	Futures	3350.1	3368.2	3277.1	3302.9	119117.0
2014-10-27	FDAX	Futures	9895.2	9964.2	9678.3	9755.5	142900.0
2014-10-27	FDIV	Futures	127.15	127.15	126.92	126.92	25.0
2014-10-27	FESX	Futures	2202.8	2218.0	2148.5	2165.9	1164659.0
2014-10-27	FGBL	Futures	132.4	132.78	132.21	132.68	531576.0
2014-10-27	FGBM	Futures	122.84	122.98	122.78	122.92	263435.0
2014-10-27	FGBS	Futures	110.893	110.913	110.878	110.908	127809.0
2014-10-27	FGBX	Futures	143.58	144.86	143.15	144.56	12850.0
2014-10-27	FMWO	Futures	5530.7	5534.5	5514.4	5526.9	66.0
2014-10-27	FOAT	Futures	121.38	121.73	121.38	121.67	63228.0
2014-10-27	FTDX	Futures	1145.0	1152.6	1121.4	1128.0	240.0
2014-10-27	FTI	Futures	347.74	349.58	342.49	344.72	35299.0
2014-10-27	FTUK	Futures	4941.1	4972.8	4881.2	4904.0	93472.0
2014-10-27	FVSA	Futures	1670.82	1812.49	1666.65	1770.82	12103.0
2014-10-27	FXXP	Futures	249.0	250.1	244.8	246.2	7730.0
2014-10-27	G	Futures	98.62	99.05	98.55	98.98	114815.0
2014-10-27	GF	Futures	367.768	369.451	366.516	367.534	1964.0
2014-10-27	GSCI	Futures	904.34	912.83	901.03	911.98	53.0
2014-10-27	HE	Futures	121.602	121.602	119.516	119.853	14533.0
2014-10-27	HG	Futures	3.861	3.8991	3.8388	3.8864	42664.0
2014-10-27	HH	Futures	43.8	44.182	43.312	43.347	558.0

> showing 50 of 104 rows — these rows as CSV

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