PREVIEW / futures_daily / 2017-10-16

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-16.parquet
  size:    9 KB
  rows:    108

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-10-16	ES	Futures	2776.07	2782.05	2774.44	2780.42	795923.0
2017-10-16	NQ	Futures	7166.89	7190.38	7162.78	7188.92	167591.0
2017-10-16	YM	Futures	24103.1	24188.6	24098.9	24180.2	75403.0
2017-10-16	CL	Futures	52.13	53.09	52.06	52.58	331180.0
2017-10-16	GC	Futures	1661.8	1664.8	1644.6	1658.0	271283.0
2017-10-16	ZN	Futures	123.948107	123.963512	123.593793	123.655413	1140752.0
2017-10-16	A6	Futures	0.81047	0.8112	0.80636	0.80687	83895.0
2017-10-16	AD	Futures	0.81569	0.81625	0.81045	0.81284	67351.0
2017-10-16	ALI	Futures	2731.63	2731.63	2731.63	2731.63	0.0
2017-10-16	B	Futures	40.45	41.29	40.34	40.83	341777.0
2017-10-16	B6	Futures	1.389	1.3904	1.3814	1.3836	106114.0
2017-10-16	BR	Futures	0.23694	0.23694	0.23694	0.23694	100.0
2017-10-16	BZ	Futures	40.01	40.95	40.01	40.5	22799.0
2017-10-16	C	Futures	1530.0	1535.0	1501.0	1504.0	9225.0
2017-10-16	CB	Futures	306.304	308.319	306.304	307.375	5.0
2017-10-16	CC	Futures	1550.0	1553.0	1512.0	1518.0	24834.0
2017-10-16	CNH	Futures	6.7665	6.7847	6.7665	6.7847	13.0
2017-10-16	CSC	Futures	3.443	3.443	3.42	3.42	20.0
2017-10-16	CT	Futures	80.5	80.9	79.32	79.32	15596.0
2017-10-16	DC	Futures	27.86	28.03	27.78	27.82	80.0
2017-10-16	DX	Futures	86.937	87.166	86.904	87.12	15648.0
2017-10-16	E1	Futures	1.25964	1.26159	1.25658	1.2578	18870.0
2017-10-16	E6	Futures	1.35218	1.35315	1.34859	1.34996	153482.0
2017-10-16	E7	Futures	1.3454	1.3461	1.3415	1.3429	2351.0
2017-10-16	EBM	Futures	175.59	176.4	174.78	175.05	13397.0
2017-10-16	ED	Futures	95.5085	95.5085	95.4988	95.4988	333597.0
2017-10-16	ER	Futures	98.342	98.342	98.337	98.342	35128.0
2017-10-16	EW	Futures	1934.8	1941.1	1931.9	1933.8	7996.0
2017-10-16	FBON	Futures	124.93	125.28	124.82	125.2	323.0
2017-10-16	FBTP	Futures	109.77	110.35	109.69	110.21	73866.0
2017-10-16	FBTS	Futures	103.31	103.42	103.301	103.393	44790.0
2017-10-16	FCE	Futures	4804.6	4810.5	4789.0	4802.9	57672.0
2017-10-16	FDAX	Futures	13681.7	13684.3	13632.3	13661.2	42560.0
2017-10-16	FDXM	Futures	13561.6	13567.8	13516.7	13545.9	12827.0
2017-10-16	FESX	Futures	2940.9	2941.7	2929.5	2935.2	458557.0
2017-10-16	FGBL	Futures	149.83	150.3	149.7	150.22	604017.0
2017-10-16	FGBM	Futures	129.84	130.04	129.82	130.01	419747.0
2017-10-16	FGBS	Futures	112.482	112.527	112.467	112.517	216946.0
2017-10-16	FGBX	Futures	167.97	169.24	167.81	169.05	37750.0
2017-10-16	FMWO	Futures	6751.0	6758.1	6749.8	6754.5	1883.0
2017-10-16	FOAT	Futures	137.25	137.65	137.04	137.56	79699.0
2017-10-16	FTDX	Futures	2535.4	2535.4	2524.9	2534.4	72.0
2017-10-16	FTI	Futures	505.24	505.75	504.13	504.83	6412.0
2017-10-16	FTUK	Futures	6529.3	6530.6	6495.5	6511.1	69198.0
2017-10-16	FVSA	Futures	361.95	369.62	356.83	358.11	30162.0
2017-10-16	FXXP	Futures	332.5	332.7	331.2	331.9	16052.0
2017-10-16	G	Futures	113.22	113.77	113.03	113.68	183910.0
2017-10-16	GF	Futures	334.538	335.562	332.706	333.083	3818.0
2017-10-16	GSCI	Futures	479.28	479.28	476.57	476.57	125.0
2017-10-16	HE	Futures	92.285	94.315	91.99	94.057	19496.0

> showing 50 of 108 rows — these rows as CSV

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