select count(*) as swap_count,asset_name ,block_timestamp::date as date
from algorand.swaps s
inner join algorand.asset a on a.asset_id=s.swap_to_asset_id
where swapper in (select address from algorand.account
having balance > 50000)
and date >='2022-01-01'
GROUP by asset_name,date