PREVIEW / futures_daily / 2017-05-01

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-01.parquet
  size:    8 KB
  rows:    82

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
2017-05-01	ES	Futures	2586.41	2596.46	2581.52	2592.39	906278.0
2017-05-01	NQ	Futures	6573.24	6639.49	6564.41	6631.84	166028.0
2017-05-01	YM	Futures	22046.7	22077.3	21978.1	22024.5	86530.0
2017-05-01	CL	Futures	51.3	51.46	50.7	50.96	364386.0
2017-05-01	GC	Futures	1623.6	1627.2	1604.8	1605.5	199783.0
2017-05-01	ZN	Futures	123.613189	123.690006	123.229106	123.367376	948935.0
2017-05-01	A6	Futures	0.76736	0.77342	0.76654	0.7728	51884.0
2017-05-01	AD	Futures	0.74733	0.7483	0.7456	0.74672	39490.0
2017-05-01	ALI	Futures	2551.99	2551.99	2551.99	2551.99	0.0
2017-05-01	B	Futures	37.21	37.27	36.73	36.95	121525.0
2017-05-01	B6	Futures	1.3586	1.359	1.3524	1.3546	45151.0
2017-05-01	BR	Futures	0.22618	0.22654	0.22361	0.22455	377.0
2017-05-01	BZ	Futures	36.92	37.01	36.47	36.68	12936.0
2017-05-01	CB	Futures	259.434	260.013	259.434	259.983	14.0
2017-05-01	CC	Futures	1398.0	1405.0	1380.0	1385.0	9827.0
2017-05-01	CSC	Futures	3.491	3.498	3.489	3.493	23.0
2017-05-01	CT	Futures	87.29	87.71	86.95	87.44	9695.0
2017-05-01	DC	Futures	29.06	29.06	28.76	28.89	187.0
2017-05-01	DX	Futures	92.17	92.3	91.988	92.17	17673.0
2017-05-01	E1	Futures	1.24552	1.24824	1.24342	1.24453	10058.0
2017-05-01	E6	Futures	1.25795	1.26124	1.25663	1.25911	69677.0
2017-05-01	E7	Futures	1.2519	1.2547	1.2503	1.2527	2069.0
2017-05-01	ED	Futures	95.5591	95.5591	95.5446	95.5542	132764.0
2017-05-01	ER	Futures	98.337	98.337	98.337	98.337	0.0
2017-05-01	EW	Futures	1838.4	1851.9	1833.4	1844.9	14189.0
2017-05-01	GF	Futures	343.115	345.865	338.017	340.481	3394.0
2017-05-01	GSCI	Futures	479.83	480.21	478.57	479.7	232.0
2017-05-01	HE	Futures	80.064	80.388	79.009	79.279	13371.0
2017-05-01	HG	Futures	3.1861	3.3032	3.18	3.2615	50680.0
2017-05-01	HH	Futures	21.722	21.841	21.179	21.278	1788.0
2017-05-01	HO	Futures	1.0085	1.0117	0.9887	0.9962	57453.0
2017-05-01	HRC	Futures	1658.7	1658.7	1658.7	1658.7	0.0
2017-05-01	J1	Futures	0.0110396	0.0110593	0.0109874	0.0109979	93105.0
2017-05-01	J7	Futures	0.011017	0.011033	0.010967	0.010975	1178.0
2017-05-01	JB	Futures	138.19	138.23	138.18	138.19	316.0
2017-05-01	KC	Futures	180.48	185.12	180.07	182.97	13996.0
2017-05-01	KE	Futures	980.53	1032.49	980.53	1029.73	63721.0
2017-05-01	LBS	Futures	479.4	493.0	478.6	487.3	457.0
2017-05-01	LE	Futures	187.367	188.419	185.901	186.615	37243.0
2017-05-01	MFS	Futures	1884.1	1901.8	1881.1	1898.6	11035.0
2017-05-01	MGC	Futures	1605.6	1609.4	1587.2	1587.8	3749.0
2017-05-01	MME	Futures	987.3	994.8	987.3	991.8	28794.0
2017-05-01	MP	Futures	0.0349	0.03511	0.03485	0.03507	13914.0
2017-05-01	N6	Futures	0.67607	0.68139	0.67429	0.6803	12579.0
2017-05-01	NG	Futures	28.512	29.074	28.065	28.214	128608.0
2017-05-01	NIY	Futures	16535.5	16673.2	16496.7	16651.7	17983.0
2017-05-01	NKD	Futures	17635.9	17782.7	17599.2	17764.4	5783.0
2017-05-01	NOK	Futures	0.1216	0.121841	0.1216	0.121841	11.0
2017-05-01	OJ	Futures	141.31	141.53	136.88	138.12	840.0
2017-05-01	PA	Futures	879.58	881.39	865.43	866.34	2982.0

> showing 50 of 82 rows — these rows as CSV

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