PREVIEW / futures_daily / 2017-08-31

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-31.parquet
  size:    9 KB
  rows:    109

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-08-31	ES	Futures	2668.42	2689.07	2667.88	2684.45	1752826.0
2017-08-31	NQ	Futures	6978.31	7050.9	6973.9	7042.37	273833.0
2017-08-31	YM	Futures	23135.9	23240.5	23123.2	23203.5	114407.0
2017-08-31	CL	Futures	47.16	48.72	46.78	48.47	882983.0
2017-08-31	GC	Futures	1672.1	1691.0	1657.1	1682.4	312013.0
2017-08-31	ZN	Futures	125.227319	125.381218	125.073421	125.335048	252047.0
2017-08-31	A6	Futures	0.81194	0.81656	0.80845	0.81646	112195.0
2017-08-31	AD	Futures	0.80619	0.81535	0.80329	0.81397	112396.0
2017-08-31	ALI	Futures	2750.2	2750.2	2750.2	2750.2	10.0
2017-08-31	B	Futures	35.43	37.1	35.41	37.07	462166.0
2017-08-31	B6	Futures	1.3515	1.3525	1.3436	1.3523	105712.0
2017-08-31	BR	Futures	0.23539	0.2366	0.23456	0.2366	14.0
2017-08-31	BZ	Futures	35.2	36.77	34.97	36.75	37019.0
2017-08-31	C	Futures	1519.0	1530.0	1494.0	1515.0	7518.0
2017-08-31	CB	Futures	317.484	317.515	314.933	314.965	63.0
2017-08-31	CC	Futures	1434.0	1440.0	1408.0	1430.0	18203.0
2017-08-31	CNH	Futures	6.8246	6.8263	6.8155	6.8155	22.0
2017-08-31	CSC	Futures	3.449	3.449	3.425	3.425	51.0
2017-08-31	CT	Futures	83.14	83.48	83.03	83.42	12.0
2017-08-31	DC	Futures	28.67	28.67	28.4	28.44	116.0
2017-08-31	DX	Futures	86.71	87.125	86.434	86.493	38284.0
2017-08-31	E1	Futures	1.2769	1.28279	1.2699	1.2807	36924.0
2017-08-31	E6	Futures	1.36376	1.36605	1.35563	1.36479	252044.0
2017-08-31	E7	Futures	1.3566	1.3587	1.3485	1.3576	5654.0
2017-08-31	EBM	Futures	172.86	173.7	172.31	173.42	5331.0
2017-08-31	ED	Futures	95.5983	95.6007	95.5935	95.6007	123880.0
2017-08-31	ER	Futures	98.342	98.342	98.337	98.342	39867.0
2017-08-31	EW	Futures	1821.0	1838.9	1819.9	1838.1	13379.0
2017-08-31	FBON	Futures	124.76	125.37	124.71	124.97	796.0
2017-08-31	FBTP	Futures	108.84	109.43	108.73	109.22	124349.0
2017-08-31	FBTS	Futures	103.045	103.136	103.027	103.118	70325.0
2017-08-31	FCE	Futures	4538.7	4566.9	4533.7	4549.4	79356.0
2017-08-31	FDAX	Futures	12680.2	12754.5	12665.0	12704.4	82560.0
2017-08-31	FDXM	Futures	12604.3	12674.4	12587.5	12626.3	27358.0
2017-08-31	FESX	Futures	2790.0	2806.3	2785.9	2794.9	861680.0
2017-08-31	FGBL	Futures	150.01	150.16	149.76	149.97	706070.0
2017-08-31	FGBM	Futures	129.91	129.95	129.81	129.88	612112.0
2017-08-31	FGBS	Futures	112.462	112.477	112.452	112.462	327768.0
2017-08-31	FGBX	Futures	170.0	170.45	169.6	170.1	59126.0
2017-08-31	FMWO	Futures	6518.6	6561.5	6513.8	6537.6	2355.0
2017-08-31	FOAT	Futures	136.7	136.98	136.52	136.85	188946.0
2017-08-31	FTDX	Futures	2276.2	2300.7	2276.2	2294.7	86.0
2017-08-31	FTI	Futures	476.72	479.17	476.16	477.74	21459.0
2017-08-31	FTUK	Futures	6377.0	6429.7	6369.2	6423.2	101728.0
2017-08-31	FVSA	Futures	506.96	511.69	497.52	502.24	14987.0
2017-08-31	FXXP	Futures	317.2	319.2	316.7	318.5	30253.0
2017-08-31	G	Futures	116.38	116.61	116.35	116.52	173843.0
2017-08-31	GF	Futures	315.387	318.95	310.838	312.592	2533.0
2017-08-31	GSCI	Futures	457.86	462.23	457.86	460.79	1313.0
2017-08-31	HE	Futures	86.325	87.62	85.765	85.94	29372.0

> showing 50 of 109 rows — these rows as CSV

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