Query occasionally returns invalid result

We have a visualization for the following query: https://dune.com/queries/3240382/5425686

Today the query returned ~15,500, but in fact it must have been ~600,000. After re-run it starts returning valid results, but we displayed wrong numbers a couple of hours (we have a scheduled dashboard refresh configured).

Could you please investigate it?