PREVIEW / futures_daily / 2023-05-01

all futures daily files

  file:    by_date/futures_daily/2023/2023-05-01.parquet
  size:    9 KB
  rows:    99

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-05-01	ES	Futures	4584.79	4602.57	4572.21	4580.14	1240490.0
2023-05-01	NQ	Futures	14762.58	14821.61	14698.01	14751.22	487908.0
2023-05-01	YM	Futures	36664.7	36822.2	36546.8	36596.1	109767.0
2023-05-01	CL	Futures	66.84	66.86	64.98	65.96	215017.0
2023-05-01	GC	Futures	2219.4	2236.2	2203.3	2210.5	173016.0
2023-05-01	ZN	Futures	118.097335	118.097335	116.962245	117.154092	1019434.0
2023-05-01	A6	Futures	0.67381	0.6791	0.67295	0.67518	57532.0
2023-05-01	AD	Futures	0.74867	0.74938	0.74645	0.74862	51390.0
2023-05-01	ALI	Futures	2616.38	2616.38	2616.38	2616.38	2.0
2023-05-01	B	Futures	70.76	70.88	69.01	70.05	146564.0
2023-05-01	B6	Futures	1.2639	1.2651	1.2547	1.2554	71288.0
2023-05-01	BR	Futures	0.17934	0.18016	0.17925	0.17998	1421.0
2023-05-01	BTC	Futures	39869.9	39869.9	37305.2	37581.2	8811.0
2023-05-01	BZ	Futures	70.4	70.41	68.6	69.63	12551.0
2023-05-01	CB	Futures	236.871	239.783	236.871	237.849	108.0
2023-05-01	CC	Futures	1705.0	1729.0	1694.0	1702.0	15660.0
2023-05-01	CNH	Futures	6.5976	6.6293	6.5976	6.6286	86.0
2023-05-01	CSC	Futures	2.132	2.139	2.116	2.123	202.0
2023-05-01	CT	Futures	102.05	103.36	101.24	103.02	11475.0
2023-05-01	DC	Futures	20.35	20.35	19.85	19.96	527.0
2023-05-01	DX	Futures	99.115	99.658	99.101	99.619	14669.0
2023-05-01	E1	Futures	1.20448	1.20796	1.20095	1.20186	12743.0
2023-05-01	E6	Futures	1.13612	1.13792	1.13057	1.13119	122625.0
2023-05-01	E7	Futures	1.1354	1.1373	1.13	1.1307	2811.0
2023-05-01	ER	Futures	97.914	97.914	97.914	97.914	0.0
2023-05-01	ESG	Futures	396.16	397.94	396.01	396.46	368.0
2023-05-01	EW	Futures	2670.3	2690.6	2662.1	2668.2	11337.0
2023-05-01	FTUK	Futures	8016.8	8016.8	8016.8	8016.8	0.0
2023-05-01	G	Futures	101.17	101.17	101.17	101.17	0.0
2023-05-01	GF	Futures	241.87	242.731	240.261	240.893	1930.0
2023-05-01	GSCI	Futures	567.34	567.34	567.34	567.34	0.0
2023-05-01	HE	Futures	73.202	73.242	71.259	71.86	21180.0
2023-05-01	HG	Futures	4.2297	4.3492	4.2031	4.2721	59057.0
2023-05-01	HH	Futures	5.343	5.406	5.156	5.215	3807.0
2023-05-01	HO	Futures	1.8801	1.8939	1.8441	1.8881	41467.0
2023-05-01	HRC	Futures	1432.3	1439.0	1421.7	1421.7	92.0
2023-05-01	J1	Futures	0.0081374	0.0081379	0.0080565	0.0080598	142451.0
2023-05-01	J7	Futures	0.008158	0.008158	0.008071	0.008074	350.0
2023-05-01	JB	Futures	140.66	140.7	140.31	140.38	1411.0
2023-05-01	KC	Futures	156.88	159.1	156.2	158.12	11501.0
2023-05-01	KE	Futures	914.39	915.27	886.68	892.87	21788.0
2023-05-01	KRW	Futures	0.0007595	0.0007595	0.0007595	0.0007595	0.0
2023-05-01	LBS	Futures	776.6	787.7	764.7	764.7	79.0
2023-05-01	LE	Futures	170.978	171.573	170.228	170.642	24373.0
2023-05-01	M2K	Futures	1920.6	1941.6	1911.7	1919.9	58506.0
2023-05-01	MBT	Futures	34411.8	34510.5	32192.4	32436.4	10580.0
2023-05-01	MCL	Futures	76.65	76.68	74.51	75.63	76361.0
2023-05-01	MES	Futures	4520.39	4538.46	4508.52	4516.34	710363.0
2023-05-01	MET	Futures	2483.0	2483.0	2345.6	2357.3	7129.0
2023-05-01	MFS	Futures	2240.5	2250.1	2235.9	2240.5	29309.0

> showing 50 of 99 rows — these rows as CSV

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