PREVIEW / futures_daily / 2015-03-20

all futures daily files

  file:    by_date/futures_daily/2015/2015-03-20.parquet
  size:    9 KB
  rows:    107

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
2015-03-20	ES	Futures	2186.52	2215.17	2184.68	2207.28	1417654.0
2015-03-20	NQ	Futures	5130.31	5192.43	5126.83	5163.4	210568.0
2015-03-20	YM	Futures	18288.7	18531.1	18282.6	18445.2	116676.0
2015-03-20	CL	Futures	80.41	83.53	78.93	82.02	379180.0
2015-03-20	GC	Futures	1530.3	1552.5	1527.0	1548.9	167531.0
2015-03-20	ZN	Futures	121.464955	121.96816	121.464955	121.894159	795754.0
2015-03-20	A6	Futures	0.75072	0.76571	0.75013	0.76295	107638.0
2015-03-20	AD	Futures	0.80209	0.81301	0.80158	0.81087	86670.0
2015-03-20	ALI	Futures	2683.97	2683.97	2683.97	2683.97	0.0
2015-03-20	B	Futures	53.59	54.79	52.7	54.44	186667.0
2015-03-20	B6	Futures	1.5523	1.577	1.5488	1.5719	125721.0
2015-03-20	BFX	Futures	4551.4	4551.4	4545.3	4545.3	5.0
2015-03-20	BR	Futures	0.16999	0.17462	0.16937	0.17319	361.0
2015-03-20	BZ	Futures	53.3	54.32	52.26	53.97	17597.0
2015-03-20	C	Futures	2098.0	2127.0	2085.0	2125.0	10747.0
2015-03-20	CB	Futures	141.6	142.005	141.398	141.398	25.0
2015-03-20	CC	Futures	2001.0	2063.0	1991.0	2060.0	21847.0
2015-03-20	CNH	Futures	7.0483	7.0653	7.0409	7.0409	54.0
2015-03-20	CSC	Futures	4.25	4.287	4.242	4.268	32.0
2015-03-20	CT	Futures	80.29	81.08	79.85	80.52	12979.0
2015-03-20	DC	Futures	34.59	34.59	34.21	34.53	213.0
2015-03-20	DX	Futures	93.24	93.39	91.733	92.18	87647.0
2015-03-20	E1	Futures	1.29047	1.31392	1.29034	1.3092	23376.0
2015-03-20	E6	Futures	1.25472	1.28106	1.25448	1.27271	321780.0
2015-03-20	E7	Futures	1.2472	1.2736	1.2472	1.2653	8760.0
2015-03-20	EBM	Futures	313.31	316.52	312.91	315.72	18554.0
2015-03-20	ED	Futures	95.495	95.5094	95.4902	95.4998	155184.0
2015-03-20	ER	Futures	98.053	98.063	98.048	98.053	36523.0
2015-03-20	EW	Futures	1591.0	1611.8	1590.9	1607.4	21206.0
2015-03-20	FBTP	Futures	103.87	104.24	103.81	104.13	59531.0
2015-03-20	FBTS	Futures	99.581	99.626	99.572	99.599	11428.0
2015-03-20	FCE	Futures	4098.9	4147.7	4089.5	4133.8	112515.0
2015-03-20	FDAX	Futures	13274.7	13442.2	13261.4	13412.3	122962.0
2015-03-20	FDIV	Futures	165.65	167.36	165.65	167.36	10.0
2015-03-20	FESX	Futures	2657.8	2699.8	2649.0	2695.4	1294297.0
2015-03-20	FGBL	Futures	141.07	141.24	140.89	141.05	369248.0
2015-03-20	FGBM	Futures	124.81	124.85	124.76	124.82	246855.0
2015-03-20	FGBS	Futures	111.243	111.248	111.228	111.243	125296.0
2015-03-20	FGBX	Futures	177.94	178.08	176.89	177.45	24806.0
2015-03-20	FMWO	Futures	5791.6	5847.1	5790.3	5847.1	1706.0
2015-03-20	FOAT	Futures	129.98	130.22	129.93	130.08	44381.0
2015-03-20	FTDX	Futures	1547.6	1566.8	1547.6	1556.1	1263.0
2015-03-20	FTI	Futures	428.86	432.41	427.91	431.16	32110.0
2015-03-20	FTUK	Futures	5461.0	5507.9	5439.3	5488.9	108795.0
2015-03-20	FVSA	Futures	1804.12	1821.06	1727.89	1740.59	7444.0
2015-03-20	FXXP	Futures	303.2	306.2	302.8	305.7	14027.0
2015-03-20	G	Futures	105.47	105.6	105.14	105.45	118279.0
2015-03-20	GF	Futures	366.735	367.965	364.996	366.778	2571.0
2015-03-20	GSCI	Futures	684.39	688.61	683.1	685.77	361.0
2015-03-20	HE	Futures	79.26	80.764	78.537	78.971	317.0

> showing 50 of 107 rows — these rows as CSV

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