PREVIEW / futures_daily / 2019-06-27

all futures daily files

  file:    by_date/futures_daily/2019/2019-06-27.parquet
  size:    10 KB
  rows:    121

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-06-27	ES	Futures	3145.18	3167.84	3145.18	3162.72	1060248.0
2019-06-27	NQ	Futures	8797.27	8884.2	8796.98	8854.26	300152.0
2019-06-27	YM	Futures	27847.7	27998.9	27767.9	27874.0	172212.0
2019-06-27	CL	Futures	60.63	61.1	59.95	60.79	531405.0
2019-06-27	GC	Futures	1758.3	1761.5	1744.2	1757.4	336359.0
2019-06-27	ZN	Futures	127.035974	127.362585	126.787128	127.347032	1358937.0
2019-06-27	A6	Futures	0.72065	0.72281	0.72024	0.7223	70500.0
2019-06-27	AD	Futures	0.76932	0.77124	0.76846	0.77109	78382.0
2019-06-27	ALI	Futures	2223.27	2223.27	2223.27	2223.27	0.0
2019-06-27	B	Futures	48.99	49.59	48.75	49.37	290042.0
2019-06-27	B6	Futures	1.3001	1.3034	1.2968	1.2969	65982.0
2019-06-27	BR	Futures	0.20539	0.20755	0.20531	0.20711	32.0
2019-06-27	BTC	Futures	17848.6	18996.5	14796.8	15531.8	4871.0
2019-06-27	BZ	Futures	48.6	48.96	48.15	48.75	31039.0
2019-06-27	C	Futures	1740.0	1749.0	1718.0	1734.0	8057.0
2019-06-27	CB	Futures	289.411	289.411	287.194	288.04	21.0
2019-06-27	CC	Futures	1644.0	1665.0	1612.0	1634.0	19560.0
2019-06-27	CNH	Futures	6.8882	6.892	6.8772	6.8776	492.0
2019-06-27	CSC	Futures	3.077	3.097	3.073	3.09	44.0
2019-06-27	CT	Futures	65.91	65.91	64.94	65.17	39.0
2019-06-27	DC	Futures	25.99	26.02	25.82	25.99	114.0
2019-06-27	DX	Futures	92.146	92.353	92.112	92.181	10589.0
2019-06-27	E1	Futures	1.19473	1.1967	1.19009	1.19658	26516.0
2019-06-27	E6	Futures	1.24834	1.24927	1.24556	1.24829	140478.0
2019-06-27	E7	Futures	1.2419	1.2427	1.2392	1.2418	6897.0
2019-06-27	EBM	Futures	212.17	212.75	209.0	209.87	16787.0
2019-06-27	ED	Futures	95.4207	95.4353	95.3915	95.4304	265074.0
2019-06-27	ER	Futures	98.499	98.509	98.494	98.504	57381.0
2019-06-27	EW	Futures	1998.4	2025.3	1998.4	2024.2	13064.0
2019-06-27	FBON	Futures	142.79	142.79	142.28	142.67	640.0
2019-06-27	FBTP	Futures	120.15	120.27	119.84	120.15	101129.0
2019-06-27	FBTS	Futures	106.727	106.814	106.689	106.794	50839.0
2019-06-27	FCE	Futures	5032.6	5035.8	4989.2	5015.3	56754.0
2019-06-27	FDAX	Futures	12881.2	12971.7	12837.0	12912.8	97057.0
2019-06-27	FDIV	Futures	147.16	147.16	146.37	146.74	30.0
2019-06-27	FDXM	Futures	12721.5	12813.0	12679.9	12753.7	35791.0
2019-06-27	FESX	Futures	2994.2	3006.4	2980.2	2997.7	720566.0
2019-06-27	FEU3	Futures	99.134	99.134	99.129	99.129	1.0
2019-06-27	FGBL	Futures	163.89	164.28	163.47	164.14	703607.0
2019-06-27	FGBM	Futures	134.26	134.41	134.15	134.37	392508.0
2019-06-27	FGBS	Futures	113.056	113.076	113.031	113.071	286162.0
2019-06-27	FGBX	Futures	208.85	209.71	207.12	209.28	50254.0
2019-06-27	FMWO	Futures	7308.3	7314.1	7273.7	7287.5	2080.0
2019-06-27	FOAT	Futures	150.91	151.32	150.6	151.22	122170.0
2019-06-27	FTDX	Futures	2787.6	2798.5	2787.6	2793.0	49.0
2019-06-27	FTI	Futures	525.87	526.48	520.97	524.01	19230.0
2019-06-27	FTUK	Futures	6778.8	6811.1	6749.7	6776.5	75298.0
2019-06-27	FVSA	Futures	204.2	208.35	200.74	202.81	18078.0
2019-06-27	FXXP	Futures	342.0	342.1	339.5	340.9	51702.0
2019-06-27	G	Futures	119.76	120.03	119.58	119.97	179611.0

> showing 50 of 121 rows — these rows as CSV

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