PREVIEW / futures_daily / 2018-10-10

all futures daily files

  file:    by_date/futures_daily/2018/2018-10-10.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-10-10	ES	Futures	3130.71	3135.59	3005.72	3016.03	3460738.0
2018-10-10	NQ	Futures	8589.19	8609.23	8130.68	8167.85	924204.0
2018-10-10	YM	Futures	27876.2	27928.8	26779.9	26872.6	413483.0
2018-10-10	CL	Futures	78.16	78.59	75.77	76.6	652737.0
2018-10-10	GC	Futures	1511.7	1519.1	1506.3	1512.5	248561.0
2018-10-10	ZN	Futures	117.331796	117.736442	117.082783	117.285106	2551116.0
2018-10-10	A6	Futures	0.73128	0.73405	0.7251	0.72932	105646.0
2018-10-10	AD	Futures	0.7822	0.78321	0.77466	0.77684	70790.0
2018-10-10	B	Futures	62.44	62.58	60.44	61.05	319094.0
2018-10-10	B6	Futures	1.3556	1.3633	1.3552	1.3615	111413.0
2018-10-10	BR	Futures	0.2046	0.2046	0.20148	0.20197	51.0
2018-10-10	BTC	Futures	9495.1	9509.6	9307.5	9437.4	1700.0
2018-10-10	BZ	Futures	61.9	62.1	60.0	60.59	31715.0
2018-10-10	C	Futures	1454.0	1459.0	1423.0	1431.0	4441.0
2018-10-10	CB	Futures	270.966	270.966	270.606	270.606	22.0
2018-10-10	CC	Futures	1478.0	1488.0	1448.0	1458.0	15682.0
2018-10-10	CNH	Futures	6.9921	7.0024	6.9848	6.9942	621.0
2018-10-10	CSC	Futures	3.212	3.212	3.192	3.196	50.0
2018-10-10	CT	Futures	86.44	87.07	85.86	86.21	14968.0
2018-10-10	DC	Futures	26.66	26.68	26.49	26.59	175.0
2018-10-10	DX	Futures	90.538	90.695	90.296	90.416	20043.0
2018-10-10	E1	Futures	1.20232	1.20492	1.20007	1.20172	22941.0
2018-10-10	E6	Futures	1.28439	1.29051	1.28317	1.28823	216787.0
2018-10-10	E7	Futures	1.2784	1.284	1.2769	1.2819	4466.0
2018-10-10	EBM	Futures	211.57	211.83	210.27	210.79	8841.0
2018-10-10	ED	Futures	95.0525	95.0671	95.0427	95.0573	392789.0
2018-10-10	ER	Futures	98.372	98.377	98.372	98.377	25781.0
2018-10-10	EW	Futures	2061.0	2065.6	1991.6	2007.1	35979.0
2018-10-10	FBON	Futures	126.9	126.99	126.69	126.85	549.0
2018-10-10	FBTP	Futures	103.74	104.14	102.71	103.57	117085.0
2018-10-10	FBTS	Futures	101.385	101.572	100.935	101.291	82415.0
2018-10-10	FCE	Futures	4791.8	4803.1	4648.5	4692.7	116651.0
2018-10-10	FDAX	Futures	12556.3	12601.0	12203.6	12324.5	151909.0
2018-10-10	FDXM	Futures	12340.9	12381.2	11992.7	12111.0	76597.0
2018-10-10	FESX	Futures	2775.5	2783.1	2711.7	2739.4	1372769.0
2018-10-10	FEU3	Futures	98.996	99.001	98.996	99.001	575.0
2018-10-10	FGBL	Futures	151.3	151.36	150.68	151.09	759645.0
2018-10-10	FGBM	Futures	130.25	130.28	130.01	130.18	480792.0
2018-10-10	FGBS	Futures	112.522	112.532	112.477	112.507	437709.0
2018-10-10	FGBX	Futures	173.64	173.84	172.24	173.13	49014.0
2018-10-10	FMWO	Futures	7137.4	7139.7	6941.6	7038.9	3821.0
2018-10-10	FOAT	Futures	139.0	139.0	138.42	138.73	151881.0
2018-10-10	FTDX	Futures	2612.8	2624.5	2491.9	2509.1	321.0
2018-10-10	FTI	Futures	498.12	498.49	488.09	490.79	343.0
2018-10-10	FTUK	Futures	6419.4	6442.6	6309.5	6368.0	141658.0
2018-10-10	FVSA	Futures	291.58	344.2	288.13	310.56	48811.0
2018-10-10	FXXP	Futures	321.8	322.5	314.1	317.1	71100.0
2018-10-10	G	Futures	112.52	112.62	112.24	112.46	278122.0
2018-10-10	GF	Futures	326.499	326.915	323.796	324.732	8014.0
2018-10-10	GSCI	Futures	556.62	557.76	556.62	557.76	2896.0

> showing 50 of 116 rows — these rows as CSV

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