SELECT

DATE_TRUNC('{{time_granularity}}', last_activity_block_timestamp) AS date,

COUNT(DISTINCT user_address) AS daily_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,

daily_unique_address_count,

SUM(daily_unique_address_count) OVER (ORDER BY date) AS cumulative_unique_address_count

FROM daily_holders

ORDER BY date DESC;