PREVIEW / futures_daily / 2014-11-05

all futures daily files

  file:    by_date/futures_daily/2014/2014-11-05.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-05	ES	Futures	2095.7	2110.59	2093.09	2108.76	1574778.0
2014-11-05	NQ	Futures	4803.67	4840.17	4790.92	4801.06	270149.0
2014-11-05	YM	Futures	17562.4	17679.1	17540.1	17665.9	138569.0
2014-11-05	CL	Futures	148.53	152.35	146.8	151.06	447691.0
2014-11-05	GC	Futures	1532.5	1533.7	1491.5	1502.8	261115.0
2014-11-05	ZN	Futures	118.39295	118.480811	118.14401	118.349019	956059.0
2014-11-05	A6	Futures	0.84818	0.84906	0.82991	0.83147	154271.0
2014-11-05	AD	Futures	0.8901	0.89244	0.88502	0.8902	72877.0
2014-11-05	ALI	Futures	3119.86	3119.86	3119.86	3119.86	5.0
2014-11-05	B	Futures	86.19	87.87	84.99	86.35	214232.0
2014-11-05	B6	Futures	1.6815	1.6836	1.6673	1.6789	127148.0
2014-11-05	BFX	Futures	3791.8	3825.2	3791.8	3825.2	3.0
2014-11-05	BR	Futures	0.21277	0.21385	0.21258	0.21328	25188.0
2014-11-05	BZ	Futures	86.67	88.78	85.87	87.23	22289.0
2014-11-05	C	Futures	2027.0	2036.0	2018.0	2019.0	6065.0
2014-11-05	CB	Futures	137.775	139.895	137.775	139.124	15.0
2014-11-05	CC	Futures	2122.0	2133.0	2111.0	2118.0	13687.0
2014-11-05	CNH	Futures	7.0365	7.0409	7.0365	7.0377	4.0
2014-11-05	CSC	Futures	5.006	5.058	5.006	5.058	21.0
2014-11-05	CT	Futures	79.94	79.98	78.59	79.46	16912.0
2014-11-05	DC	Futures	39.87	40.8	39.87	40.59	372.0
2014-11-05	DX	Futures	82.686	83.27	82.634	83.125	35204.0
2014-11-05	E1	Futures	1.33274	1.33466	1.32379	1.32584	52809.0
2014-11-05	E6	Futures	1.47762	1.47974	1.46668	1.46938	252300.0
2014-11-05	E7	Futures	1.4683	1.4706	1.4577	1.4601	3953.0
2014-11-05	ED	Futures	95.4422	95.447	95.4374	95.4374	76916.0
2014-11-05	ER	Futures	98.004	98.004	97.994	98.004	23621.0
2014-11-05	EW	Futures	1471.3	1482.3	1469.6	1477.9	13872.0
2014-11-05	FBTP	Futures	94.95	95.17	94.75	94.89	77989.0
2014-11-05	FBTS	Futures	98.277	98.313	98.215	98.268	21915.0
2014-11-05	FCE	Futures	3365.0	3399.3	3342.0	3393.3	100020.0
2014-11-05	FDAX	Futures	10143.3	10222.2	10102.8	10199.2	116033.0
2014-11-05	FDIV	Futures	132.84	133.31	132.84	133.31	32.0
2014-11-05	FESX	Futures	2213.7	2236.1	2199.9	2231.8	978264.0
2014-11-05	FGBL	Futures	133.19	133.3	133.09	133.17	495937.0
2014-11-05	FGBM	Futures	123.13	123.19	123.12	123.18	288264.0
2014-11-05	FGBS	Futures	110.923	110.943	110.913	110.933	158732.0
2014-11-05	FGBX	Futures	145.22	145.62	144.94	145.06	22290.0
2014-11-05	FMWO	Futures	5652.3	5671.1	5652.3	5664.8	2748.0
2014-11-05	FOAT	Futures	122.63	122.77	122.51	122.58	62190.0
2014-11-05	FTDX	Futures	1182.3	1191.3	1174.3	1190.8	105.0
2014-11-05	FTI	Futures	355.13	358.81	354.35	358.15	29369.0
2014-11-05	FTUK	Futures	4996.4	5043.9	4987.9	5034.7	82714.0
2014-11-05	FVSA	Futures	1670.82	1687.49	1645.82	1670.82	7880.0
2014-11-05	FXXP	Futures	252.6	255.2	251.6	254.7	7060.0
2014-11-05	G	Futures	98.77	98.79	98.56	98.61	114048.0
2014-11-05	GF	Futures	370.625	371.212	368.316	369.06	2329.0
2014-11-05	GSCI	Futures	894.32	905.95	891.35	900.09	364.0
2014-11-05	HE	Futures	118.305	118.709	116.656	117.262	15803.0
2014-11-05	HG	Futures	3.8287	3.8312	3.7596	3.8147	56376.0

> showing 50 of 106 rows — these rows as CSV

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