PREVIEW / futures_daily / 2018-03-16

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-16.parquet
  size:    9 KB
  rows:    111

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-03-16	ES	Futures	2998.69	3008.21	2990.81	2997.06	1142517.0
2018-03-16	NQ	Futures	8278.18	8292.23	8231.66	8244.53	287434.0
2018-03-16	YM	Futures	26276.0	26387.7	26174.9	26298.2	173972.0
2018-03-16	CL	Futures	61.5	62.87	61.4	62.68	437177.0
2018-03-16	GC	Futures	1682.0	1688.4	1672.7	1676.3	289601.0
2018-03-16	ZN	Futures	119.555659	119.710745	119.369556	119.447099	1001737.0
2018-03-16	A6	Futures	0.80213	0.80275	0.79298	0.79339	128214.0
2018-03-16	AD	Futures	0.77675	0.77701	0.77347	0.77397	94712.0
2018-03-16	B	Futures	46.96	47.94	46.82	47.78	264214.0
2018-03-16	B6	Futures	1.4498	1.454	1.4442	1.4495	123495.0
2018-03-16	BFX	Futures	4592.6	4592.6	4582.8	4582.8	32.0
2018-03-16	BR	Futures	0.23165	0.23165	0.22974	0.23077	18.0
2018-03-16	BTC	Futures	11569.2	11985.3	10938.0	11867.4	3065.0
2018-03-16	BZ	Futures	46.37	47.35	46.26	47.2	29187.0
2018-03-16	C	Futures	1673.0	1689.0	1670.0	1677.0	12656.0
2018-03-16	CB	Futures	279.208	279.517	278.961	279.208	27.0
2018-03-16	CC	Futures	1861.0	1868.0	1845.0	1850.0	15505.0
2018-03-16	CNH	Futures	6.444	6.4564	6.444	6.4466	42.0
2018-03-16	CSC	Futures	3.289	3.308	3.289	3.308	24.0
2018-03-16	CT	Futures	96.21	96.21	94.74	95.23	10030.0
2018-03-16	DC	Futures	26.17	26.31	26.06	26.26	71.0
2018-03-16	DX	Futures	84.585	84.835	84.363	84.69	26086.0
2018-03-16	E1	Futures	1.27608	1.28006	1.27162	1.27439	31945.0
2018-03-16	E6	Futures	1.396	1.39961	1.39093	1.39364	329944.0
2018-03-16	E7	Futures	1.3889	1.3921	1.3834	1.3862	3498.0
2018-03-16	EBM	Futures	177.74	177.74	176.4	176.93	16679.0
2018-03-16	ED	Futures	94.9986	95.0084	94.9743	94.9792	358006.0
2018-03-16	ER	Futures	98.337	98.342	98.332	98.337	96937.0
2018-03-16	EW	Futures	2044.9	2059.7	2038.4	2053.9	15858.0
2018-03-16	FBON	Futures	128.43	128.57	128.33	128.35	253.0
2018-03-16	FBTP	Futures	113.61	113.99	113.44	113.56	94917.0
2018-03-16	FBTS	Futures	103.88	103.936	103.88	103.908	34028.0
2018-03-16	FCE	Futures	4620.5	4657.1	4614.4	4641.7	68939.0
2018-03-16	FDAX	Futures	12837.7	12896.8	12820.1	12826.5	7774.0
2018-03-16	FDXM	Futures	12746.3	12833.8	12711.3	12785.9	29255.0
2018-03-16	FESX	Futures	2771.4	2798.9	2768.1	2790.6	1187508.0
2018-03-16	FGBL	Futures	148.91	149.01	148.67	148.86	466021.0
2018-03-16	FGBM	Futures	129.27	129.31	129.17	129.26	259388.0
2018-03-16	FGBS	Futures	112.487	112.512	112.472	112.502	154403.0
2018-03-16	FGBX	Futures	168.75	168.96	168.17	168.73	37024.0
2018-03-16	FMWO	Futures	7055.4	7061.2	7051.9	7051.9	338.0
2018-03-16	FOAT	Futures	137.93	138.09	137.82	137.94	82348.0
2018-03-16	FTDX	Futures	2677.0	2677.0	2648.3	2651.8	296.0
2018-03-16	FTI	Futures	487.49	491.67	487.08	490.84	29515.0
2018-03-16	FTUK	Futures	6233.1	6275.9	6219.4	6253.4	117060.0
2018-03-16	FVSA	Futures	400.71	403.09	378.12	382.88	24301.0
2018-03-16	FXXP	Futures	319.2	321.2	319.1	319.9	36597.0
2018-03-16	G	Futures	113.5	113.66	113.3	113.46	138765.0
2018-03-16	GF	Futures	306.718	307.481	304.05	305.357	5539.0
2018-03-16	GSCI	Futures	503.87	508.1	503.58	508.1	38.0

> showing 50 of 111 rows — these rows as CSV

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