zakkisyedHolder Count over time
Updated 2023-05-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH daily_holders AS (
SELECT
DATE(block_timestamp) AS date,
symbol,
COUNT(DISTINCT (CASE WHEN from_address = to_address THEN NULL ELSE from_address END), to_address) AS holder_count
FROM ETHEREUM.core.ez_token_transfers
WHERE contract_address IN (
'0x6982508145454ce325ddbe47a25d4ec3d2311933',
'0x6b89b97169a797d94f057f4a0b01e2ca303155e4',
'0x5026f006b85729a8b14553fae6af249ad16c9aab',
'0x2f573070e6090b3264fe707e2c9f201716f123c7'
)
GROUP BY date, symbol
)
SELECT
date,
symbol,
holder_count,
SUM(holder_count) OVER (PARTITION BY symbol ORDER BY date) AS cumulative_holder_count
FROM daily_holders
ORDER BY date, symbol;
Run a query to Download Data