flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
BECOME A PARTNER
flipside
UntThe number of wallets that keep each Token.itled Query
rezarwz
UntThe number of wallets that keep each Token.itled Query
Updated 2022-10-27
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
SELECT
date
,
PROJECT_NAME
,
count
(
DISTINCT
bl
.
address
)
as
number_of_wallets
FROM
osmosis
.
core
.
fact_daily_balances
bl
inner
join
osmosis
.
core
.
dim_labels
lb
on
lb
.
ADDRESS
=
bl
.
CURRENCY
GROUP
by
1
,
2
Results
Run a query to Download Data