PREVIEW / futures_daily / 2017-09-08

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-08.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
2017-09-08	ES	Futures	2680.65	2681.73	2670.05	2676.3	1242750.0
2017-09-08	NQ	Futures	7017.1	7020.33	6944.51	6954.8	190958.0
2017-09-08	YM	Futures	23045.0	23091.5	22953.0	23057.6	103108.0
2017-09-08	CL	Futures	50.38	50.56	48.51	48.73	843760.0
2017-09-08	GC	Futures	1722.8	1733.5	1714.1	1719.3	386646.0
2017-09-08	ZN	Futures	125.842914	126.089393	125.596435	125.704269	1416654.0
2017-09-08	A6	Futures	0.82622	0.83464	0.82612	0.82807	117456.0
2017-09-08	AD	Futures	0.83838	0.84321	0.83604	0.83752	103688.0
2017-09-08	ALI	Futures	2715.9	2715.9	2715.9	2715.9	0.0
2017-09-08	B	Futures	38.25	38.48	37.57	37.71	307449.0
2017-09-08	B6	Futures	1.3692	1.3823	1.3688	1.3798	139268.0
2017-09-08	BR	Futures	0.24128	0.24215	0.24128	0.24158	326.0
2017-09-08	BZ	Futures	37.92	38.14	37.24	37.39	28912.0
2017-09-08	C	Futures	1438.0	1448.0	1428.0	1447.0	1856.0
2017-09-08	CB	Futures	308.981	308.981	306.524	306.524	10.0
2017-09-08	CC	Futures	1414.0	1443.0	1406.0	1435.0	18505.0
2017-09-08	CNH	Futures	6.7	6.7252	6.66	6.7183	64.0
2017-09-08	CSC	Futures	3.387	3.387	3.387	3.387	28.0
2017-09-08	CT	Futures	87.76	88.87	87.75	88.22	23.0
2017-09-08	DC	Futures	27.93	27.93	27.68	27.73	104.0
2017-09-08	DX	Futures	85.384	85.43	84.963	85.277	36101.0
2017-09-08	E1	Futures	1.29249	1.30428	1.29237	1.30023	35773.0
2017-09-08	E6	Futures	1.37774	1.38605	1.37711	1.3786	239632.0
2017-09-08	E7	Futures	1.3702	1.3786	1.3699	1.3714	5082.0
2017-09-08	EBM	Futures	173.16	173.16	171.54	172.08	13333.0
2017-09-08	ED	Futures	95.6104	95.625	95.608	95.6201	403910.0
2017-09-08	ER	Futures	98.342	98.347	98.337	98.342	47598.0
2017-09-08	EW	Futures	1821.7	1828.5	1813.2	1825.0	29570.0
2017-09-08	FBON	Futures	126.04	126.04	125.0	125.26	683.0
2017-09-08	FBTP	Futures	110.93	111.02	109.89	110.11	118966.0
2017-09-08	FBTS	Futures	103.338	103.356	103.237	103.283	62995.0
2017-09-08	FCE	Futures	4564.2	4579.4	4550.3	4575.4	70051.0
2017-09-08	FDAX	Futures	12908.2	12975.6	12890.3	12952.4	79654.0
2017-09-08	FDXM	Futures	12833.5	12895.2	12811.5	12872.7	25058.0
2017-09-08	FESX	Futures	2806.3	2818.5	2801.4	2813.6	1073851.0
2017-09-08	FEU3	Futures	99.011	99.016	99.011	99.016	600.0
2017-09-08	FGBL	Futures	151.08	151.11	150.55	150.68	625446.0
2017-09-08	FGBM	Futures	130.28	130.3	130.07	130.15	373140.0
2017-09-08	FGBS	Futures	112.557	112.562	112.507	112.532	191116.0
2017-09-08	FGBX	Futures	171.79	171.95	170.4	170.71	45222.0
2017-09-08	FMWO	Futures	6561.5	6574.6	6559.1	6573.4	1607.0
2017-09-08	FOAT	Futures	137.77	137.84	137.35	137.54	113829.0
2017-09-08	FTDX	Futures	2345.3	2345.3	2325.2	2334.8	400.0
2017-09-08	FTI	Futures	478.99	481.07	478.34	480.42	21079.0
2017-09-08	FTUK	Futures	6392.1	6392.1	6358.0	6377.0	221950.0
2017-09-08	FVSA	Futures	497.52	510.11	491.22	492.8	14333.0
2017-09-08	FXXP	Futures	318.3	319.9	318.1	319.8	29622.0
2017-09-08	G	Futures	117.28	117.38	116.8	116.89	175199.0
2017-09-08	GF	Futures	320.046	325.253	319.663	324.212	2203.0
2017-09-08	GSCI	Futures	465.16	465.16	462.82	463.3	2092.0

> showing 50 of 111 rows — these rows as CSV

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