flipside

    Total number of Ethereum users according to their number of months of activeness
    nsa2000Total number of Ethereum users according to their number of months of activeness
    Updated 2022-12-19
    --credit to jackguy
    SELECT
    active_months,
    count(*) as users
    FROM (
    SELECT
    from_address,
    count(DISTINCT date_trunc('month', block_timestamp)) as active_months
    FROM ethereum.core.fact_transactions
    GROUP BY 1
    )
    GROUP BY 1
    Run a query to Download Data