zakkisyedWeekly Holders
Updated 2023-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
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