Query Service - UNION ALL in snapshots

Why a single snapshot query returns correct data

Returns:

822 -> profiles = 5,746 || min qualification = 2026-07-23 11:37 || max qualification = 2026-08-01 11:41

but when I query multiple snapshots it’s returning data with last snapshot?

 

Returns:

822 -> 5,688 profiles -> MAX qualification = 2026-08-05

823 -> 5,688 profiles -> MAX qualification = 2026-08-05

824 -> 5,688 profiles -> MAX qualification = 2026-08-05