with temp as (select top 10 count(*),asset_name
from algorand.asset_transfer_transaction
inner join
algorand.asset
on algorand.asset.asset_id=algorand.asset_transfer_transaction.asset_id
where
block_timestamp::date >= '2022-02-01'
group by asset_name
order by count(*) DESC)
select count(*),block_timestamp::date
from algorand.asset_transfer_transaction
inner join
algorand.asset
on algorand.asset.asset_id=algorand.asset_transfer_transaction.asset_id
where
block_timestamp::date >= '2022-02-01' and asset_name in (select asset_name from temp)
group by block_timestamp::date