PREVIEW / futures_daily / 2023-07-31

all futures daily files

  file:    by_date/futures_daily/2023/2023-07-31.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-31	ES	Futures	4991.05	5002.42	4976.43	4997.28	1299434.0
2023-07-31	NQ	Futures	17342.63	17415.94	17278.34	17350.83	523896.0
2023-07-31	YM	Futures	37832.1	37954.3	37739.6	37935.2	105890.0
2023-07-31	CL	Futures	69.87	71.04	69.42	70.87	297270.0
2023-07-31	GC	Futures	2151.1	2165.1	2139.1	2163.3	139955.0
2023-07-31	ZN	Futures	113.453959	113.612992	113.040474	113.390346	1686431.0
2023-07-31	A6	Futures	0.67471	0.68388	0.67461	0.68165	75699.0
2023-07-31	AD	Futures	0.7631	0.76886	0.76239	0.76739	67150.0
2023-07-31	ALI	Futures	2474.24	2540.47	2473.69	2537.4	3678.0
2023-07-31	B	Futures	74.71	75.74	74.26	75.6	324258.0
2023-07-31	B6	Futures	1.2877	1.2899	1.2855	1.2864	63958.0
2023-07-31	BFX	Futures	4160.3	4160.3	4160.3	4160.3	0.0
2023-07-31	BR	Futures	0.19567	0.19665	0.19115	0.1959	8192.0
2023-07-31	BTC	Futures	38931.0	39421.1	38752.2	38791.9	5498.0
2023-07-31	BZ	Futures	74.61	75.51	74.05	75.37	23446.0
2023-07-31	C	Futures	2251.0	2267.0	2251.0	2259.0	6396.0
2023-07-31	CB	Futures	254.213	254.785	254.213	254.547	33.0
2023-07-31	CC	Futures	2045.0	2069.0	2042.0	2057.0	19202.0
2023-07-31	CNH	Futures	6.8509	6.8604	6.8391	6.8496	189.0
2023-07-31	CSC	Futures	2.003	2.065	2.003	2.038	206.0
2023-07-31	CT	Futures	105.99	108.68	105.32	106.49	29.0
2023-07-31	DC	Futures	18.42	19.13	18.14	18.84	637.0
2023-07-31	DX	Futures	99.537	99.738	99.375	99.7	12464.0
2023-07-31	E1	Futures	1.22537	1.23057	1.22139	1.22325	18601.0
2023-07-31	E6	Futures	1.13025	1.13311	1.12769	1.1282	147394.0
2023-07-31	E7	Futures	1.1303	1.1331	1.1277	1.1283	4414.0
2023-07-31	EBM	Futures	355.13	357.69	348.54	351.47	30590.0
2023-07-31	ER	Futures	97.889	97.894	97.873	97.883	143519.0
2023-07-31	ESG	Futures	433.97	434.92	433.14	434.62	377.0
2023-07-31	EW	Futures	2885.6	2906.2	2881.3	2899.8	11310.0
2023-07-31	FBON	Futures	121.49	122.07	121.49	122.05	31.0
2023-07-31	FBTP	Futures	113.66	114.19	113.53	114.1	116919.0
2023-07-31	FBTS	Futures	106.169	106.32	106.148	106.31	92686.0
2023-07-31	FCE	Futures	8100.4	8160.5	8092.3	8129.7	39291.0
2023-07-31	FDAX	Futures	17527.3	17587.6	17471.2	17517.7	41854.0
2023-07-31	FDIV	Futures	191.99	191.99	191.02	191.02	10.0
2023-07-31	FDXM	Futures	17593.7	17660.7	17543.8	17589.5	30532.0
2023-07-31	FDXS	Futures	17496.9	17547.5	17432.4	17476.8	20027.0
2023-07-31	FESX	Futures	4543.4	4571.8	4531.2	4554.5	818189.0
2023-07-31	FEU3	Futures	97.873	97.873	97.873	97.873	0.0
2023-07-31	FGBL	Futures	134.49	134.72	134.08	134.67	610519.0
2023-07-31	FGBM	Futures	118.43	118.58	118.23	118.56	516889.0
2023-07-31	FGBS	Futures	107.412	107.479	107.361	107.473	475532.0
2023-07-31	FGBX	Futures	137.79	138.12	136.7	137.95	69692.0
2023-07-31	FMWO	Futures	10688.7	10716.7	10657.4	10702.2	4183.0
2023-07-31	FOAT	Futures	125.51	125.87	125.21	125.82	153553.0
2023-07-31	FSMX	Futures	29985.4	30175.7	29965.6	30174.7	45.0
2023-07-31	FTDX	Futures	3502.4	3526.6	3502.4	3524.0	16.0
2023-07-31	FTI	Futures	829.83	832.72	827.41	830.08	11200.0
2023-07-31	FTUK	Futures	7788.6	7834.9	7765.3	7813.5	87186.0

> showing 50 of 130 rows — these rows as CSV

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