with whales as (
SELECT address
from algorand.account
where balance >= 100000
)
SELECT
swapper,
COUNT(DISTINCT tx_group_id) as swap_count
from algorand.swaps
where
date(block_timestamp) >= '2022-01-01'
and swap_from_amount > 0
and swapper in (SELECT address from whales)
GROUP by swapper