PREVIEW / futures_daily / 2014-11-04

all futures daily files

  file:    by_date/futures_daily/2014/2014-11-04.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-11-04	ES	Futures	2100.14	2103.53	2084.21	2094.92	1524332.0
2014-11-04	NQ	Futures	4818.44	4826.27	4774.69	4802.22	259945.0
2014-11-04	YM	Futures	17539.1	17580.7	17457.9	17556.3	141531.0
2014-11-04	CL	Futures	150.18	150.55	145.61	148.2	432757.0
2014-11-04	GC	Futures	1527.6	1541.2	1526.0	1531.6	134878.0
2014-11-04	ZN	Futures	118.378307	118.671177	118.290445	118.349019	1142588.0
2014-11-04	A6	Futures	0.84196	0.84789	0.83769	0.84711	115079.0
2014-11-04	AD	Futures	0.89376	0.89488	0.88797	0.89081	61696.0
2014-11-04	ALI	Futures	3113.17	3113.17	3113.17	3113.17	6.0
2014-11-04	B	Futures	87.6	87.83	85.47	86.21	168336.0
2014-11-04	B6	Futures	1.6787	1.683	1.6776	1.6815	68759.0
2014-11-04	BFX	Futures	3772.5	3814.5	3762.9	3762.9	50.0
2014-11-04	BR	Futures	0.21488	0.21488	0.21166	0.21318	832.0
2014-11-04	BZ	Futures	88.58	88.58	86.36	87.08	16731.0
2014-11-04	C	Futures	2016.0	2031.0	2014.0	2023.0	5472.0
2014-11-04	CB	Futures	135.078	138.72	135.078	138.469	18.0
2014-11-04	CC	Futures	2112.0	2131.0	2105.0	2123.0	14976.0
2014-11-04	CNH	Futures	7.0459	7.0459	7.0339	7.0339	7.0
2014-11-04	CSC	Futures	4.967	5.001	4.967	4.977	26.0
2014-11-04	CT	Futures	81.15	81.53	79.5	79.58	18805.0
2014-11-04	DC	Futures	39.26	40.14	39.14	39.95	336.0
2014-11-04	DX	Futures	82.933	82.952	82.563	82.674	32505.0
2014-11-04	E1	Futures	1.32469	1.33504	1.32469	1.33325	41293.0
2014-11-04	E6	Futures	1.47044	1.48092	1.47033	1.47845	218647.0
2014-11-04	E7	Futures	1.4613	1.4716	1.461	1.4692	3874.0
2014-11-04	ED	Futures	95.4374	95.4422	95.4374	95.4374	75725.0
2014-11-04	ER	Futures	97.999	98.004	97.994	97.999	38357.0
2014-11-04	EW	Futures	1475.5	1477.7	1465.4	1471.5	15400.0
2014-11-04	FBTP	Futures	95.04	95.34	94.8	95.03	65851.0
2014-11-04	FBTS	Futures	98.277	98.348	98.224	98.286	15126.0
2014-11-04	FCE	Futures	3381.2	3394.5	3320.2	3326.3	104786.0
2014-11-04	FDAX	Futures	10143.9	10209.0	10020.6	10049.6	128953.0
2014-11-04	FDIV	Futures	132.2	132.2	131.13	131.13	1.0
2014-11-04	FESX	Futures	2227.4	2238.3	2186.1	2192.7	1224384.0
2014-11-04	FGBL	Futures	133.01	133.42	132.88	133.34	717696.0
2014-11-04	FGBM	Futures	123.09	123.2	123.03	123.18	349906.0
2014-11-04	FGBS	Futures	110.933	110.943	110.913	110.928	183605.0
2014-11-04	FGBX	Futures	145.16	146.2	144.7	145.8	34693.0
2014-11-04	FMWO	Futures	5667.3	5667.3	5622.2	5628.5	495.0
2014-11-04	FOAT	Futures	122.54	122.89	122.49	122.77	82297.0
2014-11-04	FTDX	Futures	1180.9	1189.9	1170.5	1172.4	180.0
2014-11-04	FTI	Futures	356.93	358.06	351.63	352.2	29348.0
2014-11-04	FTUK	Futures	4986.7	5016.5	4964.7	4974.3	79573.0
2014-11-04	FVSA	Futures	1641.65	1724.99	1633.32	1712.49	13975.0
2014-11-04	FXXP	Futures	252.8	254.4	250.1	250.7	8683.0
2014-11-04	G	Futures	98.62	98.95	98.52	98.82	163079.0
2014-11-04	GF	Futures	369.608	371.369	367.768	371.173	2525.0
2014-11-04	GSCI	Futures	896.7	897.63	890.92	894.74	140.0
2014-11-04	HE	Futures	119.92	121.165	118.17	118.406	18307.0
2014-11-04	HG	Futures	3.8788	3.8985	3.809	3.8287	53919.0

> showing 50 of 106 rows — these rows as CSV

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