PREVIEW / futures_daily / 2015-07-21

all futures daily files

  file:    by_date/futures_daily/2015/2015-07-21.parquet
  size:    9 KB
  rows:    106

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-07-21	ES	Futures	2248.14	2252.11	2232.77	2240.98	1209300.0
2015-07-21	NQ	Futures	5453.77	5467.49	5384.01	5448.23	226216.0
2015-07-21	YM	Futures	18471.0	18506.9	18266.6	18348.8	122821.0
2015-07-21	CL	Futures	83.43	85.36	83.15	84.45	254321.0
2015-07-21	GC	Futures	1434.0	1448.1	1431.2	1441.2	172518.0
2015-07-21	ZN	Futures	120.109035	120.466724	119.885479	120.377301	827090.0
2015-07-21	A6	Futures	0.72772	0.73564	0.72494	0.73316	82585.0
2015-07-21	AD	Futures	0.786	0.79121	0.78539	0.78856	55081.0
2015-07-21	ALI	Futures	2218.72	2218.72	2218.72	2218.72	10.0
2015-07-21	B	Futures	52.62	53.45	52.42	53.08	188877.0
2015-07-21	B6	Futures	1.6367	1.6404	1.6337	1.6365	62881.0
2015-07-21	BFX	Futures	4655.6	4656.8	4621.1	4621.1	3.0
2015-07-21	BR	Futures	0.18515	0.18659	0.18474	0.18608	661.0
2015-07-21	BZ	Futures	52.55	53.41	52.39	53.05	24714.0
2015-07-21	C	Futures	2382.0	2393.0	2373.0	2383.0	4473.0
2015-07-21	CB	Futures	151.173	155.61	151.173	155.61	46.0
2015-07-21	CC	Futures	2460.0	2476.0	2451.0	2453.0	8334.0
2015-07-21	CNH	Futures	7.0046	7.0091	7.0011	7.0011	67.0
2015-07-21	CSC	Futures	4.277	4.353	4.267	4.353	32.0
2015-07-21	CT	Futures	80.39	80.39	80.03	80.03	3.0
2015-07-21	DC	Futures	34.18	35.13	34.07	35.06	268.0
2015-07-21	DX	Futures	91.877	92.013	91.007	91.199	43422.0
2015-07-21	E1	Futures	1.31881	1.33062	1.31818	1.32745	13495.0
2015-07-21	E6	Futures	1.27229	1.28956	1.27112	1.28639	217564.0
2015-07-21	E7	Futures	1.2656	1.2824	1.264	1.2793	4207.0
2015-07-21	EBM	Futures	311.52	311.93	307.42	309.47	15390.0
2015-07-21	ED	Futures	95.6175	95.627	95.6127	95.6222	118834.0
2015-07-21	ER	Futures	98.112	98.112	98.107	98.112	11851.0
2015-07-21	EW	Futures	1575.2	1580.4	1563.0	1564.7	16002.0
2015-07-21	FBTP	Futures	100.48	100.55	99.55	99.73	60131.0
2015-07-21	FBTS	Futures	99.981	99.999	99.91	99.955	16402.0
2015-07-21	FCE	Futures	4299.6	4301.7	4246.3	4258.3	69787.0
2015-07-21	FDAX	Futures	13026.2	13026.2	12790.7	12834.4	72119.0
2015-07-21	FESX	Futures	2734.6	2735.3	2690.2	2698.3	788790.0
2015-07-21	FGBL	Futures	136.51	136.79	136.06	136.28	465064.0
2015-07-21	FGBM	Futures	124.37	124.43	124.23	124.28	301304.0
2015-07-21	FGBS	Futures	111.198	111.208	111.188	111.198	120599.0
2015-07-21	FGBX	Futures	154.34	155.22	152.7	153.31	24668.0
2015-07-21	FMWO	Futures	5895.0	5895.0	5876.6	5876.6	22.0
2015-07-21	FOAT	Futures	125.06	125.31	124.47	124.67	56255.0
2015-07-21	FTDX	Futures	1723.8	1725.2	1703.6	1708.7	499.0
2015-07-21	FTI	Futures	431.91	433.03	426.9	428.28	22146.0
2015-07-21	FTUK	Futures	5366.4	5367.6	5323.1	5334.6	61464.0
2015-07-21	FVSA	Futures	1719.45	1754.54	1679.97	1745.77	13722.0
2015-07-21	FXXP	Futures	312.6	313.1	307.7	308.6	6636.0
2015-07-21	G	Futures	101.21	101.31	100.73	101.01	208749.0
2015-07-21	GF	Futures	367.199	367.624	361.036	362.269	4428.0
2015-07-21	GSCI	Futures	666.41	672.24	665.24	667.82	24.0
2015-07-21	HE	Futures	83.889	85.341	83.554	84.755	15548.0
2015-07-21	HG	Futures	3.0838	3.1399	3.0838	3.0882	39610.0

> showing 50 of 106 rows — these rows as CSV

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