PREVIEW / futures_daily / 2023-08-24

all futures daily files

  file:    by_date/futures_daily/2023/2023-08-24.parquet
  size:    10 KB
  rows:    129

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-08-24	ES	Futures	4841.33	4857.58	4741.7	4749.82	1783795.0
2023-08-24	NQ	Futures	16776.94	16869.94	16212.35	16261.58	847308.0
2023-08-24	YM	Futures	36746.0	36917.1	36239.0	36282.6	173274.0
2023-08-24	CL	Futures	68.67	69.29	67.82	69.09	349230.0
2023-08-24	GC	Futures	2094.0	2100.9	2087.9	2096.4	137393.0
2023-08-24	ZN	Futures	111.800019	111.943148	111.46605	111.545566	3280441.0
2023-08-24	A6	Futures	0.65693	0.65774	0.65009	0.65106	72238.0
2023-08-24	AD	Futures	0.74713	0.74819	0.7438	0.74461	61122.0
2023-08-24	ALI	Futures	2405.85	2405.85	2375.8	2380.77	961.0
2023-08-24	B	Futures	73.41	74.0	72.54	73.77	253841.0
2023-08-24	B6	Futures	1.2744	1.2753	1.2614	1.2631	102712.0
2023-08-24	BFX	Futures	3975.3	3975.3	3975.3	3975.3	0.0
2023-08-24	BR	Futures	0.19254	0.19254	0.19049	0.19115	9053.0
2023-08-24	BTC	Futures	35288.3	35581.6	34601.7	34848.3	6618.0
2023-08-24	BZ	Futures	73.22	73.76	72.32	73.54	27997.0
2023-08-24	C	Futures	2260.0	2296.0	2260.0	2287.0	2808.0
2023-08-24	CB	Futures	257.547	258.538	257.547	258.315	16.0
2023-08-24	CC	Futures	1998.0	2022.0	1977.0	2004.0	32223.0
2023-08-24	CNH	Futures	7.0013	7.0145	6.994	7.0037	235.0
2023-08-24	CSC	Futures	2.091	2.124	2.086	2.113	112.0
2023-08-24	CT	Futures	108.15	108.36	107.18	107.3	67.0
2023-08-24	DC	Futures	19.17	19.64	19.17	19.53	580.0
2023-08-24	DX	Futures	101.318	101.995	101.234	101.95	16063.0
2023-08-24	E1	Futures	1.21158	1.21397	1.20113	1.20214	21873.0
2023-08-24	E6	Futures	1.11306	1.11428	1.10692	1.10733	154437.0
2023-08-24	E7	Futures	1.1132	1.1144	1.1069	1.1074	3536.0
2023-08-24	EBM	Futures	337.19	344.15	336.83	343.05	17138.0
2023-08-24	ER	Futures	97.873	97.889	97.868	97.878	133905.0
2023-08-24	ESG	Futures	422.29	422.44	411.99	412.29	964.0
2023-08-24	EW	Futures	2753.6	2766.5	2719.6	2722.5	10999.0
2023-08-24	FBON	Futures	121.97	122.47	121.56	121.6	297.0
2023-08-24	FBTP	Futures	113.8	114.22	113.23	113.32	121010.0
2023-08-24	FBTS	Futures	106.421	106.512	106.27	106.3	122031.0
2023-08-24	FCE	Futures	7914.3	7965.2	7792.7	7821.3	46841.0
2023-08-24	FDAX	Futures	16754.5	16867.8	16499.4	16587.3	57124.0
2023-08-24	FDIV	Futures	181.22	181.73	181.17	181.73	4.0
2023-08-24	FDXM	Futures	16813.6	16936.9	16561.7	16655.2	40792.0
2023-08-24	FDXS	Futures	16676.3	16828.4	16471.4	16548.5	23593.0
2023-08-24	FESX	Futures	4356.0	4389.4	4280.0	4299.3	733629.0
2023-08-24	FEU3	Futures	97.868	97.868	97.868	97.868	0.0
2023-08-24	FGBL	Futures	134.42	135.03	134.0	134.15	600764.0
2023-08-24	FGBM	Futures	118.65	118.93	118.43	118.55	545828.0
2023-08-24	FGBS	Futures	107.55	107.658	107.499	107.545	491758.0
2023-08-24	FGBX	Futures	136.46	137.91	135.78	135.94	60185.0
2023-08-24	FMWO	Futures	10281.7	10319.7	10091.6	10168.7	4180.0
2023-08-24	FOAT	Futures	125.64	126.24	125.25	125.37	141299.0
2023-08-24	FSMX	Futures	28707.0	28774.6	28234.8	28276.4	110.0
2023-08-24	FTDX	Futures	3289.1	3324.4	3261.8	3261.8	57.0
2023-08-24	FTI	Futures	780.62	782.76	764.5	766.61	13685.0
2023-08-24	FTUK	Futures	7461.9	7519.3	7443.1	7467.5	80489.0

> showing 50 of 129 rows — these rows as CSV

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