PREVIEW / futures_daily / 2018-02-27

all futures daily files

  file:    by_date/futures_daily/2018/2018-02-27.parquet
  size:    9 KB
  rows:    109

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-02-27	ES	Futures	3025.33	3032.12	2980.22	2986.2	1717155.0
2018-02-27	NQ	Futures	8202.36	8208.8	8085.82	8099.59	498392.0
2018-02-27	YM	Futures	27164.6	27222.6	26774.4	26817.6	310010.0
2018-02-27	CL	Futures	64.51	64.53	63.08	63.46	562670.0
2018-02-27	GC	Futures	1704.9	1709.6	1678.9	1684.3	334717.0
2018-02-27	ZN	Futures	119.22932	119.35273	118.720255	118.859091	2092694.0
2018-02-27	A6	Futures	0.80758	0.80933	0.80059	0.80193	110777.0
2018-02-27	AD	Futures	0.80087	0.80163	0.79478	0.79625	73663.0
2018-02-27	B	Futures	48.61	48.66	47.79	48.01	286282.0
2018-02-27	B6	Futures	1.4535	1.4567	1.442	1.4484	138738.0
2018-02-27	BTC	Futures	14267.2	15085.7	14010.6	14787.4	761.0
2018-02-27	BZ	Futures	48.0	48.05	47.19	47.42	24086.0
2018-02-27	C	Futures	1421.0	1440.0	1410.0	1434.0	9249.0
2018-02-27	CB	Futures	290.945	290.945	286.745	286.93	33.0
2018-02-27	CC	Futures	1626.0	1639.0	1610.0	1634.0	22649.0
2018-02-27	CNH	Futures	6.4253	6.4558	6.4213	6.4516	48.0
2018-02-27	CSC	Futures	3.31	3.337	3.31	3.337	8.0
2018-02-27	CT	Futures	94.43	94.76	93.28	94.54	15097.0
2018-02-27	DC	Futures	26.26	26.47	26.24	26.46	35.0
2018-02-27	DX	Futures	84.214	84.928	84.162	84.782	29716.0
2018-02-27	E1	Futures	1.29562	1.29901	1.29088	1.29477	29738.0
2018-02-27	E6	Futures	1.39753	1.40144	1.38721	1.38908	280019.0
2018-02-27	E7	Futures	1.3908	1.3943	1.3802	1.3821	3878.0
2018-02-27	EBM	Futures	177.21	177.48	176.94	177.21	9420.0
2018-02-27	ED	Futures	95.0664	95.0688	95.047	95.0518	378130.0
2018-02-27	ER	Futures	98.328	98.337	98.328	98.332	82130.0
2018-02-27	EW	Futures	2032.9	2038.3	2000.0	2001.4	15432.0
2018-02-27	FBON	Futures	126.37	126.53	126.24	126.42	344.0
2018-02-27	FBTP	Futures	111.41	111.74	111.25	111.62	112736.0
2018-02-27	FBTS	Futures	103.595	103.64	103.576	103.622	67634.0
2018-02-27	FCE	Futures	4734.9	4737.1	4695.6	4719.4	55597.0
2018-02-27	FDAX	Futures	13033.8	13044.2	12885.4	12940.9	98335.0
2018-02-27	FDXM	Futures	13058.0	13067.3	12907.3	12962.9	33963.0
2018-02-27	FESX	Futures	2834.7	2839.6	2808.6	2820.0	1010881.0
2018-02-27	FGBL	Futures	147.78	147.83	147.41	147.54	814883.0
2018-02-27	FGBM	Futures	128.77	128.79	128.62	128.7	543692.0
2018-02-27	FGBS	Futures	112.347	112.352	112.316	112.331	376181.0
2018-02-27	FGBX	Futures	166.54	166.6	165.66	165.88	48560.0
2018-02-27	FMWO	Futures	7140.6	7148.8	7056.6	7099.7	2404.0
2018-02-27	FOAT	Futures	136.63	136.69	136.33	136.47	130003.0
2018-02-27	FTDX	Futures	2622.7	2624.1	2601.7	2609.2	55.0
2018-02-27	FTI	Futures	495.94	496.49	491.11	493.73	19626.0
2018-02-27	FTUK	Futures	6387.2	6394.6	6309.0	6345.7	90396.0
2018-02-27	FVSA	Futures	397.65	432.12	397.65	409.96	21788.0
2018-02-27	FXXP	Futures	326.6	327.2	324.1	325.3	27725.0
2018-02-27	G	Futures	112.62	112.85	112.13	112.27	243509.0
2018-02-27	GF	Futures	320.227	323.96	320.062	321.819	4166.0
2018-02-27	GSCI	Futures	514.91	515.48	510.76	512.18	44.0
2018-02-27	HE	Futures	89.981	90.752	89.628	89.821	20371.0
2018-02-27	HG	Futures	3.8351	3.8511	3.7631	3.791	103012.0

> showing 50 of 109 rows — these rows as CSV

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