PREVIEW / futures_daily / 2018-02-20

all futures daily files

  file:    by_date/futures_daily/2018/2018-02-20.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
2018-02-20	ES	Futures	2972.07	2986.47	2940.82	2949.79	1447502.0
2018-02-20	NQ	Futures	7944.4	8015.26	7874.13	7952.89	461892.0
2018-02-20	YM	Futures	26605.6	26724.8	26223.9	26310.3	286769.0
2018-02-20	CL	Futures	61.95	63.09	61.86	62.23	794481.0
2018-02-20	GC	Futures	1724.7	1729.5	1699.6	1700.4	374047.0
2018-02-20	ZN	Futures	119.028779	119.121337	118.627698	118.951648	1618062.0
2018-02-20	A6	Futures	0.81355	0.81612	0.80985	0.81036	129075.0
2018-02-20	AD	Futures	0.80889	0.81067	0.80295	0.80341	80200.0
2018-02-20	B	Futures	47.1	47.22	46.49	46.82	289165.0
2018-02-20	B6	Futures	1.4608	1.4626	1.4504	1.4561	143625.0
2018-02-20	BR	Futures	0.23476	0.23484	0.2323	0.23328	4916.0
2018-02-20	BTC	Futures	13467.8	15302.5	13422.2	15270.0	2080.0
2018-02-20	BZ	Futures	45.93	46.62	45.87	46.21	34029.0
2018-02-20	C	Futures	1356.0	1370.0	1354.0	1369.0	6328.0
2018-02-20	CC	Futures	1558.0	1578.0	1553.0	1576.0	19260.0
2018-02-20	CNH	Futures	6.4342	6.4763	6.4342	6.4735	12.0
2018-02-20	CSC	Futures	3.302	3.321	3.302	3.302	69.0
2018-02-20	CT	Futures	88.41	91.46	88.3	90.53	8757.0
2018-02-20	DC	Futures	26.16	26.37	26.11	26.29	451.0
2018-02-20	DX	Futures	83.735	84.256	83.726	84.177	17881.0
2018-02-20	E1	Futures	1.31164	1.31334	1.29829	1.29974	30412.0
2018-02-20	E6	Futures	1.40955	1.41227	1.399	1.40082	325966.0
2018-02-20	E7	Futures	1.4027	1.405	1.392	1.3938	5626.0
2018-02-20	EBM	Futures	173.43	174.51	172.89	173.16	20824.0
2018-02-20	ED	Futures	95.1319	95.1441	95.1149	95.1222	437640.0
2018-02-20	ER	Futures	98.332	98.337	98.332	98.332	17415.0
2018-02-20	EW	Futures	2018.4	2026.2	1995.3	2001.9	15503.0
2018-02-20	FBON	Futures	126.06	126.11	125.8	125.83	269.0
2018-02-20	FBTP	Futures	110.96	111.25	110.81	110.92	102509.0
2018-02-20	FBTS	Futures	103.631	103.64	103.595	103.613	34584.0
2018-02-20	FCE	Futures	4643.0	4673.9	4634.2	4670.8	57413.0
2018-02-20	FDAX	Futures	12863.6	12968.4	12786.9	12957.5	83337.0
2018-02-20	FDXM	Futures	12876.1	12989.4	12808.6	12979.5	27026.0
2018-02-20	FESX	Futures	2783.3	2807.8	2774.3	2806.1	887730.0
2018-02-20	FGBL	Futures	146.59	146.94	146.34	146.79	614787.0
2018-02-20	FGBM	Futures	128.35	128.54	128.26	128.48	431895.0
2018-02-20	FGBS	Futures	112.291	112.331	112.276	112.311	353632.0
2018-02-20	FGBX	Futures	163.17	164.07	162.45	163.64	64828.0
2018-02-20	FMWO	Futures	7020.4	7048.4	6990.0	7040.2	637.0
2018-02-20	FOAT	Futures	135.66	136.0	135.48	135.79	82841.0
2018-02-20	FTDX	Futures	2564.3	2585.2	2558.3	2585.2	393.0
2018-02-20	FTI	Futures	485.6	490.15	484.69	489.23	18274.0
2018-02-20	FTUK	Futures	6316.0	6318.6	6260.1	6299.0	89798.0
2018-02-20	FVSA	Futures	439.51	461.67	437.05	444.43	16494.0
2018-02-20	FXXP	Futures	321.9	324.0	321.1	323.7	23288.0
2018-02-20	G	Futures	111.46	112.01	111.41	111.97	198599.0
2018-02-20	GF	Futures	329.889	331.371	327.309	328.956	5088.0
2018-02-20	GSCI	Futures	505.58	508.2	505.07	505.19	42.0
2018-02-20	HE	Futures	87.927	89.917	87.702	88.858	24558.0
2018-02-20	HG	Futures	3.8785	3.8856	3.8083	3.8232	43336.0

> showing 50 of 110 rows — these rows as CSV

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