Welcome to the Earthdata Forum! Here, the scientific user community and subject matter experts from NASA Distributed Active Archive Centers (DAACs), and other contributors, discuss research needs, data, and data applications.
After a little more investigation is looks like not MODIS L2 data is available from 2025-06-02 to 2025-06-30. if I change the start date 2025-06-01, I get data for 6/1/25 but any date after that fails.
The dtid=1041 tells the file search to look for refined Aqua_MODIS L2 OC (ocean color) products. There are none generated beyond June 1st yet. if you set dtid=1053 you will get the near real-time (NRT) version of that product, which is available through the current date.