PREVIEW / futures_daily / 2014-05-20

all futures daily files

  file:    by_date/futures_daily/2014/2014-05-20.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-05-20	ES	Futures	1946.67	1949.77	1929.34	1932.7	1564172.0
2014-05-20	NQ	Futures	4156.93	4171.32	4126.14	4139.95	297810.0
2014-05-20	YM	Futures	16547.6	16572.7	16376.9	16404.0	151409.0
2014-05-20	CL	Futures	185.73	187.37	184.97	186.13	249769.0
2014-05-20	GC	Futures	1703.6	1709.2	1694.4	1705.8	129486.0
2014-05-20	ZN	Futures	116.518294	116.86598	116.474833	116.822519	1172304.0
2014-05-20	A6	Futures	0.89443	0.8952	0.88607	0.88751	85348.0
2014-05-20	AD	Futures	0.93205	0.93215	0.9282	0.93012	41409.0
2014-05-20	ALI	Futures	2669.57	2669.57	2669.57	2669.57	0.0
2014-05-20	B	Futures	113.18	113.87	112.94	113.55	172785.0
2014-05-20	B6	Futures	1.7668	1.7724	1.7656	1.7695	59451.0
2014-05-20	BFX	Futures	3756.5	3756.5	3749.2	3749.2	18.0
2014-05-20	BR	Futures	0.2371	0.23755	0.23655	0.23673	241.0
2014-05-20	BZ	Futures	115.3	116.14	115.08	115.81	10468.0
2014-05-20	C	Futures	1905.0	1929.0	1903.0	1927.0	10275.0
2014-05-20	CB	Futures	105.905	106.641	105.905	106.615	20.0
2014-05-20	CC	Futures	2161.0	2193.0	2155.0	2189.0	10453.0
2014-05-20	CSC	Futures	4.321	4.357	4.301	4.332	73.0
2014-05-20	CT	Futures	100.44	101.05	99.89	100.22	12523.0
2014-05-20	DC	Futures	34.92	35.34	34.8	35.11	263.0
2014-05-20	DX	Futures	76.078	76.164	76.054	76.091	7927.0
2014-05-20	E1	Futures	1.43866	1.43995	1.43584	1.43853	20894.0
2014-05-20	E6	Futures	1.61829	1.61876	1.61451	1.61687	111697.0
2014-05-20	E7	Futures	1.6076	1.6079	1.6039	1.6061	1704.0
2014-05-20	ED	Futures	95.4162	95.4162	95.4114	95.4138	129989.0
2014-05-20	ER	Futures	97.867	97.876	97.867	97.876	35208.0
2014-05-20	EW	Futures	1400.3	1403.2	1380.3	1383.9	19672.0
2014-05-20	FBTP	Futures	88.33	88.6	87.53	87.8	126104.0
2014-05-20	FBTS	Futures	97.258	97.337	96.985	97.135	23973.0
2014-05-20	FCE	Futures	3542.5	3551.7	3515.0	3534.1	68366.0
2014-05-20	FDAX	Futures	10674.8	10704.6	10594.8	10652.7	83752.0
2014-05-20	FESX	Futures	2269.3	2275.0	2250.6	2265.0	662892.0
2014-05-20	FEU3	Futures	98.492	98.497	98.492	98.497	113.0
2014-05-20	FGBL	Futures	126.07	126.28	125.95	126.07	584964.0
2014-05-20	FGBM	Futures	120.7	120.84	120.68	120.74	358659.0
2014-05-20	FGBS	Futures	110.693	110.718	110.678	110.708	195899.0
2014-05-20	FGBX	Futures	131.32	131.5	130.71	130.97	16972.0
2014-05-20	FMWO	Futures	5601.1	5601.1	5584.7	5584.7	30.0
2014-05-20	FOAT	Futures	115.43	115.45	115.19	115.25	56193.0
2014-05-20	FTDX	Futures	1154.1	1165.8	1154.1	1160.2	136.0
2014-05-20	FTI	Futures	346.4	346.96	344.41	345.84	18160.0
2014-05-20	FTUK	Futures	5211.0	5213.3	5156.5	5174.8	78501.0
2014-05-20	FVSA	Futures	1653.06	1653.06	1606.36	1611.03	12509.0
2014-05-20	FXXP	Futures	253.3	253.9	251.9	253.0	9317.0
2014-05-20	G	Futures	94.82	94.86	94.56	94.68	111628.0
2014-05-20	GF	Futures	301.232	303.301	299.469	300.274	3874.0
2014-05-20	GSCI	Futures	1081.99	1085.96	1081.24	1082.07	99.0
2014-05-20	HE	Futures	133.362	133.725	132.246	132.358	13572.0
2014-05-20	HG	Futures	4.0403	4.0602	3.9905	4.0186	35703.0
2014-05-20	HH	Futures	56.917	57.817	56.917	57.703	5019.0

> showing 50 of 105 rows — these rows as CSV

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