flipside

    #4 Algorand: Wallets with number of transactions
    zakkisyed#4 Algorand: Wallets with number of transactions
    Updated 2022-07-06
    select distinct sender as wallet, count (tx_id) as no_of_tx, sum(fee) as fees
    from algorand.transactions
    where block_timestamp >= '2022-1-1'
    and fee is not null
    group by 1
    --order by 2 desc

    --limit 25
    Run a query to Download Data