PREVIEW / futures_daily / 2015-05-01

all futures daily files

  file:    by_date/futures_daily/2015/2015-05-01.parquet
  size:    9 KB
  rows:    86

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-05-01	ES	Futures	2189.93	2210.7	2187.57	2209.65	1022085.0
2015-05-01	NQ	Futures	5124.8	5190.69	5119.86	5187.2	197160.0
2015-05-01	YM	Futures	18186.4	18363.4	18179.3	18344.0	110840.0
2015-05-01	CL	Futures	101.52	101.71	99.03	100.44	244753.0
2015-05-01	GC	Futures	1548.9	1549.8	1528.8	1536.8	118476.0
2015-05-01	ZN	Futures	121.672157	121.672157	120.991349	121.03575	890606.0
2015-05-01	A6	Futures	0.77755	0.77814	0.76779	0.76976	91526.0
2015-05-01	AD	Futures	0.84559	0.84559	0.83609	0.83844	55056.0
2015-05-01	ALI	Futures	2587.62	2587.62	2587.62	2587.62	0.0
2015-05-01	B	Futures	64.18	64.38	63.09	63.99	117793.0
2015-05-01	B6	Futures	1.6156	1.6202	1.5905	1.5922	127325.0
2015-05-01	BR	Futures	0.18714	0.18768	0.1842	0.18457	996.0
2015-05-01	BZ	Futures	63.68	63.71	62.52	63.38	13680.0
2015-05-01	C	Futures	2172.0	2191.0	2144.0	2157.0	3063.0
2015-05-01	CB	Futures	152.322	153.131	152.322	152.929	19.0
2015-05-01	CC	Futures	2188.0	2189.0	2108.0	2122.0	16889.0
2015-05-01	CSC	Futures	4.484	4.506	4.479	4.487	17.0
2015-05-01	CT	Futures	85.65	85.82	82.79	83.91	21498.0
2015-05-01	DC	Futures	36.8	37.0	36.75	36.95	223.0
2015-05-01	DX	Futures	89.146	89.714	88.827	89.62	53207.0
2015-05-01	E1	Futures	1.36821	1.37572	1.36489	1.36617	20502.0
2015-05-01	E6	Futures	1.31986	1.32845	1.31481	1.3168	194427.0
2015-05-01	E7	Futures	1.3119	1.3208	1.3071	1.3092	5592.0
2015-05-01	ED	Futures	95.5429	95.5477	95.5381	95.5429	86174.0
2015-05-01	ER	Futures	98.073	98.077	98.063	98.068	10643.0
2015-05-01	EW	Futures	1572.0	1586.2	1571.9	1581.7	21598.0
2015-05-01	FTUK	Futures	5446.8	5519.3	5423.9	5474.4	54702.0
2015-05-01	G	Futures	103.03	103.32	102.72	102.88	93512.0
2015-05-01	GF	Futures	366.643	369.092	364.409	367.115	1730.0
2015-05-01	GSCI	Futures	755.19	757.57	749.31	755.27	300.0
2015-05-01	HE	Futures	89.005	89.005	87.702	88.245	15591.0
2015-05-01	HG	Futures	3.6198	3.6857	3.6073	3.6756	43682.0
2015-05-01	HH	Futures	33.097	33.984	32.976	33.729	3596.0
2015-05-01	HO	Futures	1.6104	1.6156	1.5883	1.6102	49876.0
2015-05-01	HRC	Futures	1806.2	1806.2	1806.2	1806.2	0.0
2015-05-01	J1	Futures	0.0104755	0.0104755	0.0103968	0.010398	112950.0
2015-05-01	J7	Futures	0.010469	0.010471	0.010396	0.010396	614.0
2015-05-01	JB	Futures	133.91	133.94	133.65	133.74	2408.0
2015-05-01	KC	Futures	226.48	227.71	218.16	220.96	18395.0
2015-05-01	KE	Futures	1575.56	1588.93	1559.04	1574.77	12071.0
2015-05-01	L	Futures	99.065	99.065	99.055	99.065	14607.0
2015-05-01	LBS	Futures	405.7	410.5	404.4	409.4	434.0
2015-05-01	LE	Futures	188.666	189.991	187.278	188.256	25577.0
2015-05-01	MFS	Futures	1891.4	1909.1	1887.5	1904.3	12333.0
2015-05-01	MGC	Futures	1522.0	1522.7	1502.5	1509.8	1268.0
2015-05-01	MME	Futures	1026.4	1032.8	1023.5	1030.3	23964.0
2015-05-01	MP	Futures	0.04018	0.0402	0.03951	0.03952	40839.0
2015-05-01	N6	Futures	0.69489	0.69544	0.68544	0.68645	21081.0
2015-05-01	NG	Futures	45.965	47.023	45.579	46.62	118891.0
2015-05-01	NIY	Futures	16386.1	16668.7	16373.4	16630.7	29867.0

> showing 50 of 86 rows — these rows as CSV

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