PREVIEW / futures_daily / 2018-07-17

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-17.parquet
  size:    10 KB
  rows:    115

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
2018-07-17	ES	Futures	3036.46	3058.18	3029.94	3053.29	1059163.0
2018-07-17	NQ	Futures	8534.4	8669.65	8502.34	8653.03	343273.0
2018-07-17	YM	Futures	26401.3	26490.9	26311.8	26454.0	139246.0
2018-07-17	CL	Futures	69.43	69.95	68.65	69.49	362131.0
2018-07-17	GC	Futures	1584.1	1589.6	1565.1	1566.9	318219.0
2018-07-17	ZN	Futures	119.525614	119.58777	119.370225	119.463458	818755.0
2018-07-17	A6	Futures	0.76295	0.76501	0.75863	0.75997	80526.0
2018-07-17	AD	Futures	0.77143	0.77325	0.76697	0.76859	55091.0
2018-07-17	B	Futures	53.12	53.69	52.63	53.23	286435.0
2018-07-17	B6	Futures	1.3692	1.3726	1.3517	1.3573	167259.0
2018-07-17	BFX	Futures	4391.3	4428.3	4391.3	4428.3	48.0
2018-07-17	BR	Futures	0.19633	0.19732	0.19534	0.19732	18.0
2018-07-17	BTC	Futures	9495.0	10641.8	9480.7	10406.7	5582.0
2018-07-17	BZ	Futures	52.75	53.4	52.35	52.94	28197.0
2018-07-17	C	Futures	1672.0	1683.0	1659.0	1662.0	15464.0
2018-07-17	CB	Futures	274.981	274.981	272.672	274.052	36.0
2018-07-17	CC	Futures	1712.0	1742.0	1692.0	1717.0	21835.0
2018-07-17	CNH	Futures	6.7694	6.8031	6.7694	6.7991	75.0
2018-07-17	CSC	Futures	3.236	3.266	3.218	3.23	74.0
2018-07-17	CT	Futures	99.49	100.25	98.68	100.09	30.0
2018-07-17	DC	Futures	25.95	26.08	25.58	25.75	427.0
2018-07-17	DX	Futures	89.302	89.837	89.065	89.694	18655.0
2018-07-17	E1	Futures	1.20528	1.20994	1.20086	1.20194	27702.0
2018-07-17	E6	Futures	1.31554	1.3194	1.3086	1.31028	193417.0
2018-07-17	E7	Futures	1.3091	1.3126	1.3022	1.3036	2657.0
2018-07-17	EBM	Futures	193.02	195.9	192.76	195.63	16904.0
2018-07-17	ED	Futures	94.9815	94.9864	94.9718	94.9815	209776.0
2018-07-17	ER	Futures	98.367	98.367	98.362	98.367	9210.0
2018-07-17	EW	Futures	2105.5	2118.5	2101.7	2114.8	10487.0
2018-07-17	FBON	Futures	129.41	129.86	129.41	129.84	454.0
2018-07-17	FBTP	Futures	108.92	109.97	108.87	109.88	62649.0
2018-07-17	FBTS	Futures	102.828	103.18	102.819	103.078	39194.0
2018-07-17	FCE	Futures	4847.7	4884.1	4826.7	4862.5	157624.0
2018-07-17	FDAX	Futures	13129.4	13300.3	13075.6	13238.1	90142.0
2018-07-17	FDXM	Futures	12960.6	13130.9	12908.0	13069.0	32245.0
2018-07-17	FESX	Futures	2873.9	2896.5	2858.1	2883.1	885720.0
2018-07-17	FGBL	Futures	153.2	153.5	153.19	153.45	365489.0
2018-07-17	FGBM	Futures	131.11	131.22	131.11	131.2	260727.0
2018-07-17	FGBS	Futures	112.688	112.708	112.688	112.708	173321.0
2018-07-17	FGBX	Futures	177.66	178.36	177.6	178.22	24999.0
2018-07-17	FMWO	Futures	7105.5	7133.5	7086.9	7118.4	1036.0
2018-07-17	FOAT	Futures	141.2	141.56	141.2	141.54	72231.0
2018-07-17	FTDX	Futures	2787.7	2801.9	2770.6	2797.0	181.0
2018-07-17	FTI	Futures	512.79	516.72	510.58	513.53	36549.0
2018-07-17	FTUK	Futures	6726.5	6790.2	6698.5	6747.0	80318.0
2018-07-17	FVSA	Futures	271.33	277.07	265.6	267.51	25754.0
2018-07-17	FXXP	Futures	331.0	333.3	329.8	332.1	32786.0
2018-07-17	G	Futures	115.53	115.78	115.46	115.7	115378.0
2018-07-17	GF	Futures	317.313	317.313	312.548	313.377	4982.0
2018-07-17	GSCI	Futures	508.6	509.61	507.41	509.27	128.0

> showing 50 of 115 rows — these rows as CSV

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