PREVIEW / futures_daily / 2018-12-19

all futures daily files

  file:    by_date/futures_daily/2018/2018-12-19.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-12-19	ES	Futures	2741.32	2806.28	2695.31	2711.55	2865330.0
2018-12-19	NQ	Futures	7484.59	7652.75	7295.29	7354.34	714462.0
2018-12-19	YM	Futures	24866.2	25398.9	24439.0	24589.9	330149.0
2018-12-19	CL	Futures	48.57	50.72	48.56	50.52	817721.0
2018-12-19	GC	Futures	1579.4	1590.4	1569.1	1583.1	275306.0
2018-12-19	ZN	Futures	120.444438	120.926838	120.195458	120.677858	2011340.0
2018-12-19	A6	Futures	0.74084	0.7429	0.73126	0.73415	111048.0
2018-12-19	AD	Futures	0.75342	0.75641	0.75124	0.752	83285.0
2018-12-19	B	Futures	41.49	42.67	41.15	42.03	319367.0
2018-12-19	B6	Futures	1.3041	1.3078	1.3004	1.3023	86683.0
2018-12-19	BR	Futures	0.20495	0.20495	0.20495	0.20495	93.0
2018-12-19	BTC	Futures	5416.8	5935.6	5416.8	5638.0	4997.0
2018-12-19	BZ	Futures	40.74	42.11	40.61	41.49	47399.0
2018-12-19	C	Futures	1482.0	1498.0	1464.0	1496.0	9628.0
2018-12-19	CB	Futures	267.885	269.707	267.885	268.856	62.0
2018-12-19	CC	Futures	1578.0	1598.0	1545.0	1596.0	16227.0
2018-12-19	CNH	Futures	6.9059	6.9187	6.9035	6.9187	626.0
2018-12-19	CSC	Futures	2.812	2.816	2.784	2.788	150.0
2018-12-19	CT	Futures	84.71	85.0	83.47	83.56	18118.0
2018-12-19	DC	Futures	23.96	23.97	23.67	23.7	385.0
2018-12-19	DX	Futures	91.927	92.094	91.55	92.017	20141.0
2018-12-19	E1	Futures	1.19535	1.19747	1.19159	1.19324	25077.0
2018-12-19	E6	Futures	1.26602	1.27425	1.26575	1.26663	216554.0
2018-12-19	E7	Futures	1.26	1.2683	1.2596	1.2605	4923.0
2018-12-19	EBM	Futures	212.31	212.57	211.03	211.03	17072.0
2018-12-19	ED	Futures	94.9939	95.0037	94.9451	94.9744	557893.0
2018-12-19	ER	Futures	98.391	98.396	98.386	98.396	97800.0
2018-12-19	EW	Futures	1797.6	1829.8	1764.7	1774.3	26431.0
2018-12-19	FBON	Futures	130.14	130.37	129.96	130.01	313.0
2018-12-19	FBTP	Futures	110.27	111.49	110.27	111.1	108252.0
2018-12-19	FBTS	Futures	104.594	104.859	104.566	104.66	74907.0
2018-12-19	FCE	Futures	4231.1	4261.7	4176.0	4239.1	87659.0
2018-12-19	FDAX	Futures	11272.5	11374.4	11132.7	11321.9	51331.0
2018-12-19	FDXM	Futures	11237.7	11344.6	11101.4	11294.3	2918.0
2018-12-19	FESX	Futures	2591.9	2611.6	2556.0	2599.6	1202137.0
2018-12-19	FGBL	Futures	155.44	155.79	155.21	155.34	543437.0
2018-12-19	FGBM	Futures	131.72	131.83	131.59	131.69	310438.0
2018-12-19	FGBS	Futures	112.683	112.693	112.658	112.663	173088.0
2018-12-19	FGBX	Futures	184.08	184.91	183.33	183.47	37257.0
2018-12-19	FMWO	Futures	6435.2	6494.6	6314.0	6466.6	9402.0
2018-12-19	FOAT	Futures	141.32	141.39	141.13	141.2	58130.0
2018-12-19	FTDX	Futures	2469.8	2484.2	2453.9	2482.2	1711.0
2018-12-19	FTI	Futures	462.38	465.89	456.67	463.92	20248.0
2018-12-19	FTUK	Futures	6042.2	6125.1	6013.0	6117.8	170696.0
2018-12-19	FVSA	Futures	414.37	427.57	402.18	412.34	21212.0
2018-12-19	FXXP	Futures	298.0	299.1	294.7	298.5	67430.0
2018-12-19	G	Futures	116.68	117.02	116.68	116.8	130601.0
2018-12-19	GF	Futures	314.764	315.787	313.849	314.71	3280.0
2018-12-19	GSCI	Futures	440.9	447.85	440.9	447.28	32.0
2018-12-19	HE	Futures	75.431	76.393	74.8	75.401	12796.0

> showing 50 of 113 rows — these rows as CSV

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