select block_timestamp::date as date,
case
when swap_from_asset_id=0 then 'Algo'
else asset_name
end as asset_name, count(*) as swap_count, count(distinct swapper) as swapper_count
from algorand.swaps
left join algorand.asset
on swap_from_asset_id=asset_id
where block_timestamp = CURRENT_DATE-30
group by date, swap_from_asset_id,asset_name
order by swap_count desc