PREVIEW / futures_daily / 2014-09-09

all futures daily files

  file:    by_date/futures_daily/2014/2014-09-09.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-09-09	ES	Futures	2077.85	2080.71	2060.19	2066.95	1768258.0
2014-09-09	NQ	Futures	4721.84	4742.61	4676.55	4691.26	386107.0
2014-09-09	YM	Futures	17253.6	17275.8	17137.6	17187.0	161367.0
2014-09-09	CL	Futures	173.43	174.98	172.34	172.76	275876.0
2014-09-09	GC	Futures	1648.9	1651.2	1637.1	1637.6	128253.0
2014-09-09	ZN	Futures	117.016458	117.075032	116.752875	116.826092	1273089.0
2014-09-09	A6	Futures	0.89634	0.8974	0.88764	0.88842	175172.0
2014-09-09	AD	Futures	0.92505	0.92606	0.92037	0.92291	84102.0
2014-09-09	ALI	Futures	3045.35	3045.35	3045.35	3045.35	10.0
2014-09-09	B	Futures	105.32	105.77	104.25	104.39	167592.0
2014-09-09	B6	Futures	1.6918	1.6983	1.6882	1.6914	202441.0
2014-09-09	BFX	Futures	3877.1	3877.1	3864.0	3864.0	6.0
2014-09-09	BR	Futures	0.23137	0.23164	0.23054	0.23089	2238.0
2014-09-09	BZ	Futures	105.94	106.48	105.0	105.13	12535.0
2014-09-09	C	Futures	2108.0	2129.0	2097.0	2125.0	12367.0
2014-09-09	CB	Futures	161.862	163.404	160.321	160.417	10.0
2014-09-09	CC	Futures	2255.0	2279.0	2237.0	2273.0	18106.0
2014-09-09	CNH	Futures	7.035	7.0351	7.035	7.0351	1.0
2014-09-09	CSC	Futures	5.108	5.129	5.108	5.116	25.0
2014-09-09	CT	Futures	83.97	86.48	83.97	85.51	57.0
2014-09-09	DC	Futures	41.01	41.53	41.01	41.49	185.0
2014-09-09	DX	Futures	80.067	80.233	79.783	80.005	43281.0
2014-09-09	E1	Futures	1.37071	1.3761	1.36674	1.37251	59057.0
2014-09-09	E6	Futures	1.52211	1.52908	1.51739	1.52436	334354.0
2014-09-09	E7	Futures	1.5121	1.5191	1.5076	1.5144	4724.0
2014-09-09	ED	Futures	95.4186	95.4186	95.4139	95.4186	128100.0
2014-09-09	ER	Futures	98.009	98.014	98.004	98.014	34584.0
2014-09-09	EW	Futures	1493.7	1497.2	1480.1	1483.8	25358.0
2014-09-09	FBTP	Futures	95.21	95.3	94.61	94.91	78083.0
2014-09-09	FBTS	Futures	98.81	98.828	98.712	98.757	16349.0
2014-09-09	FCE	Futures	3553.1	3569.8	3532.0	3546.0	66448.0
2014-09-09	FDAX	Futures	10711.3	10760.9	10655.2	10695.4	101490.0
2014-09-09	FESX	Futures	2339.7	2350.5	2323.8	2333.2	885528.0
2014-09-09	FEU3	Futures	98.631	98.631	98.631	98.631	5.0
2014-09-09	FGBL	Futures	130.93	130.99	130.52	130.73	958826.0
2014-09-09	FGBM	Futures	122.62	122.7	122.54	122.62	499194.0
2014-09-09	FGBS	Futures	110.938	110.963	110.938	110.958	195021.0
2014-09-09	FGBX	Futures	140.03	140.11	138.78	139.3	29056.0
2014-09-09	FMWO	Futures	5775.1	5780.2	5775.1	5780.2	10.0
2014-09-09	FOAT	Futures	121.28	121.28	120.7	120.9	96065.0
2014-09-09	FTDX	Futures	1152.8	1184.6	1152.8	1178.6	140.0
2014-09-09	FTI	Futures	361.3	362.46	359.27	360.39	19391.0
2014-09-09	FTUK	Futures	5245.0	5266.5	5239.6	5251.5	80056.0
2014-09-09	FVSA	Futures	1382.32	1403.72	1369.49	1399.44	8038.0
2014-09-09	FXXP	Futures	260.0	261.4	259.8	259.9	8201.0
2014-09-09	G	Futures	96.21	96.48	96.01	96.44	244083.0
2014-09-09	GF	Futures	351.57	355.719	351.57	354.672	1051.0
2014-09-09	GSCI	Futures	1003.03	1003.28	996.49	997.41	1827.0
2014-09-09	HE	Futures	125.006	128.24	124.582	127.877	28504.0
2014-09-09	HG	Futures	4.0418	4.0424	3.9219	3.9346	71752.0

> showing 50 of 106 rows — these rows as CSV

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