zakkisyedMonthly Holders
    Updated 2023-06-30


    WITH monthly_holders AS (
    SELECT
    DATE_TRUNC('{{time_granularity}}', last_activity_block_timestamp) AS date,
    COUNT(DISTINCT user_address) AS monthly_unique_address_count
    FROM ethereum.core.ez_current_balances
    WHERE contract_address = '0x5a3e6a77ba2f983ec0d371ea3b475f8bc0811ad5'
    AND current_bal > 0
    GROUP BY DATE_TRUNC('{{time_granularity}}', last_activity_block_timestamp)

    )
    SELECT
    date,
    monthly_unique_address_count,
    SUM(monthly_unique_address_count) OVER (ORDER BY date) AS cumulative_unique_address_count
    FROM monthly_holders
    ORDER BY date DESC;


    Run a query to Download Data