select asset_name, sum(fee) as fees, count(tx_id) as transactions from algorand.asset_transfer_transaction
inner join algorand.asset on algorand.asset.asset_id = algorand.asset_transfer_transaction.asset_id
where fee is not null
and date_trunc(day,block_timestamp) = '2022-1-1'
group by 1
order by 2 desc
limit 10