freemartianTop 10 Algo Wallets
    Updated 2022-11-15

    select
    tx_sender as user,
    sum(fee) as Fee_in_Algo,
    (sum(fee)*avg(price_usd)) as Fee_in_usd
    from algorand.core.fact_transaction ft inner join algorand.core.ez_price_pool_balances ap
    on ap.block_hour::date = ft.block_timestamp::date
    where block_timestamp > CURRENT_DATE - 31
    and fee > 0
    and asset_id = '0'
    group by user
    order by fee_in_usd desc
    limit 10

    Run a query to Download Data