flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Optimism Monthly Active Users
fantasy
Optimism Monthly Active Users
Updated 2025-02-19
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
DATE_TRUNC
(
'month'
,
block_timestamp
)
AS
date
,
COUNT
(
DISTINCT
from_address
)
AS
monthly_active_users
FROM
optimism
.
core
.
fact_transactions
GROUP
BY
1
ORDER
BY
1
DESC
;
Results
QueryRunArchived: QueryRun has been archived