select TOP 10 asset.asset_id, count(asset.asset_id) as transactions_total from algorand.asset_transfer_transaction att

join algorand.asset asset on att.asset_id = asset.asset_id

where asset.asset_deleted = false

group by asset.asset_id

order by count(asset.asset_id) desc

),

total_transactions as (

select popular_asas.asset_id, date(transactions.block_timestamp) as date, count(popular_asas.asset_id, date(transactions.block_timestamp)) as total_transactions

from popular_asas join flipside_prod_db.algorand.transactions transactions on popular_asas.asset_id = transactions.asset_id

group by popular_asas.asset_id, date(transactions.block_timestamp)

),

assets as (select * from flipside_prod_db.algorand.asset a)

select asset_name, date, total_transactions from total_transactions t join assets a on t.asset_id = a.asset_id