TOTAL_STAKERS | TOTAL_STAKES | TOTAL_SOL_STAKED | TOTAL_SOL_UNSTAKED | TOTAL_MSOL_MINTED | TOTAL_REWARDS_CLAIMED | CURRENTLY_TOTAL_STAKED_SOL | TOTAL_SOL_STAKED_30D | TOTAL_SOL_UNSTAKED_30D | |
|---|---|---|---|---|---|---|---|---|---|
1 | 227247 | 11825240 | 43877013.6545461 | 28980914.6909912 | 32550886.3808013 | 32538519.2090062 | 14896098.9635549 | 783852.588682508 | 777912.732034297 |
feyikemiOverview
Updated 2025-04-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
COUNT(DISTINCT CASE WHEN action_type in ('deposit', 'depositStakeAccount') THEN PROVIDER_ADDRESS END) AS total_stakers,
COUNT(DISTINCT CASE WHEN action_type in ('deposit', 'depositStakeAccount') THEN TX_ID END) AS total_stakes,
SUM(CASE WHEN action_type in ('deposit', 'depositStakeAccount') THEN DEPOSIT_AMOUNT END) AS total_sol_staked,
SUM(CASE WHEN action_type = 'orderUnstake' THEN MSOL_BURNED END) AS total_sol_unstaked,
SUM(CASE WHEN action_type in ('deposit', 'depositStakeAccount') THEN MSOL_MINTED END) AS total_msol_minted,
SUM(CASE WHEN action_type = 'claim' THEN CLAIM_AMOUNT END) AS total_rewards_claimed,
SUM(CASE WHEN action_type in ('deposit', 'depositStakeAccount') THEN DEPOSIT_AMOUNT END)
- SUM(CASE WHEN action_type = 'orderUnstake' THEN MSOL_BURNED END) AS currently_total_staked_sol,
SUM(CASE WHEN action_type in ('deposit', 'depositStakeAccount') AND block_timestamp::Date >= CURRENT_DATE - INTERVAL '30 days' THEN DEPOSIT_AMOUNT END)
AS total_sol_staked_30d,
SUM(CASE WHEN action_type = 'orderUnstake' AND block_timestamp::date >= CURRENT_DATE - INTERVAL '30 days' THEN MSOL_BURNED END)
AS total_sol_unstaked_30d
FROM solana.marinade.ez_liquid_staking_actions
Last run: about 1 month ago
1
138B
2s