DT | NEW_ADDRESS | CUM_OWNERS | |
|---|---|---|---|
1 | 2024-03-29 00:00:00.000 | 125 | 98794 |
2 | 2023-01-20 00:00:00.000 | 35 | 44628 |
3 | 2022-02-03 00:00:00.000 | 121 | 24128 |
4 | 2022-08-09 00:00:00.000 | 48 | 39322 |
5 | 2024-03-10 00:00:00.000 | 161 | 95605 |
6 | 2023-02-10 00:00:00.000 | 34 | 45250 |
7 | 2025-02-21 00:00:00.000 | 33 | 128197 |
8 | 2023-01-10 00:00:00.000 | 50 | 44245 |
9 | 2022-01-24 00:00:00.000 | 60 | 23526 |
10 | 2024-12-29 00:00:00.000 | 41 | 124516 |
11 | 2023-03-13 00:00:00.000 | 27 | 45875 |
12 | 2025-03-12 00:00:00.000 | 32 | 131558 |
13 | 2022-09-21 00:00:00.000 | 26 | 40478 |
14 | 2024-10-26 00:00:00.000 | 44 | 119714 |
15 | 2022-10-25 00:00:00.000 | 21 | 41400 |
16 | 2025-02-03 00:00:00.000 | 72 | 126831 |
17 | 2022-12-27 00:00:00.000 | 30 | 43732 |
18 | 2024-12-24 00:00:00.000 | 44 | 124290 |
19 | 2023-07-02 00:00:00.000 | 34 | 54549 |
20 | 2023-02-23 00:00:00.000 | 16 | 45504 |
bwr1Solana - Marinade - MNDE Cumulative Holders
Updated 2025-04-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with first_encounter as (
SELECT
date(block_timestamp) as dt
, owner
FROM solana.core.fact_token_balances
where mint like 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey'
and balance > 0.005
AND succeeded
and block_timestamp > '2020-01-01'::timestamp
qualify row_number() over (partition by owner order by block_timestamp) = 1
)
select dt, count(owner) as new_address, sum(count(owner)) over (order by dt) as cum_owners
from first_encounter
group by dt
Last run: 3 months ago
...
1277
47KB
296s