flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Average osmosis per wallet Right now
rezarwz
Average osmosis per wallet Right now
Updated 2022-10-27
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
SELECT
avg
(
BALANCE
/
pow
(
10
,
decimal
)
)
as
average
,
BALANCE_TYPE
FROM
osmosis
.
core
.
fact_daily_balances
WHERE
date
=
CURRENT_DATE
-
1
and
CURRENCY
=
'uosmo'
and
balance_type
in
(
'staked'
,
'liquid'
)
GROUP
BY
2
Results
Run a query to Download Data