PREVIEW / futures_daily / 2018-07-05

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-05.parquet
  size:    10 KB
  rows:    114

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
2018-07-05	ES	Futures	2946.58	2975.64	2944.14	2974.28	1165235.0
2018-07-05	NQ	Futures	8188.13	8310.55	8178.8	8307.93	378283.0
2018-07-05	YM	Futures	25457.2	25672.2	25408.7	25650.0	203143.0
2018-07-05	CL	Futures	75.19	75.87	73.47	73.88	841632.0
2018-07-05	GC	Futures	1600.3	1611.7	1598.7	1607.1	392947.0
2018-07-05	ZN	Futures	119.681004	119.758698	119.43238	119.58777	1166546.0
2018-07-05	A6	Futures	0.75966	0.76388	0.75719	0.75905	121724.0
2018-07-05	AD	Futures	0.77153	0.77341	0.77052	0.77143	73097.0
2018-07-05	B	Futures	57.64	57.9	57.02	57.09	254024.0
2018-07-05	B6	Futures	1.3654	1.3737	1.3633	1.3672	166017.0
2018-07-05	BR	Futures	0.19378	0.19496	0.1923	0.1923	88.0
2018-07-05	BTC	Futures	9395.2	9680.2	9117.4	9267.0	6739.0
2018-07-05	BZ	Futures	57.19	57.59	56.72	56.78	27678.0
2018-07-05	C	Futures	1685.0	1729.0	1678.0	1726.0	878.0
2018-07-05	CB	Futures	269.884	270.873	265.926	267.485	72.0
2018-07-05	CC	Futures	1748.0	1813.0	1736.0	1779.0	20485.0
2018-07-05	CNH	Futures	6.7459	6.7459	6.7031	6.7343	103.0
2018-07-05	CSC	Futures	3.278	3.278	3.228	3.24	85.0
2018-07-05	CT	Futures	94.4	94.4	92.8	92.8	19.0
2018-07-05	DC	Futures	25.81	25.88	25.5	25.63	176.0
2018-07-05	DX	Futures	89.283	89.354	88.947	89.239	13953.0
2018-07-05	E1	Futures	1.21185	1.21389	1.20851	1.20923	24545.0
2018-07-05	E6	Futures	1.31073	1.31766	1.30749	1.31308	294051.0
2018-07-05	E7	Futures	1.3044	1.3108	1.3009	1.3064	4907.0
2018-07-05	EBM	Futures	193.02	195.63	193.02	195.37	25464.0
2018-07-05	ED	Futures	94.9913	94.9961	94.9815	94.9815	107290.0
2018-07-05	ER	Futures	98.357	98.367	98.357	98.367	41301.0
2018-07-05	EW	Futures	2077.2	2094.9	2073.5	2094.1	12360.0
2018-07-05	FBON	Futures	129.25	129.25	128.83	129.05	966.0
2018-07-05	FBTP	Futures	107.94	108.23	107.36	107.74	64111.0
2018-07-05	FBTS	Futures	102.642	102.754	102.086	102.42	62713.0
2018-07-05	FCE	Futures	4776.4	4846.0	4775.0	4821.3	71987.0
2018-07-05	FDAX	Futures	12871.2	13071.9	12851.9	13020.2	101873.0
2018-07-05	FDXM	Futures	12704.7	12903.9	12688.2	12853.8	39181.0
2018-07-05	FESX	Futures	2839.7	2883.1	2838.9	2866.4	1042694.0
2018-07-05	FGBL	Futures	153.0	153.38	152.7	153.31	608974.0
2018-07-05	FGBM	Futures	131.05	131.21	130.94	131.19	358551.0
2018-07-05	FGBS	Futures	112.713	112.744	112.683	112.729	270935.0
2018-07-05	FGBX	Futures	178.06	179.08	177.32	178.96	47253.0
2018-07-05	FMWO	Futures	6968.1	6996.1	6955.3	6969.3	314.0
2018-07-05	FOAT	Futures	141.01	141.37	140.81	141.35	167677.0
2018-07-05	FTDX	Futures	2654.4	2685.2	2649.9	2683.8	189.0
2018-07-05	FTI	Futures	506.52	513.3	506.29	509.75	27888.0
2018-07-05	FTUK	Futures	6693.6	6739.5	6683.3	6718.1	73150.0
2018-07-05	FVSA	Futures	316.83	319.75	303.23	311.0	23094.0
2018-07-05	FXXP	Futures	327.5	330.4	326.9	328.8	69688.0
2018-07-05	G	Futures	115.35	115.75	115.21	115.72	178924.0
2018-07-05	GF	Futures	317.054	318.245	315.138	316.07	4856.0
2018-07-05	GSCI	Futures	539.94	540.55	535.0	536.35	562.0
2018-07-05	HE	Futures	84.688	85.635	83.964	84.744	18102.0

> showing 50 of 114 rows — these rows as CSV

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