Tobi_1outside-beige
Updated 2024-09-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
⌄
WITH holders_last_30_days AS (
SELECT
TO_ADDRESS,
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day
FROM base.core.fact_token_transfers;
WHERE CONTRACT_ADDRESS = '0x532f27101965dd16442e59d40670faf5ebb142e4'
AND BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP())
GROUP BY TO_ADDRESS, day
)
SELECT
day,
COUNT(DISTINCT TO_ADDRESS) AS unique_holders
FROM holders_last_30_days
GROUP BY day
ORDER BY day ASC;
QueryRunArchived: QueryRun has been archived