freemartianTop 10 Algo Wallets
Updated 2022-11-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
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