PREVIEW / futures_daily / 2014-09-02

all futures daily files

  file:    by_date/futures_daily/2014/2014-09-02.parquet
  size:    9 KB
  rows:    105

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-02	ES	Futures	2076.55	2084.09	2070.06	2077.33	1244899.0
2014-09-02	NQ	Futures	4705.97	4725.88	4702.8	4721.26	195212.0
2014-09-02	YM	Futures	17229.4	17283.9	17153.8	17206.2	117442.0
2014-09-02	CL	Futures	178.46	178.65	172.63	173.01	320356.0
2014-09-02	GC	Futures	1690.1	1693.2	1656.8	1659.2	190582.0
2014-09-02	ZN	Futures	117.907089	117.936267	117.323535	117.454834	222259.0
2014-09-02	A6	Futures	0.90059	0.90301	0.89489	0.89547	132682.0
2014-09-02	AD	Futures	0.93368	0.9352	0.9284	0.92941	71233.0
2014-09-02	ALI	Futures	3081.43	3081.43	3081.43	3081.43	24.0
2014-09-02	B	Futures	107.74	107.97	105.3	105.46	147038.0
2014-09-02	B6	Futures	1.7436	1.7496	1.731	1.7317	151953.0
2014-09-02	BR	Futures	0.23575	0.23591	0.23361	0.23478	614.0
2014-09-02	BZ	Futures	108.92	109.05	106.05	106.21	17875.0
2014-09-02	C	Futures	2133.0	2144.0	2103.0	2105.0	4302.0
2014-09-02	CB	Futures	149.53	152.42	149.337	150.301	13.0
2014-09-02	CC	Futures	2373.0	2379.0	2329.0	2336.0	22234.0
2014-09-02	CNH	Futures	7.0505	7.0561	7.0505	7.0535	30.0
2014-09-02	CSC	Futures	5.156	5.156	5.148	5.148	3.0
2014-09-02	CT	Futures	83.95	83.95	83.32	83.69	21.0
2014-09-02	DC	Futures	41.43	41.61	41.34	41.51	66.0
2014-09-02	DX	Futures	78.577	78.843	78.577	78.795	20300.0
2014-09-02	E1	Futures	1.39545	1.39699	1.39174	1.3943	55859.0
2014-09-02	E6	Futures	1.54925	1.55126	1.54701	1.5489	220081.0
2014-09-02	E7	Futures	1.5396	1.5411	1.5369	1.5388	2339.0
2014-09-02	ED	Futures	95.4162	95.4162	95.4139	95.4162	84080.0
2014-09-02	ER	Futures	97.96	97.965	97.955	97.955	61431.0
2014-09-02	EW	Futures	1491.6	1503.1	1489.4	1495.5	19361.0
2014-09-02	FBTP	Futures	94.89	94.89	94.47	94.55	104060.0
2014-09-02	FBTS	Futures	98.801	98.801	98.756	98.774	34360.0
2014-09-02	FCE	Futures	3494.6	3506.9	3472.3	3485.8	69199.0
2014-09-02	FDAX	Futures	10458.0	10551.1	10426.1	10468.5	92000.0
2014-09-02	FESX	Futures	2288.6	2300.8	2277.1	2285.0	1010884.0
2014-09-02	FGBL	Futures	131.76	131.76	131.18	131.38	1210071.0
2014-09-02	FGBM	Futures	122.59	122.59	122.46	122.52	721020.0
2014-09-02	FGBS	Futures	110.913	110.918	110.888	110.898	460939.0
2014-09-02	FGBX	Futures	143.45	143.45	141.75	142.18	55981.0
2014-09-02	FMWO	Futures	5831.8	5831.8	5812.9	5812.9	173.0
2014-09-02	FOAT	Futures	121.74	121.74	121.13	121.33	136236.0
2014-09-02	FTDX	Futures	1177.6	1179.0	1148.6	1171.1	321.0
2014-09-02	FTI	Futures	357.29	358.58	356.47	357.51	20503.0
2014-09-02	FTUK	Futures	5246.9	5266.9	5235.4	5246.5	72048.0
2014-09-02	FVSA	Futures	1506.43	1519.27	1489.32	1510.71	6959.0
2014-09-02	FXXP	Futures	259.1	259.4	257.4	258.0	6677.0
2014-09-02	G	Futures	97.0	97.03	96.58	96.77	178304.0
2014-09-02	GF	Futures	340.206	343.619	340.09	341.68	1293.0
2014-09-02	GSCI	Futures	1013.59	1014.93	1002.69	1004.04	230.0
2014-09-02	HE	Futures	119.565	122.255	119.384	120.744	27913.0
2014-09-02	HG	Futures	4.0088	4.0266	3.9828	4.0018	48214.0
2014-09-02	HH	Futures	49.127	49.127	47.657	47.657	637.0
2014-09-02	HO	Futures	2.2871	2.2888	2.2367	2.239	26596.0

> showing 50 of 105 rows — these rows as CSV

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