elsinaAmount OSMO top 100 wallet has
Updated 2022-10-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
›
⌄
with top_owner_start as (
select
Address,
sum(balance) as "Amount",
sum(1) OVER (ORDER BY "Amount" DESC) AS "Rank"
from
osmosis.core.fact_daily_balances
where
CURRENCY = 'uosmo' and Date = '2022-01-01' and BALANCE_TYPE='liquid'
group by ADDRESS
order by "Amount" desc
limit 100
),
top_owner_end as (
select
Address,
sum(balance) as "Amount",
sum(1) OVER (ORDER BY "Amount" DESC) AS "Rank"
from
osmosis.core.fact_daily_balances
where
CURRENCY = 'uosmo' and Date = '2022-10-25' and BALANCE_TYPE='liquid'
group by ADDRESS
order by "Amount" desc
limit 100
), osmo_in_top_100 as (
select
a."Rank" as "Ranks",
a.address as "02-01-01 Address",a."Amount"/1e6 as "02-01-01 Amount",
b.address as "02-10-25 Address",b."Amount"/1e6 as "02-10-25 Amount"
from top_owner_start as a join top_owner_end as b on a."Rank"=b."Rank"
) select sum("02-01-01 Amount"),sum("02-10-25 Amount") from osmo_in_top_100
Run a query to Download Data