PREVIEW / futures_daily / 2018-05-31

all futures daily files

  file:    by_date/futures_daily/2018/2018-05-31.parquet
  size:    10 KB
  rows:    114

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-31	ES	Futures	2958.18	2966.88	2935.89	2942.14	1665452.0
2018-05-31	NQ	Futures	8167.87	8220.54	8144.17	8166.11	389141.0
2018-05-31	YM	Futures	25951.6	26024.3	25641.9	25720.9	249110.0
2018-05-31	CL	Futures	68.68	68.74	66.99	67.48	917563.0
2018-05-31	GC	Futures	1667.3	1674.4	1661.0	1665.7	315137.0
2018-05-31	ZN	Futures	119.633202	119.865831	119.369556	119.834814	347770.0
2018-05-31	A6	Futures	0.779	0.78075	0.77674	0.77807	110693.0
2018-05-31	AD	Futures	0.78596	0.7895	0.77913	0.78121	126910.0
2018-05-31	B	Futures	56.86	57.98	56.36	56.79	466495.0
2018-05-31	B6	Futures	1.3767	1.3833	1.376	1.3773	146676.0
2018-05-31	BR	Futures	0.20121	0.20418	0.20121	0.20289	89.0
2018-05-31	BTC	Futures	10424.0	10885.9	10424.0	10722.4	2102.0
2018-05-31	BZ	Futures	56.36	57.42	55.83	56.26	50812.0
2018-05-31	C	Futures	1651.0	1655.0	1608.0	1613.0	13185.0
2018-05-31	CB	Futures	300.018	300.018	299.958	299.958	4.0
2018-05-31	CC	Futures	1844.0	1847.0	1782.0	1789.0	41448.0
2018-05-31	CNH	Futures	6.4987	6.5067	6.4894	6.5045	96.0
2018-05-31	CSC	Futures	3.506	3.512	3.492	3.496	31.0
2018-05-31	CT	Futures	105.13	106.57	104.29	105.89	23262.0
2018-05-31	DC	Futures	28.38	28.41	28.31	28.34	68.0
2018-05-31	DX	Futures	88.702	88.857	88.362	88.616	32315.0
2018-05-31	E1	Futures	1.21887	1.22718	1.21887	1.22417	32714.0
2018-05-31	E6	Futures	1.31574	1.32233	1.31275	1.3181	411583.0
2018-05-31	E7	Futures	1.3086	1.315	1.3057	1.3111	10238.0
2018-05-31	EBM	Futures	187.79	192.5	187.79	191.19	18939.0
2018-05-31	ED	Futures	95.0084	95.0108	94.9768	94.9865	363982.0
2018-05-31	ER	Futures	98.332	98.337	98.328	98.332	116489.0
2018-05-31	EW	Futures	2084.3	2089.9	2059.2	2061.9	19796.0
2018-05-31	FBON	Futures	126.59	127.61	126.59	127.07	944.0
2018-05-31	FBTP	Futures	104.01	107.56	103.98	105.14	193053.0
2018-05-31	FBTS	Futures	100.348	102.438	100.274	101.338	149058.0
2018-05-31	FCE	Futures	4870.7	4883.3	4816.8	4833.0	112892.0
2018-05-31	FDAX	Futures	13277.5	13306.6	13030.2	13105.0	118591.0
2018-05-31	FDXM	Futures	13163.4	13188.1	12914.1	12988.3	45901.0
2018-05-31	FESX	Futures	2861.4	2873.1	2818.9	2838.1	1680632.0
2018-05-31	FEU3	Futures	99.011	99.021	99.011	99.016	319.0
2018-05-31	FGBL	Futures	152.21	152.67	151.46	152.58	1469295.0
2018-05-31	FGBM	Futures	130.85	131.12	130.61	131.07	1096275.0
2018-05-31	FGBS	Futures	112.718	112.809	112.693	112.789	899588.0
2018-05-31	FGBX	Futures	175.38	176.78	173.68	176.68	144211.0
2018-05-31	FMWO	Futures	7008.7	7008.7	6958.5	6973.6	815.0
2018-05-31	FOAT	Futures	140.01	140.34	139.55	140.29	262635.0
2018-05-31	FTDX	Futures	2770.5	2775.5	2748.3	2753.7	43.0
2018-05-31	FTI	Futures	515.05	516.35	509.83	510.34	39261.0
2018-05-31	FTUK	Futures	6796.4	6818.9	6749.1	6777.4	161836.0
2018-05-31	FVSA	Futures	360.86	376.97	344.75	360.86	46594.0
2018-05-31	FXXP	Futures	332.3	333.7	329.5	330.9	60525.0
2018-05-31	G	Futures	115.48	115.89	115.21	115.83	307755.0
2018-05-31	GF	Futures	307.784	309.7	302.087	305.35	12491.0
2018-05-31	GSCI	Futures	542.75	542.75	539.88	540.05	392.0

> showing 50 of 114 rows — these rows as CSV

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