flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
daily variation of the average amount of osmosis balance per wallet and Osmosis Holders
nsa2000
daily variation of the average amount of osmosis balance per wallet and Osmosis Holders
Updated 2022-10-27
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
date
,
avg
(
balance
/
1e6
)
as
average
,
median
(
balance
/
1e6
)
as
median
,
count
(
distinct
address
)
as
"Daily Osmo Holders"
from
osmosis
.
core
.
fact_daily_balances
where
CURRENCY
=
'uosmo'
and
balance
>
0
and
date
>
'2022-01-01'
::
DATE
group
by
DATE
Results
Run a query to Download Data