MONTHLY | TYPE | NUM_USERS | VOLUME | VOLUME_USD | CUM_VOLUME | CUM_VOLUME_USD | AVERAGE_VOLUME_USD | MEDIAN_VOLUME_USD | |
|---|---|---|---|---|---|---|---|---|---|
1 | 2021-12-01 00:00:00.000 | Unstake | 367 | -179087.159212486 | -21137904.27 | 6021183.45498408 | 17023623.61 | -73908.756188811 | -3236.09 |
2 | 2024-06-01 00:00:00.000 | Stake | 4444 | 163805.582797623 | 22950306.87 | 214265.987027532 | -432615171.02 | 3310.29956296 | 130.95 |
3 | 2023-02-01 00:00:00.000 | Stake | 524 | 97232.177612451 | 2241958.72 | 2781197.44540036 | -214832113.45 | 2264.604767677 | 83.715 |
4 | 2022-11-01 00:00:00.000 | Unstake | 560 | -786131.315014571 | -12612845.32 | 3263161.43072121 | -205502746.13 | -12936.251610256 | -646.67 |
5 | 2021-08-01 00:00:00.000 | Stake | 1374 | 630611.5207449 | 602644.285307462 | ||||
6 | 2023-06-01 00:00:00.000 | Unstake | 73 | -183309.193642953 | -3336689.61 | 2168893.06396005 | -231741341.04 | -29014.69226087 | -1711 |
7 | 2024-09-01 00:00:00.000 | Unstake | 155 | -216572.022005405 | -29855259.56 | -411312.619614726 | -527484750.45 | -63521.828851064 | -12224.08 |
8 | 2024-05-01 00:00:00.000 | Stake | 703 | 47922.66016331 | 7363741.44 | 510565.966834405 | -386211355.42 | 5612.607804878 | 173.215 |
9 | 2021-11-01 00:00:00.000 | Stake | 5075 | 1203527.5083438 | 5393285.0577044 | ||||
10 | 2024-11-01 00:00:00.000 | Stake | 846 | 226094.025092184 | 48094993.36 | 52256.752552003 | -448590116.12 | 16763.678410596 | 1936.14 |
11 | 2024-10-01 00:00:00.000 | Stake | 978 | 547506.277460571 | 90467837.81 | 9382.682469606 | -456756425.52 | 18599.473233964 | 1856.49 |
12 | 2022-03-01 00:00:00.000 | Stake | 2017 | 557065.529707486 | 50807672.8 | 4359000.25320641 | -190193977.34 | 13584.939251337 | 250.69 |
13 | 2023-04-01 00:00:00.000 | Unstake | 104 | -1595339.51229307 | -34546521.69 | 1113589.18698809 | -250705928.78 | -146383.566483051 | -528.12 |
14 | 2022-01-01 00:00:00.000 | Unstake | 458 | -1725439.92726885 | -237652350.5 | 4986031.63844984 | -124334340.96 | -288763.487849332 | -5417.79 |
15 | 2023-11-01 00:00:00.000 | Stake | 2328 | 490012.009841894 | 26016821.44 | 1211574.18953524 | -250312927.69 | 3943.735249356 | 153.48 |
16 | 2024-08-01 00:00:00.000 | Stake | 807 | 261815.399930442 | 37989924.71 | -309863.334791452 | -513662913.63 | 14096.447016698 | 1756.34 |
17 | 2025-01-01 00:00:00.000 | Stake | 777 | 449151.424363829 | 95752639.84 | 447732.016505617 | -361803330.32 | 34197.371371429 | 3257.69 |
18 | 2023-10-01 00:00:00.000 | Stake | 854 | 335142.573675074 | 9276804.49 | 1167218.09755134 | -252243015.4 | 3656.604055972 | 87.53 |
19 | 2023-02-01 00:00:00.000 | Unstake | 121 | -175723.462019038 | -4074705.66 | 2781197.44540036 | -214832113.45 | -18272.222690583 | -4449.44 |
20 | 2022-10-01 00:00:00.000 | Unstake | 124 | -1692650.05667321 | -50071541.72 | 3867311.24921155 | -196610914.82 | -227597.916909091 | -1378.82 |
0xHaM-d[MSOL Holders activity] - iquid staking over time copy
Updated 2025-02-18
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 msol_holders as (
select owner wallet,
balance
from (
select owner,
balance,
row_number() over (partition by owner order by BLOCK_TIMESTAMP desc) as rn
from solana.core.fact_token_balances
where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey'
and balance > 1e-9
) ranked
where rn = 1
)
,
txns as (
with stake_txns as (
select
BLOCK_TIMESTAMP ::Date date ,
tx_id ,
PROVIDER_ADDRESS user ,
DEPOSIT_AMOUNT amount ,
DEPOSIT_AMOUNT_USD amount_usd ,
'Stake' type
from solana.marinade.ez_liquid_staking_actions
right join msol_holders on PROVIDER_ADDRESS = wallet
where ACTION_TYPE in ('depositStakeAccount', 'deposit')
) ,
unstake_txns as (
select BLOCK_TIMESTAMP ::Date date ,
tx_id ,
PROVIDER_ADDRESS user ,
-CLAIM_AMOUNT amount ,
-CLAIM_AMOUNT_USD amount_usd ,
'Unstake' type
from solana.marinade.ez_liquid_staking_actions
right join msol_holders on PROVIDER_ADDRESS = wallet
Last run: about 1 month ago
86
10KB
172s