PREVIEW / futures_daily / 2023-06-23

all futures daily files

  file:    by_date/futures_daily/2023/2023-06-23.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-06-23	ES	Futures	4792.87	4793.41	4744.95	4753.07	1550992.0
2023-06-23	NQ	Futures	16670.8	16670.8	16396.44	16476.32	620593.0
2023-06-23	YM	Futures	36399.5	36399.5	36014.8	36109.4	144692.0
2023-06-23	CL	Futures	60.34	60.45	58.45	60.02	322475.0
2023-06-23	GC	Futures	2114.6	2142.6	2110.2	2121.3	186861.0
2023-06-23	ZN	Futures	114.758028	115.505482	114.694415	115.091996	1516582.0
2023-06-23	A6	Futures	0.686	0.68707	0.67648	0.6779	97478.0
2023-06-23	AD	Futures	0.76936	0.76977	0.76497	0.76704	69783.0
2023-06-23	ALI	Futures	2451.53	2451.53	2405.78	2418.81	1025.0
2023-06-23	B	Futures	65.51	65.88	63.82	65.36	169542.0
2023-06-23	B6	Futures	1.277	1.2776	1.271	1.2736	86292.0
2023-06-23	BFX	Futures	3899.0	3899.0	3899.0	3899.0	0.0
2023-06-23	BR	Futures	0.19236	0.19334	0.19236	0.19278	161.0
2023-06-23	BTC	Futures	40231.8	42205.1	39965.2	41491.8	12562.0
2023-06-23	BZ	Futures	65.29	65.48	63.48	65.02	15800.0
2023-06-23	C	Futures	1964.0	1984.0	1960.0	1965.0	1846.0
2023-06-23	CB	Futures	231.449	231.926	231.449	231.926	11.0
2023-06-23	CC	Futures	1849.0	1867.0	1842.0	1857.0	18425.0
2023-06-23	CNH	Futures	6.8834	6.912	6.8834	6.9043	345.0
2023-06-23	CSC	Futures	1.948	1.958	1.948	1.948	118.0
2023-06-23	CT	Futures	100.85	100.99	97.44	98.9	2498.0
2023-06-23	DC	Futures	18.0	18.12	17.93	17.98	107.0
2023-06-23	DX	Futures	100.072	100.837	100.052	100.599	13130.0
2023-06-23	E1	Futures	1.19609	1.19657	1.18718	1.19275	17510.0
2023-06-23	E6	Futures	1.126	1.12641	1.11454	1.1194	201693.0
2023-06-23	E7	Futures	1.126	1.1265	1.1146	1.1195	5005.0
2023-06-23	EBM	Futures	363.55	365.02	359.52	361.72	30637.0
2023-06-23	ER	Futures	97.705	97.777	97.705	97.761	145690.0
2023-06-23	ESG	Futures	414.4	414.51	412.18	412.52	531.0
2023-06-23	EW	Futures	2717.4	2717.4	2677.1	2681.1	12114.0
2023-06-23	FBON	Futures	122.21	123.77	122.21	123.44	140.0
2023-06-23	FBTP	Futures	113.96	115.45	113.91	115.03	149225.0
2023-06-23	FBTS	Futures	105.815	106.138	105.815	106.068	141200.0
2023-06-23	FCE	Futures	7817.2	7845.5	7773.6	7812.3	53665.0
2023-06-23	FDAX	Futures	17045.6	17054.1	16783.1	16877.3	71154.0
2023-06-23	FDIV	Futures	182.96	182.96	182.96	182.96	0.0
2023-06-23	FDXM	Futures	17126.1	17126.1	16852.9	16946.4	35850.0
2023-06-23	FDXS	Futures	16995.2	17011.1	16744.9	16837.9	21792.0
2023-06-23	FESX	Futures	4390.4	4390.4	4330.7	4346.9	738233.0
2023-06-23	FEU3	Futures	97.756	97.756	97.756	97.756	0.0
2023-06-23	FGBL	Futures	134.45	136.37	134.39	135.96	882165.0
2023-06-23	FGBM	Futures	118.05	119.09	118.03	118.81	609924.0
2023-06-23	FGBS	Futures	107.264	107.55	107.238	107.463	483511.0
2023-06-23	FGBX	Futures	140.23	143.57	140.04	143.08	87369.0
2023-06-23	FMWO	Futures	10198.9	10220.2	10157.5	10163.1	1572.0
2023-06-23	FOAT	Futures	125.83	127.63	125.77	127.29	187985.0
2023-06-23	FSMX	Futures	28052.7	28161.9	27925.8	27990.3	350.0
2023-06-23	FTDX	Futures	3283.4	3356.0	3283.4	3342.9	53.0
2023-06-23	FTI	Futures	796.15	799.09	793.26	796.37	14879.0
2023-06-23	FTUK	Futures	7645.9	7648.4	7571.2	7592.0	83832.0

> showing 50 of 130 rows — these rows as CSV

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