PREVIEW / futures_daily / 2018-05-09

all futures daily files

  file:    by_date/futures_daily/2018/2018-05-09.parquet
  size:    10 KB
  rows:    112

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-05-09	ES	Futures	2903.27	2936.16	2899.73	2931.81	1251722.0
2018-05-09	NQ	Futures	7984.7	8077.45	7968.6	8071.31	316609.0
2018-05-09	YM	Futures	25590.3	25852.6	25562.9	25810.4	191821.0
2018-05-09	CL	Futures	70.31	71.62	70.11	71.4	863386.0
2018-05-09	GC	Futures	1679.2	1682.4	1665.0	1676.3	384042.0
2018-05-09	ZN	Futures	118.56311	118.578619	118.299464	118.377007	1146875.0
2018-05-09	A6	Futures	0.76615	0.76831	0.76224	0.76759	114067.0
2018-05-09	AD	Futures	0.78151	0.7894	0.78024	0.78839	93828.0
2018-05-09	B	Futures	55.83	56.74	55.75	56.58	364746.0
2018-05-09	B6	Futures	1.4051	1.4115	1.4003	1.4062	105644.0
2018-05-09	BR	Futures	0.21294	0.2134	0.21066	0.21123	3102.0
2018-05-09	BTC	Futures	12898.3	13165.1	12575.3	13031.7	3015.0
2018-05-09	BZ	Futures	55.02	56.15	55.02	56.0	34902.0
2018-05-09	C	Futures	1744.0	1748.0	1697.0	1746.0	8750.0
2018-05-09	CB	Futures	294.034	297.431	294.034	296.813	21.0
2018-05-09	CC	Futures	2011.0	2024.0	1958.0	2019.0	31485.0
2018-05-09	CNH	Futures	6.4795	6.4823	6.4592	6.461	131.0
2018-05-09	CSC	Futures	3.563	3.584	3.555	3.561	81.0
2018-05-09	CT	Futures	97.36	97.81	96.83	97.6	12916.0
2018-05-09	DC	Futures	28.52	28.8	28.44	28.69	521.0
2018-05-09	DX	Futures	87.622	87.957	87.424	87.602	26452.0
2018-05-09	E1	Futures	1.20598	1.20743	1.20117	1.20213	22068.0
2018-05-09	E6	Futures	1.33979	1.3439	1.33557	1.3399	261003.0
2018-05-09	E7	Futures	1.3326	1.3367	1.3285	1.3327	4399.0
2018-05-09	EBM	Futures	183.08	183.6	180.99	180.99	14071.0
2018-05-09	ED	Futures	94.9354	94.9549	94.9306	94.9403	348718.0
2018-05-09	ER	Futures	98.347	98.347	98.337	98.347	181977.0
2018-05-09	EW	Futures	2028.5	2042.8	2024.5	2036.7	10823.0
2018-05-09	FBON	Futures	129.06	129.36	129.02	129.25	463.0
2018-05-09	FBTP	Futures	115.11	115.3	114.56	114.89	149677.0
2018-05-09	FBTS	Futures	104.232	104.269	104.204	104.232	63553.0
2018-05-09	FCE	Futures	4910.0	4925.6	4893.5	4914.9	50291.0
2018-05-09	FDAX	Futures	13456.2	13511.3	13399.6	13463.5	73336.0
2018-05-09	FDXM	Futures	13334.3	13389.9	13280.8	13343.6	22380.0
2018-05-09	FESX	Futures	2930.6	2944.7	2925.6	2935.6	752819.0
2018-05-09	FGBL	Futures	149.43	149.53	149.17	149.48	585423.0
2018-05-09	FGBM	Futures	129.61	129.66	129.51	129.64	340606.0
2018-05-09	FGBS	Futures	112.507	112.517	112.487	112.517	283522.0
2018-05-09	FGBX	Futures	169.11	169.29	168.44	169.06	47189.0
2018-05-09	FMWO	Futures	6958.5	7019.2	6955.0	6974.8	483.0
2018-05-09	FOAT	Futures	138.45	138.58	138.25	138.54	100038.0
2018-05-09	FTDX	Futures	2706.2	2750.3	2706.2	2742.3	519.0
2018-05-09	FTI	Futures	516.4	518.89	514.13	516.95	18845.0
2018-05-09	FTUK	Futures	6655.9	6770.8	6644.0	6725.7	167289.0
2018-05-09	FVSA	Futures	332.94	335.23	314.57	322.61	26811.0
2018-05-09	FXXP	Futures	334.6	337.6	334.4	336.6	34120.0
2018-05-09	G	Futures	113.52	113.59	113.24	113.46	227353.0
2018-05-09	GF	Futures	296.976	299.128	293.963	295.147	1331.0
2018-05-09	GSCI	Futures	545.32	546.96	544.76	546.73	2364.0
2018-05-09	HE	Futures	80.508	81.165	79.668	80.456	30776.0

> showing 50 of 112 rows — these rows as CSV

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