PREVIEW / futures_daily / 2018-05-21

all futures daily files

  file:    by_date/futures_daily/2018/2018-05-21.parquet
  size:    9 KB
  rows:    107

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-21	ES	Futures	2967.43	2978.85	2962.53	2972.05	951913.0
2018-05-21	NQ	Futures	8098.23	8142.7	8054.34	8094.42	293370.0
2018-05-21	YM	Futures	26181.2	26419.3	26181.2	26337.1	162324.0
2018-05-21	CL	Futures	71.97	73.15	71.78	72.82	579265.0
2018-05-21	GC	Futures	1647.3	1650.4	1635.7	1648.1	328016.0
2018-05-21	ZN	Futures	117.834207	118.051327	117.772173	117.958276	1495659.0
2018-05-21	A6	Futures	0.77417	0.78023	0.7716	0.77848	119322.0
2018-05-21	AD	Futures	0.78632	0.79193	0.78525	0.79036	54405.0
2018-05-21	B	Futures	57.61	58.33	57.23	58.05	245772.0
2018-05-21	B6	Futures	1.3971	1.3981	1.3885	1.3909	104119.0
2018-05-21	BR	Futures	0.20365	0.20711	0.20365	0.20635	2605.0
2018-05-21	BTC	Futures	11971.5	12189.2	11683.6	11760.9	2701.0
2018-05-21	BZ	Futures	56.96	57.73	56.66	57.46	19520.0
2018-05-21	C	Futures	1705.0	1716.0	1693.0	1695.0	6283.0
2018-05-21	CB	Futures	303.299	303.299	302.682	302.836	21.0
2018-05-21	CC	Futures	1936.0	1963.0	1902.0	1906.0	19946.0
2018-05-21	CNH	Futures	6.4679	6.4798	6.4525	6.4525	122.0
2018-05-21	CSC	Futures	3.524	3.532	3.513	3.519	37.0
2018-05-21	CT	Futures	99.24	100.86	99.01	100.51	25290.0
2018-05-21	DC	Futures	28.21	28.53	28.21	28.46	228.0
2018-05-21	DX	Futures	88.263	88.621	88.107	88.259	22278.0
2018-05-21	E1	Futures	1.20984	1.2108	1.20695	1.20984	17968.0
2018-05-21	E6	Futures	1.32807	1.33145	1.3225	1.32875	265071.0
2018-05-21	E7	Futures	1.3213	1.3242	1.3154	1.3216	3596.0
2018-05-21	EBM	Futures	185.7	186.22	183.6	184.39	12118.0
2018-05-21	ED	Futures	95.0011	95.0011	94.9816	94.9841	173669.0
2018-05-21	ER	Futures	98.337	98.337	98.332	98.332	42127.0
2018-05-21	EW	Futures	2068.0	2080.8	2065.2	2079.1	12806.0
2018-05-21	FBON	Futures	127.83	127.83	126.89	127.06	961.0
2018-05-21	FBTP	Futures	111.09	111.4	109.61	110.02	194513.0
2018-05-21	FBTS	Futures	103.732	103.732	103.316	103.353	182610.0
2018-05-21	FCE	Futures	5006.9	5029.8	5000.6	5011.8	41718.0
2018-05-21	FESX	Futures	2963.9	2978.9	2958.0	2961.4	472331.0
2018-05-21	FGBL	Futures	149.29	150.1	149.26	149.85	804418.0
2018-05-21	FGBM	Futures	129.65	129.98	129.63	129.88	541156.0
2018-05-21	FGBS	Futures	112.547	112.618	112.537	112.593	427052.0
2018-05-21	FGBX	Futures	168.4	170.43	168.26	169.6	67068.0
2018-05-21	FMWO	Futures	7081.1	7098.6	7078.7	7085.7	158.0
2018-05-21	FOAT	Futures	138.09	138.5	138.0	138.13	180816.0
2018-05-21	FTI	Futures	524.02	526.28	523.33	525.36	22302.0
2018-05-21	FTUK	Futures	6862.2	6941.3	6862.2	6933.3	105643.0
2018-05-21	FVSA	Futures	307.16	310.38	300.72	308.24	18901.0
2018-05-21	FXXP	Futures	340.4	342.2	340.4	341.4	20593.0
2018-05-21	G	Futures	113.24	113.48	113.11	113.29	195195.0
2018-05-21	GF	Futures	287.638	292.402	287.43	291.056	7432.0
2018-05-21	GSCI	Futures	550.66	554.64	550.49	553.86	35.0
2018-05-21	HE	Futures	79.011	79.169	76.673	77.75	15514.0
2018-05-21	HG	Futures	3.6107	3.6655	3.6107	3.6502	89593.0
2018-05-21	HH	Futures	18.235	18.325	18.08	18.106	11090.0
2018-05-21	HO	Futures	1.4967	1.5098	1.4887	1.5047	14801.0

> showing 50 of 107 rows — these rows as CSV

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