flipside

    Active Addresses per Month
    jorshimayorActive Addresses per Month
    Updated 2024-08-13
    SELECT
    DATE_TRUNC('month', block_timestamp) AS month,
    COUNT(DISTINCT tx_from) AS active_addresses
    FROM
    sei.core.fact_transactions
    WHERE
    block_timestamp >= DATEADD(year, -2, CURRENT_DATE)
    GROUP BY
    month
    ORDER BY
    month;
    QueryRunArchived: QueryRun has been archived