PREVIEW / futures_daily / 2014-11-07

all futures daily files

  file:    by_date/futures_daily/2014/2014-11-07.parquet
  size:    9 KB
  rows:    103

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-11-07	ES	Futures	2117.64	2124.17	2110.59	2116.33	1282437.0
2014-11-07	NQ	Futures	4826.56	4844.23	4793.52	4810.62	229702.0
2014-11-07	YM	Futures	17755.2	17802.9	17690.3	17755.2	115197.0
2014-11-07	CL	Futures	149.49	152.47	148.74	151.01	306077.0
2014-11-07	GC	Futures	1496.9	1546.4	1482.7	1534.4	298006.0
2014-11-07	ZN	Futures	118.085436	118.788325	117.939001	118.700464	1605186.0
2014-11-07	A6	Futures	0.82972	0.83944	0.82797	0.8372	138731.0
2014-11-07	AD	Futures	0.88807	0.89721	0.88655	0.89579	87664.0
2014-11-07	ALI	Futures	3124.0	3124.0	3124.0	3124.0	0.0
2014-11-07	B	Futures	86.11	87.26	85.61	86.82	147143.0
2014-11-07	B6	Futures	1.6643	1.6695	1.6593	1.6671	105203.0
2014-11-07	BR	Futures	0.20934	0.21042	0.20713	0.20886	2690.0
2014-11-07	BZ	Futures	86.93	88.13	86.5	87.7	13295.0
2014-11-07	C	Futures	2046.0	2069.0	2037.0	2052.0	3030.0
2014-11-07	CB	Futures	134.114	134.114	131.802	131.802	16.0
2014-11-07	CC	Futures	2120.0	2150.0	2117.0	2128.0	19561.0
2014-11-07	CNH	Futures	7.0557	7.0598	7.0544	7.0544	2.0
2014-11-07	CSC	Futures	4.98	5.011	4.98	4.998	67.0
2014-11-07	CT	Futures	80.07	81.58	79.36	81.05	20322.0
2014-11-07	DC	Futures	40.14	40.14	39.53	39.93	223.0
2014-11-07	DX	Futures	83.702	83.835	83.104	83.276	65234.0
2014-11-07	E1	Futures	1.31497	1.32533	1.31292	1.32238	59306.0
2014-11-07	E6	Futures	1.45761	1.46833	1.45502	1.46479	327381.0
2014-11-07	E7	Futures	1.4482	1.459	1.4438	1.4556	5277.0
2014-11-07	ED	Futures	95.4374	95.4422	95.4374	95.4374	115728.0
2014-11-07	ER	Futures	98.004	98.004	97.999	98.004	15233.0
2014-11-07	EW	Futures	1486.4	1490.9	1481.1	1486.6	12287.0
2014-11-07	FBTP	Futures	95.23	95.4	95.09	95.18	46952.0
2014-11-07	FBTS	Futures	98.357	98.419	98.357	98.384	7720.0
2014-11-07	FCE	Futures	3429.2	3432.0	3354.5	3379.5	117655.0
2014-11-07	FDAX	Futures	10340.5	10350.9	10119.2	10178.9	132568.0
2014-11-07	FESX	Futures	2255.0	2258.6	2197.0	2213.7	1100251.0
2014-11-07	FGBL	Futures	133.12	133.38	132.83	133.26	649111.0
2014-11-07	FGBM	Futures	123.18	123.25	123.07	123.21	292947.0
2014-11-07	FGBS	Futures	110.943	110.948	110.928	110.938	160190.0
2014-11-07	FGBX	Futures	144.76	145.54	144.06	145.12	29060.0
2014-11-07	FMWO	Futures	5678.6	5679.9	5661.1	5676.1	163.0
2014-11-07	FOAT	Futures	122.57	122.7	122.38	122.66	60900.0
2014-11-07	FTDX	Futures	1197.0	1200.3	1184.2	1187.1	109.0
2014-11-07	FTI	Futures	362.88	363.14	357.58	359.38	31482.0
2014-11-07	FTUK	Futures	5064.0	5100.4	5055.9	5069.8	106089.0
2014-11-07	FVSA	Futures	1620.82	1691.65	1599.99	1670.82	12520.0
2014-11-07	FXXP	Futures	256.3	256.5	251.6	254.0	8375.0
2014-11-07	G	Futures	98.65	99.11	98.44	99.0	158128.0
2014-11-07	GF	Futures	370.742	373.56	370.429	373.364	2299.0
2014-11-07	GSCI	Futures	905.53	909.77	905.53	906.89	1335.0
2014-11-07	HE	Futures	118.843	120.728	118.574	119.483	24538.0
2014-11-07	HG	Futures	3.8204	3.8674	3.8198	3.8541	49564.0
2014-11-07	HH	Futures	51.798	53.418	51.714	52.584	1704.0
2014-11-07	HO	Futures	1.9561	1.9955	1.9451	1.9899	79005.0

> showing 50 of 103 rows — these rows as CSV

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