DATE | UNIQUE_STAKERS | TOTAL_STAKERS | |
---|---|---|---|
1 | 2025-06-09 00:00:00.000 | 8 | 9604 |
2 | 2025-06-08 00:00:00.000 | 13 | 9596 |
3 | 2025-06-07 00:00:00.000 | 16 | 9583 |
4 | 2025-06-06 00:00:00.000 | 17 | 9567 |
5 | 2025-06-05 00:00:00.000 | 21 | 9550 |
6 | 2025-06-04 00:00:00.000 | 30 | 9529 |
7 | 2025-06-03 00:00:00.000 | 27 | 9499 |
8 | 2025-06-02 00:00:00.000 | 44 | 9472 |
9 | 2025-06-01 00:00:00.000 | 64 | 9428 |
10 | 2025-05-31 00:00:00.000 | 58 | 9364 |
11 | 2025-05-30 00:00:00.000 | 52 | 9306 |
12 | 2025-05-29 00:00:00.000 | 46 | 9254 |
13 | 2025-05-28 00:00:00.000 | 60 | 9208 |
14 | 2025-05-27 00:00:00.000 | 47 | 9148 |
15 | 2025-05-26 00:00:00.000 | 34 | 9101 |
16 | 2025-05-25 00:00:00.000 | 32 | 9067 |
17 | 2025-05-24 00:00:00.000 | 30 | 9035 |
18 | 2025-05-23 00:00:00.000 | 57 | 9005 |
19 | 2025-05-22 00:00:00.000 | 86 | 8948 |
20 | 2025-05-21 00:00:00.000 | 106 | 8862 |
permarydaily stakers
Updated 2025-05-07Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
date_trunc ('day', block_timestamp) as date,
COUNT(distinct tx_from) as unique_stakers,
sum(COUNT(distinct tx_from)) over (
order by
date_trunc ('day', block_timestamp) asc
) as total_stakers
from
solana.core.fact_transfers
where
mint = 'boopkpWqe68MSxLqBGogs8ZbUDN4GXaLhFwNP7mpP1i'
and tx_to = 'AeeTg7PWuQDQiVkZYP2teJRQdLQjmETBaJG3QUgWiEKs'
group by
1
order by
date desc
Last run: 25 days ago
41
1KB
20s