PREVIEW / futures_daily / 2017-07-07

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-07.parquet
  size:    10 KB
  rows:    110

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
2017-07-07	ES	Futures	2618.43	2635.54	2616.53	2632.83	1266391.0
2017-07-07	NQ	Futures	6581.27	6672.96	6573.04	6648.57	266767.0
2017-07-07	YM	Futures	22494.2	22597.8	22478.3	22590.4	106494.0
2017-07-07	CL	Futures	46.83	46.9	45.21	45.67	975914.0
2017-07-07	GC	Futures	1563.3	1567.8	1540.3	1544.3	322183.0
2017-07-07	ZN	Futures	123.134298	123.226637	122.91884	122.965009	1509536.0
2017-07-07	A6	Futures	0.77835	0.78246	0.77712	0.7803	74966.0
2017-07-07	AD	Futures	0.78458	0.79175	0.78356	0.79048	86727.0
2017-07-07	ALI	Futures	2537.53	2537.53	2537.53	2537.53	0.0
2017-07-07	B	Futures	33.77	33.77	32.72	33.03	302323.0
2017-07-07	B6	Futures	1.3585	1.3589	1.3475	1.3492	98729.0
2017-07-07	BR	Futures	0.22274	0.22371	0.22241	0.22371	28.0
2017-07-07	BZ	Futures	33.71	33.71	32.51	32.81	28644.0
2017-07-07	C	Futures	1524.0	1526.0	1496.0	1504.0	964.0
2017-07-07	CB	Futures	314.142	318.339	313.838	318.339	12.0
2017-07-07	CC	Futures	1454.0	1459.0	1417.0	1421.0	18566.0
2017-07-07	CNH	Futures	7.0656	7.069	7.065	7.065	7.0
2017-07-07	CSC	Futures	3.511	3.532	3.497	3.497	50.0
2017-07-07	CT	Futures	81.08	81.58	81.08	81.4	23.0
2017-07-07	DC	Futures	29.35	29.51	29.18	29.18	177.0
2017-07-07	DX	Futures	89.254	89.576	89.198	89.447	20491.0
2017-07-07	E1	Futures	1.2839	1.28476	1.27776	1.27948	19554.0
2017-07-07	E6	Futures	1.31346	1.31553	1.3086	1.31123	200789.0
2017-07-07	E7	Futures	1.3064	1.3086	1.3017	1.3044	3172.0
2017-07-07	EBM	Futures	196.8	199.59	196.25	199.31	9838.0
2017-07-07	ED	Futures	95.5644	95.5838	95.5547	95.5741	218522.0
2017-07-07	ER	Futures	98.332	98.337	98.332	98.337	40690.0
2017-07-07	EW	Futures	1836.1	1857.6	1836.1	1856.2	14661.0
2017-07-07	FBON	Futures	122.42	122.74	122.09	122.18	583.0
2017-07-07	FBTP	Futures	106.09	106.27	105.51	105.67	141689.0
2017-07-07	FBTS	Futures	102.635	102.663	102.608	102.626	35889.0
2017-07-07	FCE	Futures	4636.5	4651.9	4620.3	4637.4	60676.0
2017-07-07	FDAX	Futures	12990.3	13074.5	12980.3	13021.4	64092.0
2017-07-07	FDXM	Futures	12911.9	12996.7	12901.5	12941.2	16356.0
2017-07-07	FESX	Futures	2812.8	2831.6	2810.4	2819.4	631155.0
2017-07-07	FEU3	Futures	99.011	99.011	99.011	99.011	2.0
2017-07-07	FGBL	Futures	145.84	146.01	145.63	145.8	782636.0
2017-07-07	FGBM	Futures	128.12	128.34	128.08	128.25	450801.0
2017-07-07	FGBS	Futures	112.071	112.116	112.046	112.101	296863.0
2017-07-07	FGBX	Futures	162.06	162.63	161.29	161.55	51367.0
2017-07-07	FMWO	Futures	6369.7	6382.8	6363.8	6382.8	687.0
2017-07-07	FOAT	Futures	133.64	133.85	133.37	133.52	128595.0
2017-07-07	FTDX	Futures	2214.6	2222.6	2195.0	2218.1	286.0
2017-07-07	FTI	Futures	469.48	471.46	468.55	470.31	22760.0
2017-07-07	FTUK	Futures	6266.8	6315.2	6265.1	6291.9	72101.0
2017-07-07	FVSA	Futures	510.13	514.85	495.96	502.26	13541.0
2017-07-07	FXXP	Futures	322.7	323.3	321.5	322.3	26133.0
2017-07-07	G	Futures	113.47	113.78	113.23	113.59	175701.0
2017-07-07	GF	Futures	318.631	320.168	315.777	318.357	4870.0
2017-07-07	GSCI	Futures	446.52	446.83	444.94	445.18	143.0

> showing 50 of 110 rows — these rows as CSV

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