flipside

    Optimism Monthly Active Users in %
    fantasyOptimism Monthly Active Users in %
    Updated 2025-02-19
    WITH user_growth AS (
    SELECT
    DATE_TRUNC('month', block_timestamp) AS month,
    COUNT(DISTINCT from_address) AS monthly_active_users
    FROM
    optimism.core.fact_transactions
    GROUP BY
    1
    ),
    growth_calc AS (
    SELECT
    month,
    monthly_active_users,
    LAG(monthly_active_users) OVER (
    ORDER BY
    month
    ) AS prev_users,
    ROUND (
    (
    monthly_active_users - LAG(monthly_active_users) OVER (
    ORDER BY
    month
    )
    ) / NULLIF(
    LAG(monthly_active_users) OVER (
    ORDER BY
    month
    ),
    0
    ) * 100,
    2
    ) AS percent_change,
    FROM
    user_growth
    )
    SELECT
    QueryRunArchived: QueryRun has been archived