PREVIEW / futures_daily / 2014-05-01

all futures daily files

  file:    by_date/futures_daily/2014/2014-05-01.parquet
  size:    8 KB
  rows:    85

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-01	ES	Futures	1944.6	1947.96	1936.32	1942.79	938351.0
2014-05-01	NQ	Futures	4117.5	4150.31	4110.02	4128.73	195192.0
2014-05-01	YM	Futures	16582.7	16604.8	16523.5	16555.6	81624.0
2014-05-01	CL	Futures	180.62	180.93	178.84	180.08	235455.0
2014-05-01	GC	Futures	1702.2	1703.6	1683.0	1691.0	115436.0
2014-05-01	ZN	Futures	115.35934	115.707027	115.243445	115.576644	952433.0
2014-05-01	A6	Futures	0.88934	0.89203	0.88693	0.88809	39156.0
2014-05-01	AD	Futures	0.92414	0.92475	0.9211	0.92343	34800.0
2014-05-01	B	Futures	111.31	111.34	110.06	110.98	98246.0
2014-05-01	B6	Futures	1.773	1.7779	1.7726	1.7751	54775.0
2014-05-01	BZ	Futures	113.4	113.4	112.26	113.19	9297.0
2014-05-01	C	Futures	1921.0	1922.0	1889.0	1896.0	6743.0
2014-05-01	CB	Futures	101.538	104.331	101.538	104.191	33.0
2014-05-01	CC	Futures	2187.0	2188.0	2146.0	2155.0	20702.0
2014-05-01	CNH	Futures	7.1779	7.1813	7.1724	7.1752	11.0
2014-05-01	CSC	Futures	4.578	4.665	4.578	4.66	28.0
2014-05-01	CT	Futures	106.05	106.44	105.56	106.07	7063.0
2014-05-01	DC	Futures	37.04	37.92	36.95	37.8	484.0
2014-05-01	DX	Futures	75.594	75.627	75.508	75.602	7315.0
2014-05-01	E1	Futures	1.45907	1.46176	1.45817	1.4601	13072.0
2014-05-01	E6	Futures	1.63682	1.63954	1.63647	1.63658	59152.0
2014-05-01	E7	Futures	1.6258	1.6286	1.6256	1.6257	1271.0
2014-05-01	ED	Futures	95.4138	95.4186	95.4138	95.4138	50684.0
2014-05-01	ER	Futures	97.842	97.852	97.842	97.842	16584.0
2014-05-01	EW	Futures	1397.3	1407.1	1389.9	1397.8	18554.0
2014-05-01	FTUK	Futures	5154.6	5169.8	5142.4	5164.1	44094.0
2014-05-01	G	Futures	94.13	94.37	93.93	94.31	65614.0
2014-05-01	GF	Futures	288.548	292.845	288.15	292.765	2119.0
2014-05-01	GSCI	Futures	1072.96	1076.61	1070.72	1075.28	599.0
2014-05-01	HE	Futures	137.268	138.217	136.18	137.045	20306.0
2014-05-01	HG	Futures	3.8557	3.8768	3.8372	3.8608	28767.0
2014-05-01	HH	Futures	60.352	60.821	59.68	59.82	580.0
2014-05-01	HO	Futures	2.3345	2.3349	2.3055	2.3222	56166.0
2014-05-01	HRC	Futures	2419.8	2419.8	2419.8	2419.8	0.0
2014-05-01	J1	Futures	0.0122895	0.0123008	0.0122681	0.0122795	57037.0
2014-05-01	J7	Futures	0.01228	0.012286	0.012257	0.012266	210.0
2014-05-01	JB	Futures	130.12	130.19	130.12	130.19	747.0
2014-05-01	KC	Futures	372.9	377.16	368.1	370.18	8829.0
2014-05-01	KE	Futures	2655.75	2668.82	2608.39	2626.35	14979.0
2014-05-01	L	Futures	98.896	98.906	98.896	98.896	21193.0
2014-05-01	LBS	Futures	541.5	545.1	539.4	544.3	170.0
2014-05-01	LE	Futures	170.755	173.681	170.631	173.37	37784.0
2014-05-01	MFS	Futures	1845.5	1845.5	1831.5	1836.6	4713.0
2014-05-01	MGC	Futures	1672.1	1672.6	1652.2	1660.1	876.0
2014-05-01	MME	Futures	945.1	948.3	939.4	945.8	6663.0
2014-05-01	MP	Futures	0.04602	0.04618	0.04599	0.04615	12095.0
2014-05-01	N6	Futures	0.76065	0.76304	0.75941	0.76189	6408.0
2014-05-01	NG	Futures	82.496	82.944	80.949	81.155	101313.0
2014-05-01	NIY	Futures	11924.7	12091.5	11924.7	12058.1	18221.0
2014-05-01	NKD	Futures	13205.7	13399.5	13205.7	13358.0	9170.0

> showing 50 of 85 rows — these rows as CSV

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