PREVIEW / futures_daily / 2020-07-27

all futures daily files

  file:    by_date/futures_daily/2020/2020-07-27.parquet
  size:    10 KB
  rows:    120

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
2020-07-27	ES	Futures	3613.98	3641.27	3592.87	3638.18	1299512.0
2020-07-27	NQ	Futures	12175.11	12400.27	12071.81	12390.12	444802.0
2020-07-27	YM	Futures	28158.7	28424.5	28112.6	28382.7	141718.0
2020-07-27	CL	Futures	30.11	30.52	29.54	30.35	377714.0
2020-07-27	GC	Futures	2278.2	2328.1	2275.6	2309.3	137849.0
2020-07-27	ZN	Futures	138.310917	138.496736	138.156069	138.218008	748061.0
2020-07-27	A6	Futures	0.73016	0.73561	0.72923	0.73479	67471.0
2020-07-27	AD	Futures	0.75682	0.76022	0.75591	0.75982	55364.0
2020-07-27	ALI	Futures	2079.19	2086.78	2076.16	2083.14	354.0
2020-07-27	B	Futures	28.24	28.49	27.68	28.3	231227.0
2020-07-27	B6	Futures	1.2999	1.3105	1.2985	1.3074	95166.0
2020-07-27	BR	Futures	0.15225	0.1538	0.15162	0.15324	4716.0
2020-07-27	BTC	Futures	13646.5	15342.9	13646.5	15137.7	7719.0
2020-07-27	BZ	Futures	27.61	27.81	27.03	27.64	18533.0
2020-07-27	C	Futures	1405.0	1436.0	1400.0	1415.0	4593.0
2020-07-27	CB	Futures	190.44	190.44	188.3	188.888	64.0
2020-07-27	CC	Futures	1462.0	1509.0	1461.0	1499.0	18753.0
2020-07-27	CNH	Futures	6.9292	6.9292	6.9122	6.9139	237.0
2020-07-27	CSC	Futures	4.269	4.269	4.178	4.254	117.0
2020-07-27	CT	Futures	60.19	62.16	59.72	61.38	148.0
2020-07-27	DC	Futures	34.44	35.46	34.01	34.95	576.0
2020-07-27	DX	Futures	91.131	91.16	90.237	90.426	23555.0
2020-07-27	E1	Futures	1.23466	1.24068	1.23228	1.2358	28624.0
2020-07-27	E6	Futures	1.25103	1.26552	1.2506	1.26224	266042.0
2020-07-27	E7	Futures	1.2448	1.2592	1.2444	1.256	9945.0
2020-07-27	EBM	Futures	221.25	221.25	218.56	218.85	10553.0
2020-07-27	ED	Futures	96.4378	96.4427	96.433	96.433	115896.0
2020-07-27	ER	Futures	98.367	98.372	98.362	98.372	35651.0
2020-07-27	ESG	Futures	291.11	293.11	291.11	293.11	36.0
2020-07-27	EW	Futures	1967.7	1984.0	1954.7	1981.9	9627.0
2020-07-27	FBON	Futures	146.27	146.85	146.06	146.36	73.0
2020-07-27	FBTP	Futures	133.12	133.32	132.65	133.13	65406.0
2020-07-27	FBTS	Futures	108.948	108.948	108.803	108.88	42891.0
2020-07-27	FCE	Futures	4792.9	4798.2	4752.8	4770.6	47182.0
2020-07-27	FDAX	Futures	13624.0	13708.0	13596.9	13647.9	68401.0
2020-07-27	FDIV	Futures	147.25	147.3	147.01	147.3	150.0
2020-07-27	FDXM	Futures	13575.9	13657.4	13548.4	13598.7	39660.0
2020-07-27	FESX	Futures	3048.1	3063.8	3032.4	3046.3	626497.0
2020-07-27	FGBL	Futures	168.22	168.99	168.12	168.92	481823.0
2020-07-27	FGBM	Futures	134.61	134.88	134.56	134.86	373391.0
2020-07-27	FGBS	Futures	112.694	112.739	112.684	112.734	285439.0
2020-07-27	FGBX	Futures	227.22	230.07	226.85	229.8	40810.0
2020-07-27	FMWO	Futures	8069.3	8110.8	8051.5	8074.0	814.0
2020-07-27	FOAT	Futures	155.83	156.44	155.73	156.41	137413.0
2020-07-27	FTDX	Futures	3107.8	3135.9	3107.8	3131.3	14.0
2020-07-27	FTI	Futures	524.27	527.78	521.19	525.25	18162.0
2020-07-27	FTUK	Futures	5737.0	5775.3	5718.5	5743.1	66263.0
2020-07-27	FVSA	Futures	242.52	243.87	231.2	238.44	11985.0
2020-07-27	FXXP	Futures	337.6	338.4	335.9	337.3	36846.0
2020-07-27	G	Futures	127.62	127.93	127.53	127.89	136787.0

> showing 50 of 120 rows — these rows as CSV

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