with toplist as (
select
a.asset_id,
count(distinct a.tx_group_id) as total_transfer
from algorand.asset_transfer_transaction a
where date(a.block_timestamp) >= '2022-02-01'
group by 1
order by 2 DESC
limit 10
)
select
date(a.block_timestamp) as date,
b.asset_name,
count(distinct a.tx_group_id) as total_transfer
from algorand.asset_transfer_transaction a
inner join algorand.asset b
on a.asset_transferred = b.asset_id
where date(a.block_timestamp) >= '2022-02-01'
and a.asset_id in (select asset_id from toplist)
group by 1, 2
order by 1