Updated 2024-08-27
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
27
28
29
30
31
32
›
⌄
WITH active_holders_last_week AS (
SELECT
DISTINCT t.TX_FROM AS address
FROM
solana.core.fact_transfers t
WHERE
t.MINT = '3S8qX1MsMqRbiwKg2cQyx7nis1oHMgaCuc9c4VfvVdPN'
AND t.BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '7 days'
UNION
SELECT
DISTINCT t.TX_TO AS address
FROM
solana.core.fact_transfers t
WHERE
t.MINT = '3S8qX1MsMqRbiwKg2cQyx7nis1oHMgaCuc9c4VfvVdPN'
AND t.BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '7 days'
),
total_holders AS (
SELECT
DISTINCT b.ACCOUNT_ADDRESS AS address
FROM
solana.core.fact_token_balances b
WHERE
b.MINT = '3S8qX1MsMqRbiwKg2cQyx7nis1oHMgaCuc9c4VfvVdPN'
)
SELECT
(COUNT(active_holders_last_week.address) * 100.0 / COUNT(total_holders.address)) AS active_holders_percentage
FROM
active_holders_last_week, total_holders;
QueryRunArchived: QueryRun has been archived