MLDZMNwb1
Updated 2022-10-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
BALANCE_TYPE,
sum(BALANCE/pow(10,DECIMAL)) as balance_osmo,
avg(BALANCE/pow(10,DECIMAL)) as avg_balance,
median(BALANCE/pow(10,DECIMAL)) as median_balance,
count(distinct address) as no_holders
from osmosis.core.fact_daily_balances
where currency='uosmo'
and DATE>='2022-01-01'
group by 1
Run a query to Download Data