PREVIEW / futures_daily / 2023-08-01

all futures daily files

  file:    by_date/futures_daily/2023/2023-08-01.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-08-01	ES	Futures	5000.8	5005.13	4971.83	4982.93	1212261.0
2023-08-01	NQ	Futures	17363.69	17385.57	17209.41	17306.79	529660.0
2023-08-01	YM	Futures	37946.9	38057.4	37803.4	38001.1	125388.0
2023-08-01	CL	Futures	70.81	71.23	69.82	70.5	307859.0
2023-08-01	GC	Futures	2157.9	2158.1	2130.0	2130.5	167756.0
2023-08-01	ZN	Futures	113.390346	113.485766	112.801925	112.849635	1523937.0
2023-08-01	A6	Futures	0.68165	0.68216	0.6699	0.67051	97713.0
2023-08-01	AD	Futures	0.76658	0.76679	0.76017	0.76072	104698.0
2023-08-01	ALI	Futures	2520.63	2527.62	2491.85	2503.31	4876.0
2023-08-01	B	Futures	75.44	76.03	74.52	75.14	297771.0
2023-08-01	B6	Futures	1.2863	1.2867	1.2766	1.2797	97418.0
2023-08-01	BFX	Futures	4142.1	4142.1	4142.1	4142.1	0.0
2023-08-01	BR	Futures	0.1945	0.19618	0.19315	0.19334	8706.0
2023-08-01	BTC	Futures	38944.3	39103.2	37917.7	38997.3	10567.0
2023-08-01	BZ	Futures	75.3	75.69	74.34	74.91	27179.0
2023-08-01	C	Futures	2267.0	2276.0	2241.0	2263.0	11150.0
2023-08-01	CB	Futures	252.404	253.475	250.975	251.023	125.0
2023-08-01	CC	Futures	2059.0	2074.0	2033.0	2054.0	29107.0
2023-08-01	CNH	Futures	6.8551	6.8928	6.8551	6.891	227.0
2023-08-01	CSC	Futures	2.048	2.054	1.967	1.978	104.0
2023-08-01	CT	Futures	107.94	108.27	107.13	108.27	7.0
2023-08-01	DC	Futures	18.83	19.0	18.11	18.25	952.0
2023-08-01	DX	Futures	99.733	100.288	99.694	100.15	14725.0
2023-08-01	E1	Futures	1.22298	1.22378	1.21466	1.21742	16101.0
2023-08-01	E6	Futures	1.12805	1.12866	1.12339	1.12559	155624.0
2023-08-01	E7	Futures	1.1281	1.1287	1.1234	1.1256	4687.0
2023-08-01	EBM	Futures	349.64	352.57	343.78	345.61	31212.0
2023-08-01	ER	Futures	97.878	97.889	97.878	97.889	57563.0
2023-08-01	ESG	Futures	433.39	433.71	432.14	432.76	609.0
2023-08-01	EW	Futures	2901.0	2903.8	2873.6	2891.1	9299.0
2023-08-01	FBON	Futures	122.24	122.24	121.23	121.23	71.0
2023-08-01	FBTP	Futures	114.18	114.24	113.22	113.34	140435.0
2023-08-01	FBTS	Futures	106.3	106.34	106.199	106.219	79412.0
2023-08-01	FCE	Futures	8130.2	8134.5	8015.5	8029.6	46860.0
2023-08-01	FDAX	Futures	17520.9	17530.5	17259.5	17301.8	54906.0
2023-08-01	FDIV	Futures	189.95	189.95	188.32	188.52	33.0
2023-08-01	FDXM	Futures	17600.1	17604.4	17330.1	17372.7	38219.0
2023-08-01	FDXS	Futures	17447.2	17490.5	17219.1	17261.4	23662.0
2023-08-01	FESX	Futures	4555.6	4558.6	4478.6	4486.7	895715.0
2023-08-01	FEU3	Futures	97.878	97.878	97.878	97.878	0.0
2023-08-01	FGBL	Futures	134.59	134.73	133.76	133.88	540220.0
2023-08-01	FGBM	Futures	118.53	118.61	118.22	118.27	430082.0
2023-08-01	FGBS	Futures	107.468	107.499	107.407	107.422	344786.0
2023-08-01	FGBX	Futures	137.81	138.03	135.47	135.8	70504.0
2023-08-01	FMWO	Futures	10687.6	10687.6	10612.7	10627.2	7456.0
2023-08-01	FOAT	Futures	125.78	125.88	124.88	125.02	133796.0
2023-08-01	FSMX	Futures	30098.8	30098.8	29805.4	29867.8	86.0
2023-08-01	FTDX	Futures	3519.3	3519.8	3499.3	3499.3	10.0
2023-08-01	FTI	Futures	829.88	830.51	822.41	824.14	11941.0
2023-08-01	FTUK	Futures	7812.0	7824.2	7757.1	7774.9	85242.0

> showing 50 of 130 rows — these rows as CSV

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