PREVIEW / futures_daily / 2017-10-13

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-13.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-10-13	ES	Futures	2771.44	2779.6	2770.36	2776.61	918541.0
2017-10-13	NQ	Futures	7133.42	7169.83	7128.13	7164.84	178530.0
2017-10-13	YM	Futures	24061.9	24131.6	24054.5	24108.4	74008.0
2017-10-13	CL	Futures	51.41	52.41	51.37	52.13	667497.0
2017-10-13	GC	Futures	1649.0	1662.3	1645.1	1660.0	297569.0
2017-10-13	ZN	Futures	123.640008	124.025131	123.547578	123.932702	1465750.0
2017-10-13	A6	Futures	0.8042	0.81192	0.80389	0.81047	112404.0
2017-10-13	AD	Futures	0.81559	0.81747	0.81295	0.81564	65562.0
2017-10-13	B	Futures	39.86	40.66	39.79	40.37	332597.0
2017-10-13	B6	Futures	1.3852	1.3932	1.3838	1.3885	140802.0
2017-10-13	BR	Futures	0.23766	0.23796	0.23766	0.23796	24.0
2017-10-13	BZ	Futures	39.55	40.32	39.49	40.04	23433.0
2017-10-13	C	Futures	1544.0	1548.0	1519.0	1532.0	8241.0
2017-10-13	CB	Futures	301.706	304.288	301.076	304.288	22.0
2017-10-13	CC	Futures	1569.0	1571.0	1533.0	1550.0	19495.0
2017-10-13	CNH	Futures	6.7731	6.7748	6.7635	6.7635	23.0
2017-10-13	CSC	Futures	3.435	3.437	3.435	3.435	10.0
2017-10-13	CT	Futures	79.57	80.97	79.48	80.6	10971.0
2017-10-13	DC	Futures	27.87	27.93	27.84	27.91	51.0
2017-10-13	DX	Futures	86.904	87.054	86.586	86.909	21579.0
2017-10-13	E1	Futures	1.25854	1.26502	1.25634	1.26013	24150.0
2017-10-13	E6	Futures	1.35475	1.35954	1.35156	1.35304	221071.0
2017-10-13	E7	Futures	1.3475	1.3525	1.3445	1.346	3842.0
2017-10-13	EBM	Futures	174.24	175.32	173.16	174.78	13100.0
2017-10-13	ED	Futures	95.4939	95.5133	95.4891	95.5085	637083.0
2017-10-13	ER	Futures	98.337	98.342	98.337	98.342	23818.0
2017-10-13	EW	Futures	1933.7	1941.4	1932.2	1932.8	7310.0
2017-10-13	FBON	Futures	124.84	125.1	124.72	125.03	570.0
2017-10-13	FBTP	Futures	109.37	110.08	109.36	110.0	93188.0
2017-10-13	FBTS	Futures	103.283	103.347	103.283	103.338	41722.0
2017-10-13	FCE	Futures	4807.8	4810.0	4788.5	4792.5	1432.0
2017-10-13	FDAX	Futures	13657.0	13696.4	13616.0	13653.9	64623.0
2017-10-13	FDXM	Futures	13537.6	13581.4	13501.1	13538.6	17442.0
2017-10-13	FESX	Futures	2939.3	2945.0	2928.7	2936.8	638452.0
2017-10-13	FEU3	Futures	99.011	99.011	99.006	99.006	8.0
2017-10-13	FGBL	Futures	149.31	149.93	149.25	149.81	720149.0
2017-10-13	FGBM	Futures	129.67	129.9	129.64	129.86	481296.0
2017-10-13	FGBS	Futures	112.442	112.487	112.432	112.477	225115.0
2017-10-13	FGBX	Futures	167.18	168.4	167.07	167.99	42787.0
2017-10-13	FMWO	Futures	6742.7	6759.2	6736.8	6753.3	2141.0
2017-10-13	FOAT	Futures	136.68	137.27	136.63	137.22	108662.0
2017-10-13	FTDX	Futures	2516.4	2527.9	2514.9	2524.9	139.0
2017-10-13	FTI	Futures	501.81	505.2	501.68	504.32	429.0
2017-10-13	FTUK	Futures	6508.5	6528.9	6498.5	6525.0	72937.0
2017-10-13	FVSA	Futures	370.9	373.46	360.67	367.06	18929.0
2017-10-13	FXXP	Futures	331.5	332.4	331.2	332.1	40930.0
2017-10-13	G	Futures	113.32	113.59	113.0	113.41	203590.0
2017-10-13	GF	Futures	333.245	334.538	330.012	334.053	5961.0
2017-10-13	GSCI	Futures	473.51	475.22	472.16	474.33	274.0
2017-10-13	HE	Futures	91.177	92.137	90.845	91.842	11498.0

> showing 50 of 109 rows — these rows as CSV

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