flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
balance & Holder
0xHaM-d
balance & Holder
Updated 2022-10-25
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
balance_type
,
COUNT
(
DISTINCT
address
)
as
holder
,
sum
(
balance
/
pow
(
10
,
decimal
)
)
as
balanc
from
osmosis
.
core
.
fact_daily_balances
where
currency
=
'uosmo'
and
date
=
(
select
max
(
date
)
from
osmosis
.
core
.
fact_daily_balances
)
group
by
1
Results
Run a query to Download Data