PREVIEW / futures_daily / 2017-12-11

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-11.parquet
  size:    9 KB
  rows:    109

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-12-11	ES	Futures	2884.56	2898.43	2881.57	2894.9	1266601.0
2017-12-11	NQ	Futures	7450.56	7528.97	7446.74	7514.58	148290.0
2017-12-11	YM	Futures	25679.7	25790.4	25666.0	25752.4	107631.0
2017-12-11	CL	Futures	57.31	58.14	56.97	58.05	606724.0
2017-12-11	GC	Futures	1583.7	1589.0	1575.1	1580.8	194377.0
2017-12-11	ZN	Futures	122.684796	122.962468	122.638517	122.684796	846864.0
2017-12-11	A6	Futures	0.7722	0.7757	0.77179	0.77436	20355.0
2017-12-11	AD	Futures	0.79087	0.79249	0.79021	0.79127	20664.0
2017-12-11	B	Futures	44.96	46.13	44.75	45.96	488007.0
2017-12-11	B6	Futures	1.3972	1.4022	1.3916	1.3925	39786.0
2017-12-11	BZ	Futures	44.66	45.77	44.41	45.61	44515.0
2017-12-11	C	Futures	1307.0	1337.0	1301.0	1307.0	20951.0
2017-12-11	CB	Futures	279.548	279.826	279.239	279.517	10.0
2017-12-11	CC	Futures	1421.0	1457.0	1418.0	1427.0	22327.0
2017-12-11	CNH	Futures	6.7963	6.7963	6.791	6.7923	15.0
2017-12-11	CSC	Futures	3.387	3.393	3.349	3.376	26.0
2017-12-11	CT	Futures	86.1	86.23	85.03	85.26	16646.0
2017-12-11	DC	Futures	26.94	26.94	26.57	26.66	37.0
2017-12-11	DX	Futures	87.787	87.886	87.566	87.778	15594.0
2017-12-11	E1	Futures	1.23225	1.23601	1.23201	1.23407	13034.0
2017-12-11	E6	Futures	1.34323	1.34788	1.34255	1.34504	81583.0
2017-12-11	E7	Futures	1.3362	1.3412	1.3359	1.3383	809.0
2017-12-11	EBM	Futures	173.16	173.7	172.62	173.43	20046.0
2017-12-11	ED	Futures	95.4087	95.4136	95.3942	95.399	208344.0
2017-12-11	ER	Futures	98.337	98.337	98.332	98.332	61699.0
2017-12-11	EW	Futures	2009.0	2012.5	2004.1	2007.5	42202.0
2017-12-11	FBON	Futures	127.16	127.2	126.92	127.03	148.0
2017-12-11	FBTP	Futures	114.6	114.75	114.5	114.63	54301.0
2017-12-11	FBTS	Futures	104.006	104.025	103.988	103.997	32336.0
2017-12-11	FCE	Futures	4854.4	4856.6	4823.5	4827.9	153235.0
2017-12-11	FDAX	Futures	13862.0	13878.3	13780.5	13791.0	97044.0
2017-12-11	FDXM	Futures	13721.0	13721.0	13623.3	13631.6	1022.0
2017-12-11	FESX	Futures	2931.9	2933.6	2911.5	2914.8	1289173.0
2017-12-11	FEU3	Futures	99.011	99.011	99.006	99.006	9.0
2017-12-11	FGBL	Futures	151.5	151.79	151.41	151.66	442503.0
2017-12-11	FGBM	Futures	130.33	130.37	130.26	130.29	330430.0
2017-12-11	FGBS	Futures	112.582	112.592	112.557	112.567	256634.0
2017-12-11	FGBX	Futures	172.24	173.11	172.16	172.9	46329.0
2017-12-11	FMWO	Futures	6918.7	6918.7	6906.8	6916.3	10161.0
2017-12-11	FOAT	Futures	140.07	140.3	139.97	140.24	61757.0
2017-12-11	FTDX	Futures	2512.9	2512.9	2494.5	2498.0	78.0
2017-12-11	FTI	Futures	508.11	509.09	506.4	507.56	9938.0
2017-12-11	FTUK	Futures	6418.2	6469.3	6418.2	6454.5	270440.0
2017-12-11	FVSA	Futures	295.79	302.84	291.1	298.14	16873.0
2017-12-11	FXXP	Futures	331.2	331.2	329.8	329.8	146531.0
2017-12-11	G	Futures	114.57	115.35	114.53	115.26	196279.0
2017-12-11	GF	Futures	314.247	316.247	312.301	314.463	6216.0
2017-12-11	GSCI	Futures	489.95	492.22	489.14	492.22	3033.0
2017-12-11	HE	Futures	91.709	92.209	89.275	89.408	20706.0
2017-12-11	HG	Futures	3.569	3.6139	3.5475	3.6049	107982.0

> showing 50 of 109 rows — these rows as CSV

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