PREVIEW / futures_daily / 2017-08-30

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-30.parquet
  size:    9 KB
  rows:    110

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-30	ES	Futures	2658.91	2673.31	2654.84	2668.96	1301444.0
2017-08-30	NQ	Futures	6900.13	6987.42	6891.61	6976.84	273971.0
2017-08-30	YM	Futures	23121.1	23213.0	23078.8	23120.0	115725.0
2017-08-30	CL	Futures	47.53	47.95	47.05	47.17	895643.0
2017-08-30	GC	Futures	1673.0	1678.7	1667.0	1672.1	460450.0
2017-08-30	ZN	Futures	125.288879	125.319658	125.073421	125.16576	1221758.0
2017-08-30	A6	Futures	0.81667	0.82119	0.8104	0.81174	100287.0
2017-08-30	AD	Futures	0.8128	0.81377	0.80497	0.80624	70557.0
2017-08-30	ALI	Futures	2734.78	2734.78	2731.0	2731.0	0.0
2017-08-30	B	Futures	36.22	36.25	35.43	35.57	437318.0
2017-08-30	B6	Futures	1.3513	1.3529	1.3467	1.3516	89841.0
2017-08-30	BR	Futures	0.23626	0.23626	0.23551	0.2357	594.0
2017-08-30	BZ	Futures	35.89	35.97	35.15	35.27	30873.0
2017-08-30	C	Futures	1529.0	1541.0	1491.0	1512.0	3214.0
2017-08-30	CB	Futures	317.484	317.484	317.484	317.484	4.0
2017-08-30	CC	Futures	1448.0	1455.0	1397.0	1429.0	27778.0
2017-08-30	CNH	Futures	6.8161	6.8231	6.8104	6.8231	33.0
2017-08-30	CSC	Futures	3.46	3.46	3.46	3.46	20.0
2017-08-30	CT	Futures	82.69	83.47	82.69	83.41	24.0
2017-08-30	DC	Futures	28.76	28.85	28.65	28.78	76.0
2017-08-30	DX	Futures	86.182	86.733	86.084	86.675	29839.0
2017-08-30	E1	Futures	1.28758	1.28906	1.27481	1.27641	36181.0
2017-08-30	E6	Futures	1.37276	1.37442	1.3625	1.3637	242905.0
2017-08-30	E7	Futures	1.3656	1.367	1.3553	1.3566	4300.0
2017-08-30	EBM	Futures	170.08	172.31	170.08	172.03	3285.0
2017-08-30	ED	Futures	95.5959	95.5983	95.591	95.5983	114833.0
2017-08-30	ER	Futures	98.337	98.342	98.337	98.342	13796.0
2017-08-30	EW	Futures	1812.8	1824.4	1807.2	1822.4	11254.0
2017-08-30	FBON	Futures	124.82	124.94	124.73	124.79	233.0
2017-08-30	FBTP	Futures	108.92	109.01	108.76	108.86	79544.0
2017-08-30	FBTS	Futures	103.045	103.064	103.018	103.036	38980.0
2017-08-30	FCE	Futures	4530.2	4540.5	4513.2	4523.0	57872.0
2017-08-30	FDAX	Futures	12645.5	12674.4	12618.1	12641.8	82295.0
2017-08-30	FDXM	Futures	12567.7	12597.0	12540.4	12564.0	25071.0
2017-08-30	FESX	Futures	2784.3	2789.2	2771.2	2778.5	744437.0
2017-08-30	FGBL	Futures	150.13	150.17	149.82	150.02	676337.0
2017-08-30	FGBM	Futures	129.97	129.97	129.8	129.9	503494.0
2017-08-30	FGBS	Futures	112.457	112.472	112.437	112.462	353984.0
2017-08-30	FGBX	Futures	170.49	170.63	169.8	170.2	54750.0
2017-08-30	FMWO	Futures	6500.7	6515.0	6488.8	6498.3	690.0
2017-08-30	FOAT	Futures	136.75	136.78	136.51	136.67	132911.0
2017-08-30	FTDX	Futures	2249.6	2264.1	2244.6	2264.1	149.0
2017-08-30	FTI	Futures	474.5	476.67	473.2	474.87	23529.0
2017-08-30	FTUK	Futures	6360.6	6375.3	6346.3	6364.9	67231.0
2017-08-30	FVSA	Futures	516.41	517.99	503.82	511.69	14816.0
2017-08-30	FXXP	Futures	315.4	316.9	314.8	315.9	20768.0
2017-08-30	G	Futures	116.63	116.74	116.4	116.52	171865.0
2017-08-30	GF	Futures	313.359	315.552	310.29	315.168	2173.0
2017-08-30	GSCI	Futures	451.1	451.1	449.42	449.42	211.0
2017-08-30	HE	Futures	84.54	86.36	84.19	85.87	23728.0

> showing 50 of 110 rows — these rows as CSV

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