PREVIEW / futures_daily / 2018-05-22

all futures daily files

  file:    by_date/futures_daily/2018/2018-05-22.parquet
  size:    10 KB
  rows:    113

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-22	ES	Futures	2970.15	2981.57	2959.54	2964.44	891511.0
2018-05-22	NQ	Futures	8092.38	8140.07	8064.29	8086.82	269992.0
2018-05-22	YM	Futures	26331.9	26404.6	26129.6	26171.7	143053.0
2018-05-22	CL	Futures	73.09	73.37	72.29	72.67	723458.0
2018-05-22	GC	Futures	1649.9	1654.6	1643.3	1649.5	291716.0
2018-05-22	ZN	Futures	117.989293	118.066836	117.834207	117.989293	1541549.0
2018-05-22	A6	Futures	0.78003	0.78219	0.77807	0.7792	104304.0
2018-05-22	AD	Futures	0.79178	0.79446	0.78945	0.79011	78657.0
2018-05-22	B	Futures	58.16	58.99	58.01	58.31	305307.0
2018-05-22	B6	Futures	1.3925	1.3988	1.3907	1.3923	109937.0
2018-05-22	BR	Futures	0.20723	0.2097	0.20723	0.20948	3719.0
2018-05-22	BTC	Futures	11718.7	11824.1	11332.6	11487.0	2341.0
2018-05-22	BZ	Futures	57.66	58.38	57.42	57.71	29522.0
2018-05-22	C	Futures	1689.0	1725.0	1683.0	1690.0	8718.0
2018-05-22	CB	Futures	302.836	305.834	302.236	305.235	55.0
2018-05-22	CC	Futures	1904.0	1946.0	1877.0	1888.0	28787.0
2018-05-22	CNH	Futures	6.4562	6.4562	6.4427	6.4476	24.0
2018-05-22	CSC	Futures	3.536	3.538	3.494	3.503	23.0
2018-05-22	CT	Futures	100.72	102.17	98.48	99.3	22417.0
2018-05-22	DC	Futures	28.57	28.61	28.27	28.35	265.0
2018-05-22	DX	Futures	88.145	88.324	87.9	88.207	20943.0
2018-05-22	E1	Futures	1.21068	1.21694	1.20815	1.2155	27909.0
2018-05-22	E6	Futures	1.33106	1.33517	1.32695	1.32931	291627.0
2018-05-22	E7	Futures	1.324	1.3279	1.32	1.3222	3947.0
2018-05-22	EBM	Futures	184.91	188.05	184.65	187.27	34587.0
2018-05-22	ED	Futures	94.9841	94.9889	94.9792	94.9841	158812.0
2018-05-22	ER	Futures	98.332	98.337	98.332	98.332	28365.0
2018-05-22	EW	Futures	2078.6	2084.1	2063.3	2065.1	10581.0
2018-05-22	FBON	Futures	127.12	127.84	127.07	127.64	1072.0
2018-05-22	FBTP	Futures	110.05	110.91	110.03	110.5	232879.0
2018-05-22	FBTS	Futures	103.39	103.603	103.372	103.511	135262.0
2018-05-22	FCE	Futures	5019.0	5034.3	5005.1	5022.1	59354.0
2018-05-22	FDAX	Futures	13653.6	13722.2	13567.9	13709.7	86485.0
2018-05-22	FDXM	Futures	13530.0	13600.0	13446.6	13587.7	27090.0
2018-05-22	FESX	Futures	2964.7	2977.2	2957.2	2977.2	908802.0
2018-05-22	FGBL	Futures	149.98	150.03	149.38	149.53	958509.0
2018-05-22	FGBM	Futures	129.94	129.95	129.66	129.77	505600.0
2018-05-22	FGBS	Futures	112.613	112.623	112.553	112.568	486811.0
2018-05-22	FGBX	Futures	170.06	170.12	168.69	168.84	62600.0
2018-05-22	FMWO	Futures	7106.8	7111.4	7097.4	7109.1	1757.0
2018-05-22	FOAT	Futures	138.34	138.45	138.08	138.1	189951.0
2018-05-22	FTDX	Futures	2814.1	2818.0	2785.4	2791.8	319.0
2018-05-22	FTI	Futures	525.73	528.18	524.8	527.39	20529.0
2018-05-22	FTUK	Futures	6927.2	6967.8	6917.9	6962.5	140201.0
2018-05-22	FVSA	Futures	309.31	309.31	296.42	297.5	14792.0
2018-05-22	FXXP	Futures	341.0	342.8	340.9	342.7	25893.0
2018-05-22	G	Futures	113.18	113.33	112.88	113.0	210663.0
2018-05-22	GF	Futures	291.47	292.299	289.45	291.522	4158.0
2018-05-22	GSCI	Futures	556.77	557.11	554.14	554.87	103.0
2018-05-22	HE	Futures	77.094	77.304	76.227	76.831	12073.0

> showing 50 of 113 rows — these rows as CSV

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