PREVIEW / futures_daily / 2016-06-24

all futures daily files

  file:    by_date/futures_daily/2016/2016-06-24.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
2016-06-24	ES	Futures	2284.36	2288.4	2158.3	2179.36	4174598.0
2016-06-24	NQ	Futures	5283.98	5297.24	4991.36	5024.07	497350.0
2016-06-24	YM	Futures	18786.7	18827.4	17946.9	18014.8	440328.0
2016-06-24	CL	Futures	58.43	58.6	54.25	55.34	649446.0
2016-06-24	GC	Futures	1613.7	1753.0	1611.7	1701.3	574241.0
2016-06-24	ZN	Futures	126.234041	129.629457	126.203859	127.84875	3126839.0
2016-06-24	A6	Futures	0.77477	0.77528	0.74099	0.76103	213723.0
2016-06-24	AD	Futures	0.80314	0.80314	0.78134	0.78912	98081.0
2016-06-24	ALI	Futures	2132.55	2132.55	2132.55	2132.55	0.0
2016-06-24	B	Futures	41.09	41.13	38.53	39.24	351742.0
2016-06-24	B6	Futures	1.5808	1.5823	1.3964	1.4401	505283.0
2016-06-24	BFX	Futures	3855.0	3879.1	3847.3	3847.3	4.0
2016-06-24	BR	Futures	0.18968	0.19394	0.18968	0.19341	189.0
2016-06-24	BZ	Futures	41.4	41.42	38.44	39.14	52110.0
2016-06-24	C	Futures	2452.0	2459.0	2415.0	2451.0	7065.0
2016-06-24	CB	Futures	280.186	280.186	274.531	278.985	22.0
2016-06-24	CC	Futures	2241.0	2273.0	2205.0	2216.0	32303.0
2016-06-24	CNH	Futures	7.1758	7.2121	7.1758	7.1999	64.0
2016-06-24	CSC	Futures	3.716	3.716	3.638	3.654	108.0
2016-06-24	CT	Futures	73.8	74.12	72.57	73.44	25.0
2016-06-24	DC	Futures	29.97	29.97	29.12	29.39	237.0
2016-06-24	DX	Futures	87.193	89.937	87.174	88.889	66050.0
2016-06-24	E1	Futures	1.30422	1.31173	1.28306	1.2942	36763.0
2016-06-24	E6	Futures	1.33299	1.33358	1.27443	1.29871	389173.0
2016-06-24	E7	Futures	1.3263	1.3263	1.2677	1.2918	8486.0
2016-06-24	EBM	Futures	190.66	193.06	190.06	192.76	10288.0
2016-06-24	ED	Futures	95.7473	95.8969	95.7329	95.8534	573862.0
2016-06-24	ER	Futures	98.274	98.381	98.274	98.313	86732.0
2016-06-24	EW	Futures	1612.8	1616.7	1524.8	1539.2	35892.0
2016-06-24	FBON	Futures	117.77	119.06	116.82	118.35	564.0
2016-06-24	FBTP	Futures	104.54	107.04	103.75	106.24	164752.0
2016-06-24	FBTS	Futures	100.271	100.988	100.271	100.89	34055.0
2016-06-24	FCE	Futures	3533.3	3655.7	3418.3	3574.2	267642.0
2016-06-24	FDAX	Futures	9949.7	10331.2	9739.5	10171.0	200945.0
2016-06-24	FDIV	Futures	124.52	124.52	124.1	124.1	1.0
2016-06-24	FDXM	Futures	9709.7	10070.7	9485.7	9914.0	44107.0
2016-06-24	FESX	Futures	2114.5	2213.9	2071.4	2167.7	4087721.0
2016-06-24	FEU3	Futures	98.961	98.966	98.961	98.966	10.0
2016-06-24	FGBL	Futures	151.62	151.94	149.0	149.36	882008.0
2016-06-24	FGBM	Futures	129.13	129.41	128.54	128.8	494341.0
2016-06-24	FGBS	Futures	112.137	112.162	111.872	111.932	296702.0
2016-06-24	FGBX	Futures	191.32	193.21	185.2	186.56	43231.0
2016-06-24	FMWO	Futures	5370.7	5446.1	5331.8	5406.0	1217.0
2016-06-24	FOAT	Futures	134.8	137.59	134.72	135.74	94456.0
2016-06-24	FTDX	Futures	1422.6	1535.8	1416.8	1529.6	299.0
2016-06-24	FTI	Futures	369.34	388.87	343.02	381.17	66322.0
2016-06-24	FTUK	Futures	5165.6	5186.5	4734.3	5091.4	313721.0
2016-06-24	FVSA	Futures	3544.66	3590.17	2816.51	3018.77	90070.0
2016-06-24	FXXP	Futures	241.1	262.9	241.1	257.9	74632.0
2016-06-24	G	Futures	112.4	112.77	111.73	111.95	163789.0

> showing 50 of 111 rows — these rows as CSV

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