PREVIEW / futures_daily / 2014-08-18

all futures daily files

  file:    by_date/futures_daily/2014/2014-08-18.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-18	ES	Futures	2031.63	2045.39	2031.63	2043.83	890465.0
2014-08-18	NQ	Futures	4604.73	4637.61	4604.73	4630.4	159348.0
2014-08-18	YM	Futures	16815.7	16966.1	16806.7	16943.9	97398.0
2014-08-18	CL	Futures	177.22	177.22	174.01	174.63	177858.0
2014-08-18	GC	Futures	1710.7	1711.6	1700.6	1704.2	76105.0
2014-08-18	ZN	Futures	118.228044	118.257221	117.877911	117.980033	783611.0
2014-08-18	A6	Futures	0.89914	0.90059	0.89798	0.89953	43632.0
2014-08-18	AD	Futures	0.93195	0.93327	0.93114	0.93216	26885.0
2014-08-18	ALI	Futures	2914.06	2914.06	2914.06	2914.06	0.0
2014-08-18	B	Futures	108.4	108.49	106.19	106.7	181098.0
2014-08-18	B6	Futures	1.7569	1.7592	1.7566	1.758	55978.0
2014-08-18	BFX	Futures	3810.7	3811.2	3809.2	3809.3	15.0
2014-08-18	BR	Futures	0.23273	0.23279	0.23197	0.2326	374.0
2014-08-18	BZ	Futures	108.96	109.01	107.02	107.54	9002.0
2014-08-18	C	Futures	2174.0	2190.0	2169.0	2183.0	2538.0
2014-08-18	CB	Futures	145.747	146.85	144.209	144.768	17.0
2014-08-18	CC	Futures	2393.0	2413.0	2391.0	2407.0	6966.0
2014-08-18	CNH	Futures	7.0505	7.0505	7.0488	7.0488	10.0
2014-08-18	CSC	Futures	4.835	4.839	4.752	4.759	33.0
2014-08-18	CT	Futures	80.17	80.4	79.69	79.9	17.0
2014-08-18	DC	Futures	39.06	39.67	38.73	38.86	350.0
2014-08-18	DX	Futures	77.362	77.514	77.296	77.486	11650.0
2014-08-18	E1	Futures	1.4193	1.42045	1.41366	1.41443	23903.0
2014-08-18	E6	Futures	1.5804	1.58111	1.57568	1.57674	104859.0
2014-08-18	E7	Futures	1.5702	1.5708	1.5654	1.5665	1136.0
2014-08-18	ED	Futures	95.4186	95.421	95.4162	95.4186	97077.0
2014-08-18	ER	Futures	97.906	97.911	97.901	97.911	19483.0
2014-08-18	EW	Futures	1451.2	1466.1	1451.2	1463.7	12901.0
2014-08-18	FBTP	Futures	93.47	93.57	93.03	93.2	37308.0
2014-08-18	FBTS	Futures	98.65	98.721	98.623	98.659	10797.0
2014-08-18	FCE	Futures	3363.2	3378.0	3352.5	3367.6	69062.0
2014-08-18	FDAX	Futures	10156.3	10209.1	10122.7	10193.7	78828.0
2014-08-18	FESX	Futures	2209.5	2216.0	2198.7	2211.7	634278.0
2014-08-18	FGBL	Futures	130.61	130.67	130.27	130.36	433686.0
2014-08-18	FGBM	Futures	122.24	122.27	122.13	122.17	265555.0
2014-08-18	FGBS	Futures	110.828	110.833	110.818	110.828	90645.0
2014-08-18	FGBX	Futures	141.02	141.06	139.75	140.09	18747.0
2014-08-18	FMWO	Futures	5734.9	5744.9	5734.9	5744.9	271.0
2014-08-18	FOAT	Futures	120.7	120.7	120.19	120.25	51232.0
2014-08-18	FTDX	Futures	1130.4	1134.1	1104.6	1133.2	189.0
2014-08-18	FTI	Futures	343.34	344.71	342.86	344.15	19098.0
2014-08-18	FTUK	Futures	5153.5	5186.5	5151.5	5179.2	62298.0
2014-08-18	FVSA	Futures	1476.48	1485.04	1455.08	1463.64	6883.0
2014-08-18	FXXP	Futures	251.1	251.6	250.1	251.3	5912.0
2014-08-18	G	Futures	96.5	96.52	96.05	96.08	117999.0
2014-08-18	GF	Futures	334.001	336.134	332.721	335.203	1460.0
2014-08-18	GSCI	Futures	1008.14	1008.14	1004.37	1006.38	59.0
2014-08-18	HE	Futures	114.065	115.455	112.735	114.971	17896.0
2014-08-18	HG	Futures	3.9663	3.9963	3.9547	3.9739	36116.0
2014-08-18	HH	Futures	48.125	48.404	48.112	48.138	667.0

> showing 50 of 104 rows — these rows as CSV

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