PREVIEW / futures_daily / 2014-09-12

all futures daily files

  file:    by_date/futures_daily/2014/2014-09-12.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-09-12	ES	Futures	2076.81	2076.81	2056.3	2061.75	1254423.0
2014-09-12	NQ	Futures	4726.45	4726.45	4680.59	4695.59	184358.0
2014-09-12	YM	Futures	17217.5	17231.7	17095.7	17151.5	141344.0
2014-09-12	CL	Futures	173.32	174.48	171.29	171.87	297768.0
2014-09-12	GC	Futures	1627.6	1629.5	1610.8	1615.3	140795.0
2014-09-12	ZN	Futures	116.591796	116.635726	116.167133	116.19642	1581697.0
2014-09-12	A6	Futures	0.87899	0.87928	0.8717	0.87296	122227.0
2014-09-12	AD	Futures	0.91865	0.91885	0.91326	0.91377	70552.0
2014-09-12	ALI	Futures	2997.13	2997.13	2997.13	2997.13	9.0
2014-09-12	B	Futures	103.33	104.03	102.03	102.33	224474.0
2014-09-12	B6	Futures	1.7092	1.7095	1.702	1.7075	115456.0
2014-09-12	BR	Futures	0.22951	0.22965	0.22535	0.22592	740.0
2014-09-12	BZ	Futures	104.02	104.75	102.76	103.05	16814.0
2014-09-12	C	Futures	2097.0	2133.0	2092.0	2123.0	11160.0
2014-09-12	CB	Futures	146.447	146.447	146.447	146.447	4.0
2014-09-12	CC	Futures	2237.0	2263.0	2233.0	2254.0	13966.0
2014-09-12	CNH	Futures	7.0771	7.0842	7.0771	7.0842	1.0
2014-09-12	CSC	Futures	5.045	5.053	5.024	5.024	9.0
2014-09-12	CT	Futures	89.76	90.19	88.05	89.08	28.0
2014-09-12	DC	Futures	39.97	40.59	39.85	40.49	168.0
2014-09-12	DX	Futures	80.147	80.28	79.948	80.101	45248.0
2014-09-12	E1	Futures	1.36701	1.37327	1.36611	1.37033	53708.0
2014-09-12	E6	Futures	1.52247	1.52895	1.52059	1.5253	274011.0
2014-09-12	E7	Futures	1.5129	1.5193	1.5111	1.5157	4993.0
2014-09-12	ED	Futures	95.4183	95.423	95.4135	95.423	183809.0
2014-09-12	ER	Futures	98.014	98.014	97.989	98.004	88598.0
2014-09-12	EW	Futures	1493.3	1493.6	1473.4	1477.8	38017.0
2014-09-12	FBTP	Futures	94.37	94.61	94.07	94.34	75069.0
2014-09-12	FBTS	Futures	98.703	98.703	98.632	98.668	10936.0
2014-09-12	FCE	Futures	3535.2	3539.2	3514.5	3530.8	9863.0
2014-09-12	FDAX	Futures	10695.4	10706.4	10591.3	10627.1	90452.0
2014-09-12	FESX	Futures	2341.2	2341.2	2321.6	2331.7	463110.0
2014-09-12	FEU3	Futures	98.626	98.626	98.626	98.626	8.0
2014-09-12	FGBL	Futures	130.66	130.67	130.18	130.29	658335.0
2014-09-12	FGBM	Futures	122.66	122.67	122.44	122.47	392014.0
2014-09-12	FGBS	Futures	110.948	110.953	110.908	110.913	166349.0
2014-09-12	FGBX	Futures	139.48	139.54	138.3	138.72	18774.0
2014-09-12	FMWO	Futures	5778.9	5778.9	5768.9	5768.9	101.0
2014-09-12	FOAT	Futures	120.39	120.43	119.98	120.14	73421.0
2014-09-12	FTDX	Futures	1186.1	1189.0	1186.1	1189.0	2.0
2014-09-12	FTI	Futures	361.65	361.82	360.35	360.96	850.0
2014-09-12	FTUK	Futures	5247.7	5253.9	5229.5	5241.5	32262.0
2014-09-12	FVSA	Futures	1420.84	1424.9	1388.37	1396.48	10180.0
2014-09-12	FXXP	Futures	260.9	261.1	260.1	260.5	7861.0
2014-09-12	G	Futures	96.14	96.23	95.85	95.97	136637.0
2014-09-12	GF	Futures	351.211	353.233	349.383	351.483	3216.0
2014-09-12	GSCI	Futures	990.6	990.6	984.79	985.72	1645.0
2014-09-12	HE	Futures	128.723	128.723	126.215	127.786	25251.0
2014-09-12	HG	Futures	3.9264	3.9435	3.9054	3.9403	33685.0
2014-09-12	HH	Futures	47.252	47.252	47.252	47.252	3625.0

> showing 50 of 103 rows — these rows as CSV

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