with base as (
select
asset_name,
a.asset_id,
count(distinct(tx_group_id)) as count_txs,
count(distinct(sender)) as count_senders
from algorand.asset_transfer_transaction a
join algorand.asset b
on a.asset_transferred = b.asset_id
where block_timestamp > '2022-02-01'
group by 1,2
), top10 as (
select * from base
order by 4 desc
limit 10
), daily as (
select
block_timestamp::date as date,
asset_name,
count(distinct(tx_group_id)) as count_txs,
count(distinct(sender)) as count_senders
from algorand.asset_transfer_transaction a
join algorand.asset b
on a.asset_transferred = b.asset_id
where block_timestamp > '2022-02-01'
and a.asset_id IN (select asset_id from top10)
group by 1,2
)
select * from daily