zakkisyedWeekly Holders
    Updated 2023-07-07



    WITH weekly_holders AS (
    SELECT
    DATE_TRUNC('{{time_granularity}}', last_activity_block_timestamp) AS date,
    COUNT(DISTINCT user_address) AS weekly_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,
    weekly_unique_address_count,
    SUM(weekly_unique_address_count) OVER (ORDER BY date) AS cumulative_unique_address_count
    FROM weekly_holders
    ORDER BY date DESC;



    Run a query to Download Data