with whale as (select
distinct address as whales
from algorand.account where balance > 100000)
select
date_trunc(day,s.block_timestamp) as day,
l.asset_name,
count(s.swapper) as swap_number
from algorand.swaps s
inner join
algorand.asset l on s.swap_from_asset_id = l.asset_id
where swapper in (select * from whale)
and block_timestamp >= '2022-01-01'
group by 1,2 order by 3 desc