PREVIEW / futures_daily / 2016-07-12

all futures daily files

  file:    by_date/futures_daily/2016/2016-07-12.parquet
  size:    9 KB
  rows:    108

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-12	ES	Futures	2300.55	2320.53	2298.12	2316.75	1704053.0
2016-07-12	NQ	Futures	5366.49	5400.97	5359.42	5386.53	190097.0
2016-07-12	YM	Futures	18959.0	19101.1	18941.3	19077.1	131748.0
2016-07-12	CL	Futures	51.78	54.51	51.7	54.36	658257.0
2016-07-12	GC	Futures	1744.9	1748.2	1712.3	1717.9	257335.0
2016-07-12	ZN	Futures	128.603287	128.693831	127.833659	127.984567	1431378.0
2016-07-12	A6	Futures	0.76449	0.77731	0.76429	0.77518	104572.0
2016-07-12	AD	Futures	0.78027	0.78856	0.77925	0.786	72926.0
2016-07-12	ALI	Futures	2161.75	2185.55	2157.62	2183.33	51.0
2016-07-12	B	Futures	36.86	38.78	36.8	38.7	321525.0
2016-07-12	B6	Futures	1.3715	1.4027	1.3687	1.3998	157236.0
2016-07-12	BR	Futures	0.2004	0.20123	0.19917	0.19917	22.0
2016-07-12	BZ	Futures	36.75	38.62	36.68	38.55	32157.0
2016-07-12	C	Futures	2649.0	2651.0	2625.0	2628.0	12195.0
2016-07-12	CB	Futures	276.494	276.494	271.981	273.417	25.0
2016-07-12	CC	Futures	2282.0	2294.0	2260.0	2283.0	11419.0
2016-07-12	CNH	Futures	7.269	7.269	7.2664	7.2664	1.0
2016-07-12	CSC	Futures	3.559	3.576	3.542	3.551	39.0
2016-07-12	CT	Futures	77.32	80.59	76.92	80.59	54.0
2016-07-12	DC	Futures	28.49	28.71	28.33	28.51	113.0
2016-07-12	DX	Futures	89.797	89.899	89.355	89.738	18974.0
2016-07-12	E1	Futures	1.27855	1.28306	1.27003	1.27179	20786.0
2016-07-12	E6	Futures	1.29085	1.29865	1.28992	1.29178	144077.0
2016-07-12	E7	Futures	1.2841	1.2916	1.2831	1.2849	3641.0
2016-07-12	EBM	Futures	194.27	194.27	190.36	193.66	18480.0
2016-07-12	ED	Futures	95.7859	95.7907	95.7666	95.7714	248013.0
2016-07-12	ER	Futures	98.328	98.332	98.318	98.323	51369.0
2016-07-12	EW	Futures	1617.4	1638.4	1616.6	1633.3	18291.0
2016-07-12	FBON	Futures	122.74	122.85	122.45	122.5	200.0
2016-07-12	FBTP	Futures	109.76	109.86	109.4	109.46	70963.0
2016-07-12	FBTS	Futures	101.338	101.338	101.284	101.284	14803.0
2016-07-12	FCE	Futures	3715.8	3789.1	3713.2	3778.7	125944.0
2016-07-12	FDAX	Futures	10427.0	10646.7	10413.7	10603.6	86530.0
2016-07-12	FDXM	Futures	10157.8	10378.7	10150.5	10335.7	21336.0
2016-07-12	FESX	Futures	2248.4	2298.5	2246.8	2293.8	1323757.0
2016-07-12	FEU3	Futures	98.976	98.976	98.976	98.976	1.0
2016-07-12	FGBL	Futures	150.66	150.69	149.66	149.95	715765.0
2016-07-12	FGBM	Futures	129.2	129.2	128.94	129.0	489652.0
2016-07-12	FGBS	Futures	112.012	112.012	111.952	111.972	204330.0
2016-07-12	FGBX	Futures	190.11	190.11	186.06	187.09	39743.0
2016-07-12	FMWO	Futures	5635.8	5655.3	5628.5	5655.3	652.0
2016-07-12	FOAT	Futures	138.63	138.69	137.86	138.0	92003.0
2016-07-12	FTDX	Futures	1575.8	1578.7	1564.3	1566.2	112.0
2016-07-12	FTI	Futures	392.65	398.04	392.65	397.41	20862.0
2016-07-12	FTUK	Futures	5521.0	5549.4	5511.4	5526.4	129945.0
2016-07-12	FVSA	Futures	2381.64	2386.53	2259.63	2303.56	8288.0
2016-07-12	FXXP	Futures	267.7	272.0	267.7	271.3	38048.0
2016-07-12	G	Futures	114.93	115.12	114.44	114.67	186275.0
2016-07-12	GF	Futures	277.709	280.355	273.316	276.761	6482.0
2016-07-12	GSCI	Futures	520.76	526.57	517.18	524.78	3459.0

> showing 50 of 108 rows — these rows as CSV

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