PREVIEW / futures_daily / 2017-10-12

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-12.parquet
  size:    9 KB
  rows:    105

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-10-12	ES	Futures	2776.07	2777.15	2769.54	2773.08	938476.0
2017-10-12	NQ	Futures	7145.75	7161.61	7125.78	7135.47	200082.0
2017-10-12	YM	Futures	24090.4	24113.6	24045.0	24074.6	70452.0
2017-10-12	CL	Futures	51.68	51.81	50.82	51.27	729273.0
2017-10-12	GC	Futures	1647.3	1653.9	1643.7	1649.7	246084.0
2017-10-12	ZN	Futures	123.424339	123.670818	123.393529	123.624603	1120475.0
2017-10-12	A6	Futures	0.8007	0.80554	0.8007	0.80482	83554.0
2017-10-12	AD	Futures	0.81712	0.81869	0.81488	0.81691	64389.0
2017-10-12	B	Futures	40.07	40.13	39.46	39.73	339530.0
2017-10-12	B6	Futures	1.3814	1.3883	1.3707	1.3866	163726.0
2017-10-12	BZ	Futures	39.69	39.8	39.14	39.4	22286.0
2017-10-12	C	Futures	1556.0	1567.0	1537.0	1546.0	12799.0
2017-10-12	CB	Futures	300.73	300.73	299.816	300.131	20.0
2017-10-12	CC	Futures	1574.0	1575.0	1542.0	1552.0	23900.0
2017-10-12	CNH	Futures	6.7766	6.7828	6.7732	6.7732	12.0
2017-10-12	CSC	Futures	3.447	3.464	3.423	3.437	48.0
2017-10-12	CT	Futures	80.85	81.17	79.47	79.68	17355.0
2017-10-12	DC	Futures	27.91	28.05	27.75	27.87	114.0
2017-10-12	DX	Futures	86.741	87.031	86.629	86.874	17435.0
2017-10-12	E1	Futures	1.26135	1.26416	1.25744	1.25854	20426.0
2017-10-12	E6	Futures	1.35795	1.36023	1.35412	1.35498	170802.0
2017-10-12	E7	Futures	1.3511	1.3531	1.3471	1.3479	2441.0
2017-10-12	EBM	Futures	174.51	174.78	173.16	174.51	15016.0
2017-10-12	ED	Futures	95.4891	95.4988	95.4891	95.4939	173093.0
2017-10-12	ER	Futures	98.342	98.342	98.337	98.342	35662.0
2017-10-12	EW	Futures	1932.8	1937.0	1927.4	1933.7	11801.0
2017-10-12	FBON	Futures	124.63	124.82	124.49	124.63	444.0
2017-10-12	FBTP	Futures	108.89	109.52	108.86	109.4	138803.0
2017-10-12	FBTS	Futures	103.255	103.301	103.246	103.283	67537.0
2017-10-12	FCE	Futures	4804.6	4806.9	4788.1	4800.6	510.0
2017-10-12	FDAX	Futures	13623.9	13658.6	13594.0	13642.8	53235.0
2017-10-12	FDXM	Futures	13511.5	13542.8	13479.2	13527.7	15198.0
2017-10-12	FESX	Futures	2937.6	2940.1	2925.4	2935.2	453945.0
2017-10-12	FGBL	Futures	149.1	149.39	149.01	149.28	586963.0
2017-10-12	FGBM	Futures	129.52	129.7	129.52	129.66	482681.0
2017-10-12	FGBS	Futures	112.407	112.447	112.407	112.437	192768.0
2017-10-12	FGBX	Futures	166.77	167.4	166.42	167.01	32852.0
2017-10-12	FMWO	Futures	6741.5	6741.5	6728.5	6735.6	314.0
2017-10-12	FOAT	Futures	136.42	136.7	136.35	136.6	94380.0
2017-10-12	FTDX	Futures	2518.4	2518.4	2505.5	2517.9	74.0
2017-10-12	FTI	Futures	501.35	502.09	501.21	501.21	494.0
2017-10-12	FTUK	Futures	6509.8	6536.7	6500.7	6528.4	77411.0
2017-10-12	FVSA	Futures	376.02	379.85	369.62	372.18	13753.0
2017-10-12	FXXP	Futures	330.9	331.6	329.9	330.7	19702.0
2017-10-12	G	Futures	113.4	113.49	113.14	113.3	161343.0
2017-10-12	GF	Futures	334.915	337.663	331.736	333.083	8134.0
2017-10-12	GSCI	Futures	467.15	469.62	467.15	469.62	2414.0
2017-10-12	HE	Futures	92.654	93.208	90.513	90.993	19906.0
2017-10-12	HG	Futures	3.7369	3.7882	3.7248	3.7689	94686.0
2017-10-12	HH	Futures	18.006	18.606	17.987	18.507	4665.0

> showing 50 of 105 rows — these rows as CSV

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