PREVIEW / futures_daily / 2019-11-05

all futures daily files

  file:    by_date/futures_daily/2019/2019-11-05.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
2019-11-05	ES	Futures	3330.79	3340.53	3323.21	3325.65	1124217.0
2019-11-05	NQ	Futures	9474.63	9505.17	9442.07	9462.24	305795.0
2019-11-05	YM	Futures	28766.4	28861.9	28728.6	28786.3	126855.0
2019-11-05	CL	Futures	57.78	58.74	57.52	58.47	435319.0
2019-11-05	GC	Futures	1864.6	1865.0	1826.5	1830.2	593619.0
2019-11-05	ZN	Futures	128.458682	128.489651	127.699946	127.761884	1794964.0
2019-11-05	A6	Futures	0.70656	0.71169	0.70645	0.70789	109530.0
2019-11-05	AD	Futures	0.76574	0.76806	0.76443	0.76564	62178.0
2019-11-05	ALI	Futures	2209.77	2214.93	2209.77	2212.2	39.0
2019-11-05	B	Futures	49.48	50.4	49.33	50.22	231665.0
2019-11-05	B6	Futures	1.3115	1.315	1.3091	1.3115	74461.0
2019-11-05	BR	Futures	0.20152	0.20281	0.20063	0.20237	5160.0
2019-11-05	BTC	Futures	13689.7	13834.1	12072.4	13603.1	2875.0
2019-11-05	BZ	Futures	48.82	49.7	48.7	49.53	27103.0
2019-11-05	C	Futures	1681.0	1682.0	1659.0	1666.0	10489.0
2019-11-05	CB	Futures	246.803	247.865	246.803	247.393	14.0
2019-11-05	CC	Futures	1637.0	1644.0	1628.0	1635.0	29782.0
2019-11-05	CNH	Futures	7.0271	7.0271	6.978	6.9918	971.0
2019-11-05	CSC	Futures	3.524	3.558	3.524	3.556	62.0
2019-11-05	CT	Futures	61.98	62.5	61.86	62.11	24082.0
2019-11-05	DC	Futures	29.46	29.73	29.36	29.66	687.0
2019-11-05	DX	Futures	94.096	94.55	94.019	94.531	20723.0
2019-11-05	E1	Futures	1.16772	1.16795	1.16105	1.16128	36337.0
2019-11-05	E6	Futures	1.20867	1.21057	1.20223	1.20239	190829.0
2019-11-05	E7	Futures	1.2025	1.2043	1.196	1.1962	3707.0
2019-11-05	EBM	Futures	193.72	195.36	193.45	194.54	28868.0
2019-11-05	ED	Futures	95.3229	95.3229	95.3083	95.318	216605.0
2019-11-05	ER	Futures	98.401	98.406	98.391	98.401	55428.0
2019-11-05	EW	Futures	2093.0	2111.7	2092.2	2100.1	8902.0
2019-11-05	FBON	Futures	144.4	144.48	144.17	144.3	336.0
2019-11-05	FBTP	Futures	130.72	130.88	130.34	130.61	83848.0
2019-11-05	FBTS	Futures	108.375	108.385	108.327	108.385	33793.0
2019-11-05	FCE	Futures	5301.2	5310.3	5281.7	5307.1	61753.0
2019-11-05	FDAX	Futures	13863.7	13894.3	13829.9	13864.2	79248.0
2019-11-05	FDIV	Futures	160.89	161.31	160.84	161.17	21.0
2019-11-05	FDXM	Futures	13688.9	13708.7	13649.4	13683.2	30469.0
2019-11-05	FESX	Futures	3212.3	3222.0	3205.3	3217.6	717488.0
2019-11-05	FEU3	Futures	99.09	99.1	99.09	99.1	297.0
2019-11-05	FGBL	Futures	165.09	165.14	164.51	164.73	737013.0
2019-11-05	FGBM	Futures	134.03	134.04	133.85	133.92	409307.0
2019-11-05	FGBS	Futures	112.739	112.744	112.704	112.719	207584.0
2019-11-05	FGBX	Futures	214.01	214.2	212.14	212.97	54114.0
2019-11-05	FMWO	Futures	7547.3	7556.4	7520.0	7530.3	2515.0
2019-11-05	FOAT	Futures	152.46	152.61	152.14	152.37	131070.0
2019-11-05	FTDX	Futures	2837.9	2858.2	2837.4	2858.2	51.0
2019-11-05	FTI	Futures	558.71	563.53	557.66	562.49	24074.0
2019-11-05	FTUK	Futures	6814.8	6844.5	6805.6	6826.9	73023.0
2019-11-05	FVSA	Futures	143.88	148.13	143.88	146.54	19163.0
2019-11-05	FXXP	Futures	365.1	365.5	363.7	365.1	58741.0
2019-11-05	G	Futures	120.51	120.77	120.11	120.34	221521.0

> showing 50 of 120 rows — these rows as CSV

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