PREVIEW / futures_daily / 2018-05-29

all futures daily files

  file:    by_date/futures_daily/2018/2018-05-29.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-05-29	ES	Futures	2967.7	2970.69	2908.98	2927.74	1989677.0
2018-05-29	NQ	Futures	8180.16	8201.23	8064.87	8128.07	487638.0
2018-05-29	YM	Futures	26150.7	26166.5	25520.7	25678.8	351107.0
2018-05-29	CL	Futures	67.99	67.99	66.23	67.16	1059750.0
2018-05-29	GC	Futures	1667.0	1674.1	1655.3	1664.9	362211.0
2018-05-29	ZN	Futures	118.935316	120.393123	118.78023	120.331089	5473546.0
2018-05-29	A6	Futures	0.77735	0.77951	0.77108	0.77139	152428.0
2018-05-29	AD	Futures	0.78024	0.7805	0.77574	0.77721	118407.0
2018-05-29	B	Futures	55.52	55.82	54.67	55.28	295903.0
2018-05-29	B6	Futures	1.3795	1.3829	1.3686	1.3731	211876.0
2018-05-29	BR	Futures	0.20456	0.20456	0.20132	0.20132	198.0
2018-05-29	BTC	Futures	10466.6	10772.2	10019.0	10651.4	5052.0
2018-05-29	BZ	Futures	55.12	55.28	54.09	54.76	36753.0
2018-05-29	C	Futures	1677.0	1688.0	1647.0	1651.0	9772.0
2018-05-29	CB	Futures	302.206	302.206	302.206	302.206	3.0
2018-05-29	CC	Futures	1855.0	1888.0	1814.0	1820.0	28103.0
2018-05-29	CNH	Futures	6.4794	6.5257	6.4793	6.5234	220.0
2018-05-29	CSC	Futures	3.498	3.504	3.498	3.504	10.0
2018-05-29	CT	Futures	101.96	105.96	101.82	105.96	13547.0
2018-05-29	DC	Futures	28.31	28.43	28.23	28.41	158.0
2018-05-29	DX	Futures	88.98	89.574	88.876	89.399	35738.0
2018-05-29	E1	Futures	1.21622	1.22465	1.20827	1.22104	62297.0
2018-05-29	E6	Futures	1.31855	1.32317	1.29845	1.30092	731721.0
2018-05-29	E7	Futures	1.3114	1.316	1.2916	1.294	13458.0
2018-05-29	EBM	Futures	194.85	195.9	192.76	194.33	22205.0
2018-05-29	ED	Futures	95.0035	95.023	94.9913	95.0205	492543.0
2018-05-29	ER	Futures	98.323	98.328	98.303	98.323	223255.0
2018-05-29	EW	Futures	2066.6	2069.9	2040.3	2053.8	16742.0
2018-05-29	FBON	Futures	126.59	126.93	124.97	126.04	1498.0
2018-05-29	FBTP	Futures	107.58	107.58	100.05	103.33	283385.0
2018-05-29	FBTS	Futures	102.04	102.096	98.083	99.035	193204.0
2018-05-29	FCE	Futures	4913.4	4914.8	4803.3	4849.6	178655.0
2018-05-29	FDAX	Futures	13351.8	13360.1	13063.4	13160.6	142475.0
2018-05-29	FDIV	Futures	152.32	152.32	152.18	152.18	3.0
2018-05-29	FDXM	Futures	13231.3	13240.6	12947.1	13043.4	72500.0
2018-05-29	FESX	Futures	2886.4	2888.9	2815.6	2842.3	2051486.0
2018-05-29	FEU3	Futures	99.016	99.016	99.011	99.011	198.0
2018-05-29	FGBL	Futures	152.32	154.47	152.25	153.2	1725413.0
2018-05-29	FGBM	Futures	131.05	131.94	131.01	131.52	942581.0
2018-05-29	FGBS	Futures	112.774	113.065	112.774	112.94	1084244.0
2018-05-29	FGBX	Futures	175.38	180.53	174.73	176.97	111931.0
2018-05-29	FMWO	Futures	6976.0	6976.0	6879.1	6935.1	1757.0
2018-05-29	FOAT	Futures	139.84	140.51	139.59	140.37	338780.0
2018-05-29	FTDX	Futures	2790.3	2818.0	2733.9	2748.3	567.0
2018-05-29	FTI	Futures	516.67	517.27	507.75	511.91	50980.0
2018-05-29	FTUK	Futures	6798.6	6798.6	6693.4	6733.2	145200.0
2018-05-29	FVSA	Futures	341.53	398.45	341.53	375.9	71074.0
2018-05-29	FXXP	Futures	335.2	335.2	329.3	331.4	114552.0
2018-05-29	G	Futures	115.44	116.97	115.22	115.76	389662.0
2018-05-29	GF	Futures	300.378	301.621	298.41	300.326	6642.0

> showing 50 of 115 rows — these rows as CSV

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