EVENT_NAME | AMOUNT_BUCKET | TX_COUNT | TOTAL_MSOL | TOTAL_USD | |
|---|---|---|---|---|---|
1 | Stake | 0-10 | 7575984 | 538096.853076291 | 60094416.4402355 |
2 | Stake | 10-50 | 48636 | 1132522.20962908 | 127653976.853368 |
3 | Stake | 100+ | 4187619 | 29884748.4245432 | 3426406081.16176 |
4 | Stake | 50-100 | 13789 | 1033838.45914773 | 136321501.155361 |
5 | Unstake | 0-10 | 11866 | 26051.67858922 | 3294514.25212525 |
6 | Unstake | 10-50 | 4860 | 119079.287420114 | 14656009.3933358 |
7 | Unstake | 100+ | 10458 | 28649700.1707142 | 3252670873.71339 |
8 | Unstake | 50-100 | 2715 | 205102.054759055 | 25980826.7957894 |
Afonso_DiazTransaction Size Distribution
Updated 2025-04-22
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
pricet as (
select
hour::date as date,
symbol,
avg(price) as token_price_usd
from
crosschain.price.ez_prices_hourly
where
token_address in ('mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So', 'So11111111111111111111111111111111111111112')
and blockchain = 'solana'
group by 1, 2
),
main as (
select
tx_id,
block_timestamp,
provider_address as user,
msol_minted as amount,
msol_minted * token_price_usd as amount_usd,
'Stake' as event_name
from
solana.marinade.ez_liquid_staking_actions
left join
pricet on block_timestamp::date = date and symbol = 'MSOL'
where
action_type in ('deposit', 'depositStakeAccount')
union all
select
tx_id,
block_timestamp,
provider_address as user,
Last run: about 1 month ago
8
471B
17s