0xaimanNew Address Activated, Yearly
    Updated 2024-02-15
    select * ,
    SUM(n_address) OVER (ORDER BY year ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as cumulative_count
    from
    (SELECT
    TO_VARCHAR(DATE_TRUNC('YEAR', first_tx_date), 'YYYY') AS year,
    COUNT(DISTINCT signer) as n_address
    FROM
    solana.core.ez_signers
    GROUP BY 1
    ORDER BY 1)


    Last run: about 1 year ago
    YEAR
    N_ADDRESS
    CUMULATIVE_COUNT
    1
    202071476797147679
    2
    2021215437232222584911
    3
    2022308850245531435156
    4
    202389883633621318789
    5
    202432929502654248291
    5
    140B
    61s