PREVIEW / futures_daily / 2018-10-09

all futures daily files

  file:    by_date/futures_daily/2018/2018-10-09.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-09	ES	Futures	3136.68	3145.08	3117.43	3132.34	1770753.0
2018-10-09	NQ	Futures	8584.84	8660.05	8522.11	8594.13	583403.0
2018-10-09	YM	Futures	27938.3	27970.9	27734.0	27885.6	235037.0
2018-10-09	CL	Futures	77.68	78.8	77.46	78.47	623537.0
2018-10-09	GC	Futures	1511.0	1515.6	1503.9	1510.1	243864.0
2018-10-09	ZN	Futures	117.176163	117.39405	117.004967	117.34736	1937388.0
2018-10-09	A6	Futures	0.72881	0.73148	0.72623	0.73107	92255.0
2018-10-09	AD	Futures	0.78164	0.7827	0.77856	0.7822	56664.0
2018-10-09	B	Futures	61.65	62.78	61.52	62.45	351396.0
2018-10-09	B6	Futures	1.3509	1.3567	1.3445	1.3561	117805.0
2018-10-09	BR	Futures	0.20136	0.20483	0.20052	0.20483	1693.0
2018-10-09	BTC	Futures	9552.8	9552.8	9430.2	9495.1	1004.0
2018-10-09	BZ	Futures	61.09	62.31	61.05	61.99	39232.0
2018-10-09	C	Futures	1445.0	1460.0	1435.0	1457.0	6532.0
2018-10-09	CB	Futures	272.769	272.769	271.567	271.567	52.0
2018-10-09	CC	Futures	1462.0	1486.0	1449.0	1480.0	20432.0
2018-10-09	CNH	Futures	7.0088	7.0148	6.9879	6.9879	961.0
2018-10-09	CSC	Futures	3.208	3.212	3.2	3.21	74.0
2018-10-09	CT	Futures	86.99	87.43	85.53	86.44	16131.0
2018-10-09	DC	Futures	26.69	26.76	26.63	26.73	66.0
2018-10-09	DX	Futures	90.652	91.046	90.543	90.577	21726.0
2018-10-09	E1	Futures	1.20161	1.20315	1.19781	1.20184	22162.0
2018-10-09	E6	Futures	1.28473	1.28589	1.27789	1.28528	254931.0
2018-10-09	E7	Futures	1.2783	1.2795	1.2715	1.279	4906.0
2018-10-09	EBM	Futures	210.79	212.09	210.27	211.57	13213.0
2018-10-09	ED	Futures	95.0671	95.0671	95.0525	95.0573	280865.0
2018-10-09	ER	Futures	98.377	98.377	98.372	98.372	34998.0
2018-10-09	EW	Futures	2074.9	2075.7	2060.2	2061.6	18897.0
2018-10-09	FBON	Futures	127.01	127.04	126.65	126.95	894.0
2018-10-09	FBTP	Futures	102.84	103.96	101.81	103.28	156024.0
2018-10-09	FBTS	Futures	100.823	101.516	100.551	101.197	95686.0
2018-10-09	FCE	Futures	4781.5	4808.5	4737.7	4790.9	98294.0
2018-10-09	FDAX	Futures	12549.0	12612.6	12394.4	12587.9	119779.0
2018-10-09	FDIV	Futures	142.09	142.09	141.14	141.95	29.0
2018-10-09	FDXM	Futures	12337.8	12394.7	12178.7	12369.9	64806.0
2018-10-09	FESX	Futures	2773.0	2789.8	2742.8	2783.1	1151609.0
2018-10-09	FGBL	Futures	151.16	151.38	150.84	151.3	880493.0
2018-10-09	FGBM	Futures	130.23	130.39	130.1	130.26	632849.0
2018-10-09	FGBS	Futures	112.532	112.578	112.502	112.522	525388.0
2018-10-09	FGBX	Futures	172.81	173.78	171.98	173.48	56829.0
2018-10-09	FMWO	Futures	7130.4	7154.8	7087.6	7149.0	1496.0
2018-10-09	FOAT	Futures	138.82	138.98	138.56	138.95	173488.0
2018-10-09	FTDX	Futures	2597.0	2619.6	2563.6	2612.8	320.0
2018-10-09	FTI	Futures	496.82	499.84	492.23	498.12	29681.0
2018-10-09	FTUK	Futures	6448.0	6452.9	6389.9	6442.6	127290.0
2018-10-09	FVSA	Futures	287.27	300.21	285.54	287.27	36257.0
2018-10-09	FXXP	Futures	322.1	323.0	318.7	322.2	71686.0
2018-10-09	G	Futures	112.58	112.85	112.51	112.8	372765.0
2018-10-09	GF	Futures	327.956	328.164	325.563	326.499	962.0
2018-10-09	GSCI	Futures	554.94	556.62	553.26	556.62	2919.0

> showing 50 of 116 rows — these rows as CSV

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