PREVIEW / futures_daily / 2017-07-14

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-14.parquet
  size:    9 KB
  rows:    106

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-14	ES	Futures	2658.91	2674.94	2654.02	2669.24	1091078.0
2017-07-14	NQ	Futures	6817.55	6874.27	6803.74	6868.98	230871.0
2017-07-14	YM	Futures	22743.7	22863.1	22696.1	22828.3	101194.0
2017-07-14	CL	Futures	47.59	48.27	47.29	48.09	367342.0
2017-07-14	GC	Futures	1552.8	1573.6	1549.8	1567.0	267441.0
2017-07-14	ZN	Futures	123.519044	124.134639	123.442095	123.780672	1595405.0
2017-07-14	A6	Futures	0.79335	0.80413	0.79335	0.803	114802.0
2017-07-14	AD	Futures	0.79984	0.80512	0.79862	0.80462	83308.0
2017-07-14	ALI	Futures	2534.37	2534.37	2534.37	2534.37	0.0
2017-07-14	B	Futures	34.2	34.72	34.04	34.58	295663.0
2017-07-14	B6	Futures	1.3549	1.3733	1.3546	1.3705	130267.0
2017-07-14	BR	Futures	0.2292	0.23125	0.2292	0.23125	124.0
2017-07-14	BZ	Futures	34.0	34.48	33.83	34.36	22014.0
2017-07-14	C	Futures	1509.0	1529.0	1496.0	1521.0	6428.0
2017-07-14	CB	Futures	319.92	321.258	319.92	321.258	12.0
2017-07-14	CC	Futures	1433.0	1459.0	1421.0	1454.0	17716.0
2017-07-14	CSC	Futures	3.513	3.53	3.513	3.53	16.0
2017-07-14	CT	Futures	77.66	79.07	77.6	78.4	18.0
2017-07-14	DC	Futures	29.42	29.65	29.41	29.56	200.0
2017-07-14	DX	Futures	89.221	89.282	88.586	88.642	23335.0
2017-07-14	E1	Futures	1.27481	1.28046	1.271	1.27923	25403.0
2017-07-14	E6	Futures	1.31049	1.31868	1.30945	1.31805	204314.0
2017-07-14	E7	Futures	1.3035	1.3118	1.3027	1.3111	3083.0
2017-07-14	EBM	Futures	196.53	197.08	192.91	193.74	8924.0
2017-07-14	ED	Futures	95.5935	95.608	95.5886	95.5983	215012.0
2017-07-14	ER	Futures	98.337	98.337	98.332	98.332	37422.0
2017-07-14	EW	Futures	1867.3	1881.0	1864.6	1874.1	11387.0
2017-07-14	FBON	Futures	122.62	123.43	122.62	122.85	388.0
2017-07-14	FBTP	Futures	106.31	107.04	106.29	106.4	83491.0
2017-07-14	FBTS	Futures	102.653	102.699	102.653	102.663	29182.0
2017-07-14	FCE	Futures	4710.2	4711.5	4685.5	4698.9	943.0
2017-07-14	FDAX	Futures	13311.5	13328.3	13232.0	13278.3	59074.0
2017-07-14	FDXM	Futures	13226.9	13244.7	13151.6	13196.6	14859.0
2017-07-14	FESX	Futures	2878.1	2881.4	2861.0	2870.0	556450.0
2017-07-14	FGBL	Futures	146.58	146.94	146.31	146.39	513627.0
2017-07-14	FGBM	Futures	128.39	128.54	128.25	128.27	280625.0
2017-07-14	FGBS	Futures	112.131	112.167	112.106	112.111	157037.0
2017-07-14	FGBX	Futures	163.11	163.98	162.65	162.73	34755.0
2017-07-14	FMWO	Futures	6469.8	6501.9	6469.8	6488.8	1040.0
2017-07-14	FOAT	Futures	134.34	134.77	134.23	134.26	80038.0
2017-07-14	FTDX	Futures	2298.2	2302.7	2287.7	2298.2	136.0
2017-07-14	FTI	Futures	477.57	479.92	476.78	478.45	372.0
2017-07-14	FTUK	Futures	6357.6	6368.8	6305.7	6309.6	76568.0
2017-07-14	FVSA	Futures	474.65	477.61	464.26	471.68	21198.0
2017-07-14	FXXP	Futures	328.3	329.3	327.2	328.0	27653.0
2017-07-14	G	Futures	113.87	113.97	113.45	113.53	151292.0
2017-07-14	GF	Futures	335.918	339.815	333.284	338.662	6702.0
2017-07-14	GSCI	Futures	452.59	454.29	452.59	453.69	2177.0
2017-07-14	HE	Futures	94.852	94.852	91.463	91.779	30384.0
2017-07-14	HG	Futures	3.2423	3.2794	3.2393	3.2733	56420.0

> showing 50 of 106 rows — these rows as CSV

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