PREVIEW / futures_daily / 2020-09-18

all futures daily files

  file:    by_date/futures_daily/2020/2020-09-18.parquet
  size:    10 KB
  rows:    119

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
2020-09-18	ES	Futures	3758.04	3778.27	3685.86	3725.74	2365554.0
2020-09-18	NQ	Futures	12811.79	12923.51	12436.11	12650.29	800279.0
2020-09-18	YM	Futures	29912.8	30015.0	29464.9	29715.7	215692.0
2020-09-18	CL	Futures	29.58	29.95	29.09	29.67	280854.0
2020-09-18	GC	Futures	2304.3	2324.5	2304.3	2317.3	176074.0
2020-09-18	ZN	Futures	138.280203	138.419677	138.202718	138.264706	728725.0
2020-09-18	A6	Futures	0.75073	0.75309	0.74775	0.7495	78076.0
2020-09-18	AD	Futures	0.77032	0.77154	0.76734	0.76815	64514.0
2020-09-18	ALI	Futures	2136.79	2155.8	2134.41	2144.81	254.0
2020-09-18	B	Futures	27.55	27.92	27.11	27.51	204656.0
2020-09-18	B6	Futures	1.3155	1.3187	1.3101	1.3114	77616.0
2020-09-18	BR	Futures	0.1504	0.1504	0.14651	0.14651	7.0
2020-09-18	BTC	Futures	14818.2	14953.2	14602.1	14689.9	4499.0
2020-09-18	BZ	Futures	26.98	27.32	26.52	26.91	26032.0
2020-09-18	C	Futures	1654.0	1678.0	1649.0	1662.0	6306.0
2020-09-18	CB	Futures	172.787	176.852	172.787	173.295	16.0
2020-09-18	CC	Futures	1719.0	1754.0	1717.0	1734.0	14848.0
2020-09-18	CNH	Futures	6.6532	6.6725	6.639	6.6725	937.0
2020-09-18	CSC	Futures	3.364	3.408	3.364	3.408	61.0
2020-09-18	CT	Futures	64.91	64.91	64.89	64.89	12.0
2020-09-18	DC	Futures	27.28	27.94	27.17	27.89	310.0
2020-09-18	DX	Futures	89.733	89.878	89.612	89.788	15652.0
2020-09-18	E1	Futures	1.24975	1.25077	1.24511	1.24726	14753.0
2020-09-18	E6	Futures	1.27114	1.27393	1.26916	1.27195	141967.0
2020-09-18	E7	Futures	1.2645	1.2674	1.2627	1.2655	5019.0
2020-09-18	EBM	Futures	232.67	234.78	231.46	234.47	43234.0
2020-09-18	ED	Futures	96.4697	96.4793	96.4648	96.4697	171364.0
2020-09-18	ER	Futures	98.431	98.445	98.426	98.435	73284.0
2020-09-18	ESG	Futures	310.93	310.93	303.81	306.48	129.0
2020-09-18	EW	Futures	2013.9	2022.1	1971.9	1989.8	15549.0
2020-09-18	FBON	Futures	148.02	148.02	147.62	147.64	239.0
2020-09-18	FBTP	Futures	134.37	134.48	134.07	134.2	91285.0
2020-09-18	FBTS	Futures	109.228	109.257	109.18	109.189	40931.0
2020-09-18	FCE	Futures	4882.5	4885.9	4789.9	4818.5	82366.0
2020-09-18	FDAX	Futures	14114.5	14120.9	13898.6	14012.2	82736.0
2020-09-18	FDIV	Futures	153.32	153.32	152.56	152.56	120.0
2020-09-18	FDXM	Futures	13981.3	14050.2	13828.5	13941.5	58530.0
2020-09-18	FESX	Futures	3060.1	3064.7	3005.6	3032.4	1287072.0
2020-09-18	FEU3	Futures	99.174	99.178	99.174	99.178	50.0
2020-09-18	FGBL	Futures	169.28	169.64	169.15	169.28	438515.0
2020-09-18	FGBM	Futures	135.05	135.14	134.95	135.02	293287.0
2020-09-18	FGBS	Futures	112.769	112.785	112.744	112.759	252722.0
2020-09-18	FGBX	Futures	230.57	231.2	229.26	229.84	38549.0
2020-09-18	FMWO	Futures	8397.6	8415.3	8246.0	8349.0	2372.0
2020-09-18	FOAT	Futures	157.5	157.75	157.32	157.43	100413.0
2020-09-18	FTDX	Futures	3189.2	3234.0	3185.6	3208.8	348.0
2020-09-18	FTI	Futures	515.48	517.53	508.91	513.07	25572.0
2020-09-18	FTUK	Futures	5739.8	5773.3	5685.8	5726.0	107057.0
2020-09-18	FVSA	Futures	189.81	198.73	189.44	190.56	15141.0
2020-09-18	FXXP	Futures	342.9	343.4	338.2	340.9	58090.0

> showing 50 of 119 rows — these rows as CSV

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