PREVIEW / futures_daily / 2018-09-21

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-21.parquet
  size:    10 KB
  rows:    116

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-09-21	ES	Futures	3187.92	3196.05	3179.79	3181.69	1489417.0
2018-09-21	NQ	Futures	8838.05	8871.15	8766.62	8770.1	371830.0
2018-09-21	YM	Futures	28131.0	28242.6	28128.9	28173.1	145752.0
2018-09-21	CL	Futures	73.49	75.16	73.26	74.09	855943.0
2018-09-21	GC	Futures	1536.2	1540.9	1515.8	1522.5	344754.0
2018-09-21	ZN	Futures	118.187778	118.265595	118.063272	118.203342	1123897.0
2018-09-21	A6	Futures	0.75052	0.75185	0.74764	0.74969	83158.0
2018-09-21	AD	Futures	0.78498	0.78604	0.7825	0.78376	72613.0
2018-09-21	B	Futures	57.34	58.4	57.02	57.43	297574.0
2018-09-21	B6	Futures	1.3702	1.3706	1.3476	1.3501	175149.0
2018-09-21	BR	Futures	0.18651	0.18788	0.18574	0.18742	167.0
2018-09-21	BTC	Futures	9253.3	9689.5	9231.8	9639.4	3627.0
2018-09-21	BZ	Futures	57.12	58.15	56.78	57.19	36594.0
2018-09-21	C	Futures	1452.0	1465.0	1440.0	1449.0	6061.0
2018-09-21	CB	Futures	268.864	270.396	268.864	270.155	13.0
2018-09-21	CC	Futures	1538.0	1547.0	1505.0	1513.0	18646.0
2018-09-21	CNH	Futures	6.902	6.9134	6.8921	6.9118	672.0
2018-09-21	CSC	Futures	3.248	3.272	3.248	3.272	26.0
2018-09-21	CT	Futures	88.84	89.14	88.75	88.96	5.0
2018-09-21	DC	Futures	26.88	27.09	26.86	27.09	95.0
2018-09-21	DX	Futures	88.814	89.232	88.724	89.106	23206.0
2018-09-21	E1	Futures	1.24558	1.25151	1.24428	1.24582	31749.0
2018-09-21	E6	Futures	1.3183	1.32103	1.31319	1.3148	237666.0
2018-09-21	E7	Futures	1.3116	1.3145	1.3067	1.3084	5463.0
2018-09-21	EBM	Futures	210.27	211.31	209.24	209.76	12244.0
2018-09-21	ED	Futures	95.0525	95.0671	95.0427	95.0622	349757.0
2018-09-21	ER	Futures	98.377	98.377	98.372	98.377	28449.0
2018-09-21	EW	Futures	2160.2	2165.9	2149.8	2151.4	15157.0
2018-09-21	FBON	Futures	127.85	128.2	127.85	128.13	144.0
2018-09-21	FBTP	Futures	108.93	109.57	108.67	109.45	51001.0
2018-09-21	FBTS	Futures	103.164	103.323	103.042	103.286	40559.0
2018-09-21	FCE	Futures	4918.0	4946.9	4912.6	4942.4	86312.0
2018-09-21	FDAX	Futures	13018.0	13086.3	12990.6	13036.4	91267.0
2018-09-21	FDIV	Futures	148.91	148.95	148.82	148.82	11.0
2018-09-21	FDXM	Futures	12791.5	12859.7	12766.7	12810.6	37810.0
2018-09-21	FESX	Futures	2855.3	2872.1	2851.1	2867.1	1267191.0
2018-09-21	FGBL	Futures	151.93	152.26	151.86	152.17	530180.0
2018-09-21	FGBM	Futures	130.47	130.63	130.45	130.58	315633.0
2018-09-21	FGBS	Futures	112.527	112.552	112.522	112.542	228211.0
2018-09-21	FGBX	Futures	174.46	175.17	174.18	174.93	26016.0
2018-09-21	FMWO	Futures	7343.6	7352.9	7328.6	7336.7	1590.0
2018-09-21	FOAT	Futures	139.86	140.1	139.8	140.05	90955.0
2018-09-21	FTDX	Futures	2782.2	2794.5	2768.0	2772.9	1756.0
2018-09-21	FTI	Futures	509.35	511.2	508.88	509.95	25144.0
2018-09-21	FTUK	Futures	6570.9	6671.9	6563.3	6647.7	141510.0
2018-09-21	FVSA	Futures	251.9	253.62	248.45	251.9	22755.0
2018-09-21	FXXP	Futures	331.1	332.3	330.8	331.2	62547.0
2018-09-21	G	Futures	113.61	114.11	113.57	113.97	249401.0
2018-09-21	GF	Futures	328.268	329.412	327.175	328.84	5244.0
2018-09-21	GSCI	Futures	532.64	534.77	530.0	530.56	24.0

> showing 50 of 116 rows — these rows as CSV

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