PREVIEW / futures_daily / 2016-07-20

all futures daily files

  file:    by_date/futures_daily/2016/2016-07-20.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
2016-07-20	ES	Futures	2331.05	2342.66	2327.0	2340.23	1134131.0
2016-07-20	NQ	Futures	5432.79	5491.73	5419.53	5481.71	182311.0
2016-07-20	YM	Futures	19320.4	19391.5	19277.6	19356.0	107705.0
2016-07-20	CL	Futures	51.48	52.29	50.5	51.86	541014.0
2016-07-20	GC	Futures	1713.9	1722.4	1688.5	1697.3	224985.0
2016-07-20	ZN	Futures	127.773296	127.803478	127.350756	127.471482	838211.0
2016-07-20	A6	Futures	0.76215	0.76327	0.75768	0.7589	65982.0
2016-07-20	AD	Futures	0.78595	0.78646	0.7815	0.78365	50745.0
2016-07-20	ALI	Futures	2109.51	2113.65	2109.51	2113.65	8.0
2016-07-20	B	Futures	37.33	37.91	36.64	37.66	296296.0
2016-07-20	B6	Futures	1.3819	1.3956	1.3782	1.387	97785.0
2016-07-20	BFX	Futures	3932.5	3947.5	3932.5	3947.5	2.0
2016-07-20	BR	Futures	0.20217	0.20217	0.20153	0.2018	7.0
2016-07-20	BZ	Futures	37.16	37.78	36.51	37.52	30188.0
2016-07-20	C	Futures	2590.0	2610.0	2570.0	2574.0	8943.0
2016-07-20	CB	Futures	280.099	280.186	278.399	278.399	35.0
2016-07-20	CC	Futures	2200.0	2212.0	2163.0	2177.0	23030.0
2016-07-20	CNH	Futures	7.2623	7.2623	7.2431	7.2431	17.0
2016-07-20	CSC	Futures	3.712	3.712	3.693	3.693	5.0
2016-07-20	CT	Futures	82.6	82.6	80.62	81.5	33.0
2016-07-20	DC	Futures	29.8	29.86	29.55	29.64	59.0
2016-07-20	DX	Futures	90.309	90.56	90.225	90.46	22246.0
2016-07-20	E1	Futures	1.27442	1.27504	1.26803	1.27216	15968.0
2016-07-20	E6	Futures	1.28579	1.28718	1.28136	1.2841	124763.0
2016-07-20	E7	Futures	1.2787	1.2801	1.2746	1.2772	3025.0
2016-07-20	EBM	Futures	193.66	195.47	192.76	193.06	14210.0
2016-07-20	ED	Futures	95.7329	95.7377	95.7087	95.7087	231893.0
2016-07-20	ER	Futures	98.313	98.318	98.303	98.308	69250.0
2016-07-20	EW	Futures	1631.8	1642.8	1628.4	1639.6	11758.0
2016-07-20	FBON	Futures	122.5	122.8	122.38	122.74	435.0
2016-07-20	FBTP	Futures	109.38	109.57	109.24	109.4	71059.0
2016-07-20	FBTS	Futures	101.311	101.329	101.302	101.311	17234.0
2016-07-20	FCE	Futures	3789.1	3833.6	3780.0	3821.9	66864.0
2016-07-20	FDAX	Futures	10632.9	10789.3	10618.5	10785.0	74118.0
2016-07-20	FDXM	Futures	10362.1	10515.6	10350.7	10512.5	19380.0
2016-07-20	FESX	Futures	2295.4	2323.6	2293.0	2320.4	909350.0
2016-07-20	FGBL	Futures	149.87	150.03	149.5	149.66	540753.0
2016-07-20	FGBM	Futures	128.91	128.94	128.76	128.82	432204.0
2016-07-20	FGBS	Futures	111.922	111.922	111.872	111.887	194517.0
2016-07-20	FGBX	Futures	185.61	186.45	184.3	184.85	25629.0
2016-07-20	FMWO	Futures	5679.6	5707.5	5679.6	5706.3	129.0
2016-07-20	FOAT	Futures	137.83	137.96	137.5	137.66	63126.0
2016-07-20	FTDX	Futures	1579.7	1604.8	1579.7	1603.3	91.0
2016-07-20	FTI	Futures	400.52	405.02	400.02	403.62	24008.0
2016-07-20	FTUK	Futures	5547.3	5576.9	5536.9	5571.5	87431.0
2016-07-20	FVSA	Futures	2298.68	2323.08	2244.99	2274.28	14089.0
2016-07-20	FXXP	Futures	272.3	274.9	272.0	274.7	32544.0
2016-07-20	G	Futures	114.87	114.92	114.29	114.49	171104.0
2016-07-20	GF	Futures	277.36	281.354	275.363	276.811	3843.0
2016-07-20	GSCI	Futures	504.83	511.29	504.83	509.14	117.0

> showing 50 of 109 rows — these rows as CSV

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