zakkisyed#5 Algorand: Total fees spent for transactions
    Updated 2022-07-06
    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
    Run a query to Download Data