PREVIEW / futures_daily / 2017-07-10

all futures daily files

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

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-10	ES	Futures	2633.37	2640.98	2629.3	2635.0	861222.0
2017-07-10	NQ	Futures	6657.09	6714.1	6641.81	6693.53	241360.0
2017-07-10	YM	Futures	22578.8	22623.2	22532.3	22578.8	88382.0
2017-07-10	CL	Futures	45.8	46.3	45.08	45.85	848570.0
2017-07-10	GC	Futures	1547.3	1551.0	1537.0	1548.7	238256.0
2017-07-10	ZN	Futures	123.026569	123.257417	122.980399	123.195857	886577.0
2017-07-10	A6	Futures	0.77989	0.78143	0.77866	0.78071	41567.0
2017-07-10	AD	Futures	0.79023	0.79104	0.78723	0.79048	62158.0
2017-07-10	ALI	Futures	2518.53	2518.53	2511.24	2511.24	11.0
2017-07-10	B	Futures	33.12	33.5	32.6	33.15	268902.0
2017-07-10	B6	Futures	1.3499	1.3519	1.3461	1.3495	67823.0
2017-07-10	BR	Futures	0.22386	0.22523	0.22386	0.22497	24.0
2017-07-10	BZ	Futures	32.95	33.28	32.4	32.93	21447.0
2017-07-10	C	Futures	1504.0	1525.0	1457.0	1476.0	14235.0
2017-07-10	CB	Futures	323.204	323.204	321.136	321.136	2.0
2017-07-10	CC	Futures	1417.0	1444.0	1378.0	1395.0	26424.0
2017-07-10	CNH	Futures	7.0665	7.0672	7.0655	7.0655	4.0
2017-07-10	CSC	Futures	3.493	3.493	3.448	3.454	116.0
2017-07-10	CT	Futures	81.11	83.35	78.85	79.03	125.0
2017-07-10	DC	Futures	29.16	29.16	28.71	28.8	358.0
2017-07-10	DX	Futures	89.45	89.59	89.352	89.433	20007.0
2017-07-10	E1	Futures	1.27984	1.28083	1.27481	1.27776	13087.0
2017-07-10	E6	Futures	1.31083	1.31295	1.30877	1.31123	128842.0
2017-07-10	E7	Futures	1.304	1.3061	1.302	1.3044	1652.0
2017-07-10	EBM	Futures	202.37	203.76	201.26	201.81	15530.0
2017-07-10	ED	Futures	95.5789	95.5886	95.5741	95.5789	207359.0
2017-07-10	ER	Futures	98.332	98.337	98.332	98.337	25986.0
2017-07-10	EW	Futures	1854.6	1859.8	1848.4	1851.1	11229.0
2017-07-10	FBON	Futures	122.21	122.82	122.13	122.68	376.0
2017-07-10	FBTP	Futures	105.67	106.37	105.61	106.3	84095.0
2017-07-10	FBTS	Futures	102.59	102.708	102.59	102.699	28470.0
2017-07-10	FCE	Futures	4663.1	4669.0	4639.7	4655.9	54445.0
2017-07-10	FDAX	Futures	13109.8	13139.3	13050.3	13093.0	60863.0
2017-07-10	FDXM	Futures	13028.1	13054.2	12969.5	13012.4	14185.0
2017-07-10	FESX	Futures	2836.5	2840.6	2824.3	2834.1	486112.0
2017-07-10	FGBL	Futures	145.75	146.38	145.75	146.2	600631.0
2017-07-10	FGBM	Futures	128.24	128.44	128.24	128.35	371668.0
2017-07-10	FGBS	Futures	112.086	112.141	112.081	112.106	268535.0
2017-07-10	FGBX	Futures	161.35	162.99	161.35	162.48	39923.0
2017-07-10	FMWO	Futures	6406.7	6407.8	6390.0	6406.7	469.0
2017-07-10	FOAT	Futures	133.48	134.01	133.43	133.89	82124.0
2017-07-10	FTDX	Futures	2233.6	2262.6	2228.6	2235.1	205.0
2017-07-10	FTI	Futures	470.31	470.72	469.15	470.08	97.0
2017-07-10	FTUK	Futures	6315.2	6333.4	6291.9	6317.4	68933.0
2017-07-10	FVSA	Futures	491.24	494.39	475.49	480.22	21035.0
2017-07-10	FXXP	Futures	324.0	324.4	323.0	324.1	22366.0
2017-07-10	G	Futures	113.62	114.0	113.45	113.91	131402.0
2017-07-10	GF	Futures	317.424	319.07	314.35	317.588	5089.0
2017-07-10	GSCI	Futures	445.18	445.61	445.18	445.43	2366.0
2017-07-10	HE	Futures	95.684	96.288	94.019	94.191	22396.0

> showing 50 of 107 rows — these rows as CSV

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