ramishoowUntitled Query
    Updated 2022-10-26
    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