PREVIEW / futures_daily / 2019-09-17

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-17.parquet
  size:    10 KB
  rows:    119

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
2019-09-17	ES	Futures	3252.3	3257.45	3240.94	3256.36	1699010.0
2019-09-17	NQ	Futures	9089.14	9128.9	9047.37	9120.83	331358.0
2019-09-17	YM	Futures	28461.9	28486.1	28325.5	28459.8	129300.0
2019-09-17	CL	Futures	63.37	64.05	59.82	60.68	722004.0
2019-09-17	GC	Futures	1858.3	1868.8	1851.4	1866.9	336627.0
2019-09-17	ZN	Futures	127.870275	128.2419	127.808337	128.118025	1701453.0
2019-09-17	A6	Futures	0.70635	0.70666	0.70266	0.70584	75750.0
2019-09-17	AD	Futures	0.76212	0.76217	0.75844	0.76116	80972.0
2019-09-17	ALI	Futures	2155.91	2167.98	2149.57	2165.57	186.0
2019-09-17	B	Futures	52.64	53.49	49.08	49.86	620494.0
2019-09-17	B6	Futures	1.2676	1.2781	1.2646	1.2756	97676.0
2019-09-17	BR	Futures	0.19655	0.19732	0.19542	0.19703	38.0
2019-09-17	BTC	Futures	14723.1	14866.0	14551.6	14723.1	1583.0
2019-09-17	BZ	Futures	51.87	52.69	48.36	49.12	87185.0
2019-09-17	C	Futures	1598.0	1610.0	1583.0	1606.0	10871.0
2019-09-17	CB	Futures	261.268	261.268	258.139	258.139	28.0
2019-09-17	CC	Futures	1561.0	1578.0	1554.0	1571.0	30998.0
2019-09-17	CNH	Futures	7.0651	7.1005	7.0651	7.0883	722.0
2019-09-17	CSC	Futures	3.171	3.171	3.074	3.09	79.0
2019-09-17	CT	Futures	60.82	60.82	59.22	59.37	35.0
2019-09-17	DC	Futures	26.66	26.73	25.97	26.03	281.0
2019-09-17	DX	Futures	94.932	95.0	94.463	94.545	12692.0
2019-09-17	E1	Futures	1.16703	1.16922	1.16278	1.16657	31364.0
2019-09-17	E6	Futures	1.20071	1.20824	1.19935	1.20743	173206.0
2019-09-17	E7	Futures	1.1945	1.202	1.1931	1.2012	3597.0
2019-09-17	EBM	Futures	187.7	187.7	186.61	187.16	15701.0
2019-09-17	ED	Futures	95.182	95.2208	95.1625	95.2063	603609.0
2019-09-17	ER	Futures	98.431	98.445	98.426	98.431	106734.0
2019-09-17	EW	Futures	2071.7	2072.9	2052.7	2060.4	26352.0
2019-09-17	FBON	Futures	144.92	144.98	144.51	144.51	114.0
2019-09-17	FBTP	Futures	132.08	132.28	131.39	131.55	85489.0
2019-09-17	FBTS	Futures	108.471	108.548	108.356	108.394	49544.0
2019-09-17	FCE	Futures	5061.3	5080.7	5049.5	5075.8	146466.0
2019-09-17	FDAX	Futures	13057.6	13077.1	12964.2	13043.8	51835.0
2019-09-17	FDXM	Futures	12886.0	12891.2	12795.4	12873.5	1866.0
2019-09-17	FESX	Futures	3074.6	3079.0	3060.6	3074.6	1871754.0
2019-09-17	FGBL	Futures	167.11	167.27	166.8	166.99	591226.0
2019-09-17	FGBM	Futures	134.84	134.89	134.7	134.75	367454.0
2019-09-17	FGBS	Futures	112.946	112.946	112.885	112.9	339808.0
2019-09-17	FGBX	Futures	218.97	219.68	218.37	219.06	47606.0
2019-09-17	FMWO	Futures	7390.2	7417.9	7376.4	7401.8	21227.0
2019-09-17	FOAT	Futures	154.05	154.23	153.69	153.87	116338.0
2019-09-17	FTDX	Futures	2832.0	2840.9	2813.3	2840.9	345.0
2019-09-17	FTI	Futures	543.67	545.66	542.67	545.1	33985.0
2019-09-17	FTUK	Futures	6759.2	6779.2	6724.5	6749.5	407006.0
2019-09-17	FVSA	Futures	183.57	186.94	182.45	185.25	34282.0
2019-09-17	FXXP	Futures	350.2	351.0	349.1	350.6	190927.0
2019-09-17	G	Futures	120.96	121.21	120.72	120.96	186898.0
2019-09-17	GF	Futures	280.702	289.964	280.388	287.4	8549.0
2019-09-17	GSCI	Futures	471.37	471.37	471.37	471.37	20.0

> showing 50 of 119 rows — these rows as CSV

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