flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
BECOME A PARTNER
flipside
Daily transacted distinct wallets
ML6
Daily transacted distinct wallets
Updated 2022-08-08
Copy Reference
Fork
9
1
2
3
4
›
⌄
select
count
(
distinct
FROM_ADDRESS
)
as
wallets
,
to_date
(
BLOCK_TIMESTAMP
)
from
optimism
.
core
.
fact_transactions
where
to_date
(
BLOCK_TIMESTAMP
)
>
'2022-06-30'
and
to_date
(
BLOCK_TIMESTAMP
)
<=
'2022-07-31'
and
STATUS
=
'SUCCESS'
group
by
2
Results
Run a query to Download Data