ramishoowUntitled Query
Updated 2022-10-26
9
1
2
3
4
5
›
⌄
with ramishoow as ( select address,sum(balance/pow(10,decimal)) as balance_
from osmosis.core.fact_daily_balances where currency = 'uosmo' and date=CURRENT_DATE
group by address ) select *, row_number() over (order by balance_ desc) as rn,
concat(lpad(rn,3,'0') , ' - ', address) as "adress wallet" from ramishoow
order by balance_ desc limit 100
Run a query to Download Data