PREVIEW / futures_daily / 2018-09-27

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-27.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-27	ES	Futures	3157.55	3179.79	3153.22	3166.77	1210835.0
2018-09-27	NQ	Futures	8816.27	8927.78	8811.33	8894.09	377694.0
2018-09-27	YM	Futures	27818.2	27985.7	27755.1	27877.2	163378.0
2018-09-27	CL	Futures	75.38	76.0	75.07	75.5	454549.0
2018-09-27	GC	Futures	1519.5	1524.2	1502.7	1504.9	351051.0
2018-09-27	ZN	Futures	118.358975	118.514608	118.172215	118.281158	1513415.0
2018-09-27	A6	Futures	0.74722	0.74825	0.74177	0.74239	83866.0
2018-09-27	AD	Futures	0.77694	0.77805	0.77416	0.77663	77739.0
2018-09-27	B	Futures	59.7	60.18	59.4	59.79	339933.0
2018-09-27	B6	Futures	1.359	1.3601	1.3494	1.3508	93302.0
2018-09-27	BFX	Futures	4328.6	4344.4	4328.6	4344.4	5.0
2018-09-27	BR	Futures	0.18742	0.18997	0.18742	0.18997	1185.0
2018-09-27	BTC	Futures	9285.9	9718.8	9264.2	9588.9	648.0
2018-09-27	BZ	Futures	59.2	59.72	58.96	59.35	32041.0
2018-09-27	C	Futures	1433.0	1445.0	1413.0	1416.0	9175.0
2018-09-27	CB	Futures	276.975	277.786	275.172	275.172	34.0
2018-09-27	CC	Futures	1509.0	1520.0	1474.0	1476.0	19639.0
2018-09-27	CNH	Futures	6.9338	6.9442	6.9214	6.9385	185.0
2018-09-27	CSC	Futures	3.238	3.248	3.238	3.244	16.0
2018-09-27	CT	Futures	88.23	88.33	86.78	87.24	16971.0
2018-09-27	DC	Futures	26.99	27.06	26.89	27.04	97.0
2018-09-27	DX	Futures	89.194	89.887	89.118	89.796	27052.0
2018-09-27	E1	Futures	1.23705	1.23716	1.2201	1.22093	37368.0
2018-09-27	E6	Futures	1.31397	1.31536	1.30207	1.30424	309543.0
2018-09-27	E7	Futures	1.3074	1.3088	1.2958	1.2979	6040.0
2018-09-27	EBM	Futures	208.46	210.53	207.94	208.72	24855.0
2018-09-27	ED	Futures	95.0525	95.0573	95.0427	95.0525	259139.0
2018-09-27	ER	Futures	98.377	98.377	98.372	98.377	47939.0
2018-09-27	EW	Futures	2120.9	2132.4	2117.8	2122.7	12960.0
2018-09-27	FBON	Futures	127.97	128.04	127.74	127.97	518.0
2018-09-27	FBTP	Futures	108.54	108.94	107.81	108.89	144729.0
2018-09-27	FBTS	Futures	103.014	103.305	102.686	103.192	94166.0
2018-09-27	FCE	Futures	4954.5	4997.4	4941.5	4991.5	58321.0
2018-09-27	FDAX	Futures	12947.0	13088.4	12889.1	13067.9	90037.0
2018-09-27	FDIV	Futures	147.83	147.83	147.6	147.6	8.0
2018-09-27	FDXM	Futures	12725.3	12861.7	12666.4	12841.6	38916.0
2018-09-27	FESX	Futures	2858.7	2891.5	2851.1	2886.4	804640.0
2018-09-27	FGBL	Futures	151.75	151.97	151.23	151.27	861580.0
2018-09-27	FGBM	Futures	130.3	130.35	130.04	130.06	627933.0
2018-09-27	FGBS	Futures	112.492	112.502	112.442	112.447	472319.0
2018-09-27	FGBX	Futures	174.87	175.51	174.36	174.42	62979.0
2018-09-27	FMWO	Futures	7281.1	7323.9	7275.3	7317.0	3976.0
2018-09-27	FOAT	Futures	139.62	139.75	139.25	139.27	147818.0
2018-09-27	FTDX	Futures	2784.6	2784.6	2760.6	2779.7	102.0
2018-09-27	FTI	Futures	510.74	514.78	509.76	513.71	19632.0
2018-09-27	FTUK	Futures	6663.4	6723.3	6656.7	6715.2	87159.0
2018-09-27	FVSA	Futures	253.62	254.49	245.86	247.59	16433.0
2018-09-27	FXXP	Futures	331.6	333.7	330.1	333.4	35387.0
2018-09-27	G	Futures	113.88	114.07	113.55	113.58	241839.0
2018-09-27	GF	Futures	329.516	329.516	326.031	328.372	2082.0

> showing 50 of 116 rows — these rows as CSV

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