PROVIDER_ADDRESS | TOTAL_MINTED | TOTAL_BURNED | BURN_PERCENTAGE | |
|---|---|---|---|---|
1 | 6ztbH6ghb5XN1rq1eMuQXn9xCgcWktC13JdKkMsATRvv | 193302.436441286 | 108235.654607892 | 55.992907591 |
2 | 75jTZDE78xpBJokeB2BcimRNY5BZ7U45bWhpgUrTzWZC | 161056.212023675 | 0 | 0 |
3 | 9tMYeexrdB4oZzYfhdwJ8xuANYZL8KoTWc2HAUtNoGK5 | 99716.58677505 | 0 | 0 |
4 | 6RYVQDmjx9MGRNdzATiYTMMLfDPXxteWzPYKgcHBQQF4 | 90595.554954461 | 0 | 0 |
5 | 4xDsmeTWPNjgSVSS1VTfzFq3iHZhp77ffPkAmkZkdu71 | 81478.045325998 | 0 | 0 |
6 | CapuXNQoDviLvU1PxFiizLgPNQCxrsag1uMeyk6zLVps | 78639.16155544 | 0 | 0 |
7 | 6HUNuXf8H8iVyMAUhB4SNgS4jjkgLvbEsbxrqBnHV4kF | 74270.763431673 | 0 | 0 |
8 | 6U91aKa8pmMxkJwBCfPTmUEfZi6dHe7DcFq2ALvB2tbB | 59092.084599812 | 0 | 0 |
9 | GGztQqQ6pCPaJQnNpXBgELr5cs3WwDakRbh1iEMzjgSJ | 58977.892094357 | 0 | 0 |
10 | 9nnLbotNTcUhvbrsA6Mdkx45Sm82G35zo28AqUvjExn8 | 58244.461815445 | 0 | 0 |
11 | 2MFoS3MPtvyQ4Wh4M9pdfPjz6UhVoNbFbGJAskCPCj3h | 55222.948902205 | 0 | 0 |
12 | 585B7BBbcmYLksPNH7uH3L9wujpgb1MRcKfEEocXQi9W | 51189.331709016 | 18224.528767726 | 35.602201004 |
MasiTop Movemnets
Updated 2025-02-19
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
33
34
35
36
›
⌄
with tb1 as (
select
provider_address,
sum(msol_minted) as total_minted
from solana.marinade.ez_liquid_staking_actions
where action_type in ('depositStakeAccount', 'deposit')
and block_timestamp >= current_date - 90
group by 1
),
tb2 as (
select
provider_address,
sum(msol_burned) as total_burned
from solana.marinade.ez_liquid_staking_actions
where action_type = 'orderUnstake'
and block_timestamp >= current_date - 90
group by 1
),
tb3 as (
select
t1.provider_address,
t1.total_minted,
coalesce(t2.total_burned, 0) as total_burned,
coalesce(t2.total_burned, 0) / nullif(t1.total_minted, 0) * 100 as burn_percentage
from tb1 t1
left join tb2 t2 on t1.provider_address = t2.provider_address
),
tb4 as (
select
provider_address,
total_minted,
total_burned,
burn_percentage
Last run: about 2 months ago
12
880B
3s