PREVIEW / futures_daily / 2017-05-18

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-18.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-05-18	ES	Futures	2557.63	2579.35	2546.23	2566.86	2460956.0
2017-05-18	NQ	Futures	6566.77	6652.74	6537.32	6631.54	522258.0
2017-05-18	YM	Futures	21700.6	21884.2	21603.5	21782.9	284802.0
2017-05-18	CL	Futures	51.01	51.72	50.11	51.44	601366.0
2017-05-18	GC	Futures	1613.1	1617.7	1593.0	1602.1	368898.0
2017-05-18	ZN	Futures	124.319901	124.596441	124.043362	124.166268	2330748.0
2017-05-18	A6	Futures	0.76295	0.76613	0.76007	0.76079	133857.0
2017-05-18	AD	Futures	0.7509	0.75121	0.74636	0.74912	81879.0
2017-05-18	ALI	Futures	2553.78	2553.78	2553.78	2553.78	0.0
2017-05-18	B	Futures	37.43	37.82	36.65	37.66	363694.0
2017-05-18	B6	Futures	1.3615	1.369	1.3522	1.3578	166294.0
2017-05-18	BFX	Futures	4714.6	4763.1	4697.0	4697.0	9.0
2017-05-18	BR	Futures	0.22894	0.22894	0.21133	0.21615	12935.0
2017-05-18	BZ	Futures	37.1	37.55	36.39	37.39	41239.0
2017-05-18	C	Futures	1605.0	1626.0	1596.0	1624.0	9065.0
2017-05-18	CB	Futures	297.577	297.729	295.99	295.99	3.0
2017-05-18	CC	Futures	1580.0	1596.0	1567.0	1593.0	20043.0
2017-05-18	CNH	Futures	7.1867	7.1927	7.1857	7.1865	21.0
2017-05-18	CSC	Futures	3.625	3.634	3.594	3.598	133.0
2017-05-18	CT	Futures	89.0	89.3	87.31	87.76	17604.0
2017-05-18	DC	Futures	30.57	30.57	30.2	30.24	419.0
2017-05-18	DX	Futures	90.753	91.275	90.628	91.091	46222.0
2017-05-18	E1	Futures	1.26554	1.26838	1.25985	1.26319	48407.0
2017-05-18	E6	Futures	1.28813	1.28871	1.27759	1.28088	253933.0
2017-05-18	E7	Futures	1.2813	1.2821	1.2711	1.2743	5851.0
2017-05-18	EBM	Futures	184.56	185.11	184.28	184.56	7455.0
2017-05-18	ED	Futures	95.6317	95.6389	95.6026	95.6051	426322.0
2017-05-18	ER	Futures	98.337	98.342	98.337	98.337	57710.0
2017-05-18	EW	Futures	1797.9	1809.1	1786.7	1799.7	21933.0
2017-05-18	FBON	Futures	123.2	123.71	123.05	123.33	1488.0
2017-05-18	FBTP	Futures	107.08	107.36	106.86	106.98	129157.0
2017-05-18	FBTS	Futures	102.562	102.589	102.471	102.507	54597.0
2017-05-18	FCE	Futures	4704.3	4736.7	4660.3	4707.0	113406.0
2017-05-18	FDAX	Futures	13265.0	13345.7	13187.4	13292.9	117418.0
2017-05-18	FDIV	Futures	149.51	150.57	149.51	150.57	55.0
2017-05-18	FDXM	Futures	13151.6	13228.0	13072.0	13176.2	42729.0
2017-05-18	FESX	Futures	2892.0	2910.0	2862.6	2890.4	1581997.0
2017-05-18	FGBL	Futures	148.2	148.9	148.06	148.45	1011128.0
2017-05-18	FGBM	Futures	129.32	129.5	129.22	129.34	692781.0
2017-05-18	FGBS	Futures	112.262	112.287	112.237	112.262	400264.0
2017-05-18	FGBX	Futures	166.43	168.21	166.01	166.87	61298.0
2017-05-18	FMWO	Futures	6330.2	6330.2	6276.0	6326.6	2111.0
2017-05-18	FOAT	Futures	134.5	135.0	134.32	134.69	161264.0
2017-05-18	FTDX	Futures	2135.7	2161.2	2123.4	2150.4	281.0
2017-05-18	FTI	Futures	480.66	484.69	475.8	480.52	20938.0
2017-05-18	FTUK	Futures	6359.2	6391.3	6309.2	6349.4	152607.0
2017-05-18	FVSA	Futures	555.3	607.78	548.53	575.62	52093.0
2017-05-18	FXXP	Futures	328.1	328.5	324.7	327.3	38209.0
2017-05-18	G	Futures	115.88	116.38	115.87	115.99	179246.0
2017-05-18	GF	Futures	321.595	328.894	321.595	327.851	7103.0

> showing 50 of 111 rows — these rows as CSV

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