alirsOsmo-WB-09-A-1
Updated 2022-10-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with holder as (select address, sum(balance/ pow(10,decimal)) as balance
from osmosis.core.fact_daily_balances
where CURRENCY = 'uosmo'
and date = '2022-10-24'
group by 1
order by balance desc NULLS LAST
limit 100),
rank as (select
address,balance,
row_number() over (order by balance desc) as ranking
from holder)
select
address,balance,ranking,
sum(balance) over (order by ranking asc) as holder_Growth
from rank
order by holder_Growth desc NULLS LAST
Run a query to Download Data