PREVIEW / futures_daily / 2023-07-20

all futures daily files

  file:    by_date/futures_daily/2023/2023-07-20.parquet
  size:    10 KB
  rows:    130

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
2023-07-20	ES	Futures	4974.26	4975.35	4935.28	4944.21	1527727.0
2023-07-20	NQ	Futures	17422.23	17425.51	17011.09	17060.6	810475.0
2023-07-20	YM	Futures	37448.4	37780.0	37400.6	37622.7	176631.0
2023-07-20	CL	Futures	65.26	65.97	64.56	65.54	340962.0
2023-07-20	GC	Futures	2176.7	2187.4	2163.2	2166.7	189926.0
2023-07-20	ZN	Futures	114.901157	114.980674	113.994671	114.1378	1563021.0
2023-07-20	A6	Futures	0.68737	0.69487	0.68666	0.68818	85984.0
2023-07-20	AD	Futures	0.7683	0.77083	0.76638	0.76744	48324.0
2023-07-20	ALI	Futures	2453.29	2470.33	2441.27	2448.54	1743.0
2023-07-20	B	Futures	69.5	70.32	68.91	69.77	277109.0
2023-07-20	B6	Futures	1.2963	1.2991	1.2866	1.2884	91656.0
2023-07-20	BFX	Futures	4153.7	4158.1	4153.7	4158.1	12.0
2023-07-20	BR	Futures	0.19357	0.19394	0.19231	0.19254	526.0
2023-07-20	BTC	Futures	40177.3	40928.5	39647.6	39922.5	9406.0
2023-07-20	BZ	Futures	69.53	70.2	68.8	69.65	24867.0
2023-07-20	C	Futures	2158.0	2161.0	2129.0	2146.0	6142.0
2023-07-20	CB	Futures	238.569	240.974	237.664	240.188	84.0
2023-07-20	CC	Futures	1977.0	1983.0	1956.0	1964.0	18330.0
2023-07-20	CNH	Futures	6.9276	6.9276	6.8676	6.877	677.0
2023-07-20	CSC	Futures	1.848	1.935	1.834	1.935	138.0
2023-07-20	CT	Futures	107.59	107.59	107.1	107.1	4.0
2023-07-20	DC	Futures	17.01	17.86	16.82	17.83	615.0
2023-07-20	DX	Futures	98.071	98.777	97.855	98.691	15091.0
2023-07-20	E1	Futures	1.24314	1.24675	1.22903	1.23073	22201.0
2023-07-20	E6	Futures	1.1498	1.15246	1.1411	1.14186	170455.0
2023-07-20	E7	Futures	1.1498	1.1524	1.1412	1.1419	4554.0
2023-07-20	EBM	Futures	379.29	381.86	359.16	374.54	77258.0
2023-07-20	ER	Futures	97.822	97.822	97.807	97.812	91797.0
2023-07-20	ESG	Futures	431.8	432.19	428.43	429.03	732.0
2023-07-20	EW	Futures	2899.1	2911.7	2873.5	2884.6	11421.0
2023-07-20	FBON	Futures	122.95	122.95	122.16	122.18	259.0
2023-07-20	FBTP	Futures	114.38	114.44	113.86	113.94	126400.0
2023-07-20	FBTS	Futures	106.209	106.209	105.997	106.027	94175.0
2023-07-20	FCE	Futures	7961.4	8029.0	7921.9	8013.9	45095.0
2023-07-20	FDAX	Futures	17147.3	17285.9	17086.9	17252.1	53525.0
2023-07-20	FDIV	Futures	188.88	188.88	188.88	188.88	0.0
2023-07-20	FDXM	Futures	17207.9	17357.8	17156.9	17322.7	40227.0
2023-07-20	FDXS	Futures	17096.6	17240.2	17048.0	17211.7	16943.0
2023-07-20	FESX	Futures	4433.0	4459.3	4417.8	4452.2	643561.0
2023-07-20	FEU3	Futures	97.807	97.807	97.807	97.807	0.0
2023-07-20	FGBL	Futures	135.53	135.55	134.5	134.68	713371.0
2023-07-20	FGBM	Futures	118.76	118.76	118.24	118.3	579029.0
2023-07-20	FGBS	Futures	107.438	107.453	107.284	107.305	421270.0
2023-07-20	FGBX	Futures	141.46	141.62	139.41	139.92	70441.0
2023-07-20	FMWO	Futures	10647.4	10664.1	10582.5	10620.5	2884.0
2023-07-20	FOAT	Futures	126.65	126.71	125.69	125.84	188169.0
2023-07-20	FSMX	Futures	29709.7	29736.8	29462.2	29596.4	168.0
2023-07-20	FTDX	Futures	3387.1	3444.0	3381.3	3400.8	135.0
2023-07-20	FTI	Futures	810.48	812.0	804.32	807.17	9348.0
2023-07-20	FTUK	Futures	7687.5	7779.5	7687.5	7767.8	105786.0

> showing 50 of 130 rows — these rows as CSV

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