PREVIEW / futures_daily / 2018-02-07

all futures daily files

  file:    by_date/futures_daily/2018/2018-02-07.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
2018-02-07	ES	Futures	2918.81	2963.65	2891.64	2900.06	2491133.0
2018-02-07	NQ	Futures	7774.29	7867.69	7650.14	7677.96	593446.0
2018-02-07	YM	Futures	26093.1	26617.2	25841.0	26085.7	429666.0
2018-02-07	CL	Futures	63.9	64.16	61.24	61.78	1029408.0
2018-02-07	GC	Futures	1694.5	1705.0	1677.8	1679.2	351230.0
2018-02-07	ZN	Futures	119.661255	120.062337	119.321878	119.460714	2201308.0
2018-02-07	A6	Futures	0.81293	0.81334	0.80388	0.80481	126616.0
2018-02-07	AD	Futures	0.81275	0.81285	0.80747	0.80792	77626.0
2018-02-07	B	Futures	48.22	48.59	46.76	47.01	567758.0
2018-02-07	B6	Futures	1.4535	1.4575	1.4423	1.4456	131068.0
2018-02-07	BR	Futures	0.23347	0.23378	0.23059	0.23142	5807.0
2018-02-07	BTC	Futures	9915.4	11112.5	9414.4	10728.7	1379.0
2018-02-07	BZ	Futures	47.61	47.96	46.14	46.39	56412.0
2018-02-07	C	Futures	1345.0	1354.0	1321.0	1325.0	15306.0
2018-02-07	CB	Futures	264.414	264.723	263.765	263.765	66.0
2018-02-07	CC	Futures	1520.0	1533.0	1478.0	1495.0	45665.0
2018-02-07	CNH	Futures	6.4094	6.4569	6.3953	6.4486	239.0
2018-02-07	CSC	Futures	3.199	3.21	3.176	3.178	74.0
2018-02-07	CT	Futures	88.89	89.85	88.55	88.72	27161.0
2018-02-07	DC	Futures	25.28	25.44	25.04	25.18	330.0
2018-02-07	DX	Futures	84.04	84.777	83.885	84.63	33064.0
2018-02-07	E1	Futures	1.30035	1.30351	1.28772	1.29149	31140.0
2018-02-07	E6	Futures	1.407	1.40994	1.39163	1.39504	276130.0
2018-02-07	E7	Futures	1.4003	1.4027	1.3846	1.3881	5194.0
2018-02-07	EBM	Futures	171.54	173.43	171.54	172.89	30989.0
2018-02-07	ED	Futures	95.2776	95.2873	95.2388	95.2485	517035.0
2018-02-07	ER	Futures	98.332	98.337	98.332	98.337	63790.0
2018-02-07	EW	Futures	1971.7	1992.3	1951.7	1975.3	30502.0
2018-02-07	FBON	Futures	126.68	127.39	126.65	126.96	354.0
2018-02-07	FBTP	Futures	111.2	112.23	111.18	111.83	152567.0
2018-02-07	FBTS	Futures	103.64	103.768	103.64	103.732	84450.0
2018-02-07	FCE	Futures	4648.5	4695.4	4606.6	4684.2	170244.0
2018-02-07	FDAX	Futures	12996.4	13117.8	12869.3	13054.5	119817.0
2018-02-07	FDXM	Futures	13021.6	13140.1	12890.7	13076.7	69797.0
2018-02-07	FESX	Futures	2802.0	2829.0	2775.9	2820.0	1870118.0
2018-02-07	FGBL	Futures	147.06	147.29	146.36	146.65	929406.0
2018-02-07	FGBM	Futures	128.47	128.55	128.13	128.28	702216.0
2018-02-07	FGBS	Futures	112.271	112.296	112.206	112.251	326669.0
2018-02-07	FGBX	Futures	165.43	165.92	164.05	164.57	64008.0
2018-02-07	FMWO	Futures	6901.3	7009.9	6882.6	6997.0	3150.0
2018-02-07	FOAT	Futures	136.05	136.44	135.82	135.94	131944.0
2018-02-07	FTDX	Futures	2493.5	2558.8	2491.5	2547.8	276.0
2018-02-07	FTI	Futures	493.8	498.21	490.36	496.87	50007.0
2018-02-07	FTUK	Futures	6272.8	6334.8	6203.3	6308.6	225827.0
2018-02-07	FVSA	Futures	384.55	399.18	335.52	343.26	51926.0
2018-02-07	FXXP	Futures	319.1	324.1	317.8	323.3	59776.0
2018-02-07	G	Futures	112.31	112.48	112.02	112.21	201309.0
2018-02-07	GF	Futures	326.705	328.791	325.278	325.662	6119.0
2018-02-07	GSCI	Futures	517.11	517.23	506.26	507.87	2333.0
2018-02-07	HE	Futures	90.784	90.944	88.44	88.89	29101.0

> showing 50 of 111 rows — these rows as CSV

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