Tobi_1spatial-lavender
Updated 2024-09-18
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
26
›
⌄
WITH active_holders AS (
SELECT
TO_ADDRESS AS holder_address
FROM
base.core.ez_token_transfers
WHERE
CONTRACT_ADDRESS = '0x532f27101965dd16442e59d40670faf5ebb142e4'
AND BLOCK_TIMESTAMP >= DATEADD(DAY, -30, CURRENT_TIMESTAMP)
UNION -- Combine both receiving (TO_ADDRESS) and sending (FROM_ADDRESS)
SELECT
FROM_ADDRESS AS holder_address
FROM
base.core.ez_token_transfers
WHERE
CONTRACT_ADDRESS = '0x532f27101965dd16442e59d40670faf5ebb142e4'
AND BLOCK_TIMESTAMP >= DATEADD(DAY, -30, CURRENT_TIMESTAMP)
)
-- Count the distinct active holders in the last 30 days
SELECT
COUNT(DISTINCT holder_address) AS active_holders_last_30_days
FROM
active_holders;
QueryRunArchived: QueryRun has been archived