flipside

    AVG MONTHLY BASE USERS
    AnalyticSagesAVG MONTHLY BASE USERS
    Updated 2024-04-05
    WITH Users AS (
    SELECT
    Date_trunc('month', block_timestamp) AS Month,
    COUNT(DISTINCT origin_from_address) AS Monthly_Active_Users
    FROM
    base.defi.ez_dex_swaps
    GROUP BY 1
    )

    SELECT
    AVG(Monthly_Active_Users) AS Average_Monthly_Users
    FROM
    Users
    QueryRunArchived: QueryRun has been archived