PREVIEW / futures_daily / 2017-10-05

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-05.parquet
  size:    9 KB
  rows:    108

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-05	ES	Futures	2757.58	2774.44	2756.76	2773.62	1104438.0
2017-10-05	NQ	Futures	7053.54	7127.54	7048.84	7124.9	254723.0
2017-10-05	YM	Futures	23862.3	24017.5	23861.3	24013.3	71116.0
2017-10-05	CL	Futures	50.54	51.9	50.51	51.47	654385.0
2017-10-05	GC	Futures	1625.5	1630.7	1614.1	1620.0	221522.0
2017-10-05	ZN	Futures	123.609198	123.670818	123.331909	123.393529	990526.0
2017-10-05	A6	Futures	0.8078	0.80862	0.80049	0.8008	105710.0
2017-10-05	AD	Futures	0.81574	0.81681	0.80882	0.80964	72304.0
2017-10-05	B	Futures	39.39	40.42	39.34	40.25	379302.0
2017-10-05	B6	Futures	1.3836	1.3844	1.3695	1.3699	145367.0
2017-10-05	BR	Futures	0.23856	0.23909	0.23762	0.23762	11.0
2017-10-05	BZ	Futures	39.06	40.09	39.01	39.92	32050.0
2017-10-05	C	Futures	1528.0	1546.0	1522.0	1545.0	9923.0
2017-10-05	CB	Futures	301.485	301.643	299.627	301.107	22.0
2017-10-05	CC	Futures	1547.0	1553.0	1526.0	1547.0	21381.0
2017-10-05	CNH	Futures	6.8447	6.8534	6.8428	6.8534	11.0
2017-10-05	CSC	Futures	3.522	3.534	3.514	3.516	11.0
2017-10-05	CT	Futures	80.93	81.57	79.99	80.19	12607.0
2017-10-05	DC	Futures	28.85	28.97	28.72	28.85	73.0
2017-10-05	DX	Futures	87.311	87.751	87.204	87.721	18199.0
2017-10-05	E1	Futures	1.25939	1.26062	1.25365	1.25475	17486.0
2017-10-05	E6	Futures	1.34665	1.34905	1.33992	1.34066	198310.0
2017-10-05	E7	Futures	1.3396	1.342	1.3329	1.3337	3376.0
2017-10-05	EBM	Futures	179.09	179.63	178.55	179.09	17103.0
2017-10-05	ED	Futures	95.5036	95.5085	95.4891	95.4988	276514.0
2017-10-05	ER	Futures	98.337	98.342	98.337	98.337	20433.0
2017-10-05	EW	Futures	1928.8	1938.2	1928.6	1934.6	10870.0
2017-10-05	FBON	Futures	123.26	124.24	123.05	124.02	2255.0
2017-10-05	FBTP	Futures	108.08	108.8	107.77	108.61	144988.0
2017-10-05	FBTS	Futures	103.228	103.283	103.2	103.246	42044.0
2017-10-05	FCE	Futures	4805.1	4822.6	4794.8	4816.7	52924.0
2017-10-05	FDAX	Futures	13605.5	13641.2	13582.9	13615.5	52626.0
2017-10-05	FDXM	Futures	13484.4	13526.1	13467.8	13500.6	14353.0
2017-10-05	FESX	Futures	2924.6	2942.5	2918.1	2938.5	585158.0
2017-10-05	FEU3	Futures	99.011	99.011	99.006	99.006	206.0
2017-10-05	FGBL	Futures	149.1	149.48	148.91	149.07	759297.0
2017-10-05	FGBM	Futures	129.63	129.67	129.49	129.52	510602.0
2017-10-05	FGBS	Futures	112.437	112.442	112.407	112.417	286614.0
2017-10-05	FGBX	Futures	166.77	167.79	166.46	166.69	44014.0
2017-10-05	FMWO	Futures	6686.0	6704.9	6683.7	6694.3	609.0
2017-10-05	FOAT	Futures	136.07	136.63	135.95	136.29	193266.0
2017-10-05	FTDX	Futures	2492.0	2498.0	2474.0	2482.5	61.0
2017-10-05	FTI	Futures	498.71	500.78	498.16	500.0	19424.0
2017-10-05	FTUK	Futures	6450.8	6485.1	6443.4	6474.6	85675.0
2017-10-05	FVSA	Futures	390.2	391.62	374.6	376.02	15844.0
2017-10-05	FXXP	Futures	330.8	331.6	329.8	330.9	21144.0
2017-10-05	G	Futures	113.27	113.65	113.11	113.2	178203.0
2017-10-05	GF	Futures	332.942	335.288	332.506	335.179	1780.0
2017-10-05	GSCI	Futures	476.75	478.01	476.21	476.21	850.0
2017-10-05	HE	Futures	91.694	93.208	91.141	92.728	18955.0

> showing 50 of 108 rows — these rows as CSV

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