PREVIEW / futures_daily / 2018-02-23

all futures daily files

  file:    by_date/futures_daily/2018/2018-02-23.parquet
  size:    9 KB
  rows:    110

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-02-23	ES	Futures	2948.43	2989.19	2945.44	2987.56	1290261.0
2018-02-23	NQ	Futures	7955.24	8097.24	7943.82	8092.56	383733.0
2018-02-23	YM	Futures	26385.2	26707.9	26361.0	26696.3	203954.0
2018-02-23	CL	Futures	63.04	64.18	62.77	64.0	460597.0
2018-02-23	GC	Futures	1703.6	1704.2	1695.9	1699.2	167847.0
2018-02-23	ZN	Futures	118.843665	119.291025	118.720255	119.198468	2429261.0
2018-02-23	A6	Futures	0.80635	0.80707	0.80265	0.80594	75676.0
2018-02-23	AD	Futures	0.79924	0.80498	0.79802	0.80204	74074.0
2018-02-23	B	Futures	47.64	48.43	47.32	48.38	184365.0
2018-02-23	B6	Futures	1.4524	1.4578	1.4472	1.4542	100158.0
2018-02-23	BR	Futures	0.23309	0.23309	0.2329	0.2329	110.0
2018-02-23	BTC	Futures	12979.8	13480.8	12478.8	13428.0	299.0
2018-02-23	BZ	Futures	47.01	47.83	46.77	47.79	12578.0
2018-02-23	C	Futures	1377.0	1404.0	1376.0	1401.0	9456.0
2018-02-23	CB	Futures	284.583	285.416	284.583	285.169	20.0
2018-02-23	CC	Futures	1579.0	1618.0	1578.0	1610.0	24323.0
2018-02-23	CNH	Futures	6.4688	6.4751	6.4561	6.4561	75.0
2018-02-23	CSC	Futures	3.308	3.31	3.287	3.31	42.0
2018-02-23	CT	Futures	91.23	93.59	91.23	93.5	17338.0
2018-02-23	DC	Futures	26.13	26.24	26.12	26.15	41.0
2018-02-23	DX	Futures	84.242	84.51	84.228	84.339	16556.0
2018-02-23	E1	Futures	1.30302	1.30399	1.29719	1.29853	18529.0
2018-02-23	E6	Futures	1.39963	1.40053	1.39402	1.39594	161722.0
2018-02-23	E7	Futures	1.3928	1.3934	1.387	1.389	2791.0
2018-02-23	EBM	Futures	174.78	176.4	174.78	176.13	16220.0
2018-02-23	ED	Futures	95.1004	95.1125	95.0858	95.0979	392217.0
2018-02-23	ER	Futures	98.332	98.332	98.328	98.328	45860.0
2018-02-23	EW	Futures	1998.6	2020.8	1998.1	2019.2	12109.0
2018-02-23	FBON	Futures	125.97	126.11	125.77	126.04	328.0
2018-02-23	FBTP	Futures	110.62	111.03	110.47	110.98	123256.0
2018-02-23	FBTS	Futures	103.586	103.604	103.54	103.567	54045.0
2018-02-23	FCE	Futures	4697.3	4716.3	4673.0	4695.6	46575.0
2018-02-23	FDAX	Futures	12971.0	13017.2	12890.6	12943.5	68688.0
2018-02-23	FDXM	Futures	12991.5	13038.2	12911.4	12965.5	27005.0
2018-02-23	FESX	Futures	2806.9	2824.1	2794.7	2808.6	730969.0
2018-02-23	FGBL	Futures	147.06	147.97	147.06	147.8	778601.0
2018-02-23	FGBM	Futures	128.56	128.82	128.55	128.79	499433.0
2018-02-23	FGBS	Futures	112.321	112.367	112.311	112.352	332694.0
2018-02-23	FGBX	Futures	164.13	166.54	164.13	166.19	51104.0
2018-02-23	FMWO	Futures	6991.2	7060.1	6991.2	7025.0	794.0
2018-02-23	FOAT	Futures	136.0	136.7	135.98	136.67	94532.0
2018-02-23	FTDX	Futures	2587.7	2598.2	2576.3	2588.7	45.0
2018-02-23	FTI	Futures	488.96	492.49	487.62	490.29	17185.0
2018-02-23	FTUK	Futures	6315.1	6344.4	6293.3	6313.8	72111.0
2018-02-23	FVSA	Futures	438.28	443.2	417.35	430.89	8830.0
2018-02-23	FXXP	Futures	324.0	325.9	322.8	324.4	22462.0
2018-02-23	G	Futures	112.4	112.66	112.37	112.56	349665.0
2018-02-23	GF	Futures	321.27	321.984	318.745	320.611	5504.0
2018-02-23	GSCI	Futures	509.96	514.34	509.39	514.17	34.0
2018-02-23	HE	Futures	91.554	92.164	91.009	91.651	13546.0

> showing 50 of 110 rows — these rows as CSV

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