TOTAL_STAKES | SUCCESSFUL_STAKES | FAILED_STAKES | DELEGATE_EVENTS | WITHDRAWAL_EVENTS | TOTAL_STAKERS | STAKE_ACCOUNTS | TOTAL_SIGNERS | |
|---|---|---|---|---|---|---|---|---|
1 | 16198883 | 14423873 | 1775010 | 2220894 | 11364676 | 722035 | 6922505 | 3742986 |
permarytotal stakes
Updated 2025-03-31
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
›
⌄
with unnest_signers as (
select
tx_id,
block_timestamp,
stake_authority,
stake_account,
event_type,
succeeded,
signer.value::STRING as signer
from solana.gov.ez_staking_lp_actions,
lateral flatten(input => signers) signer
)
select
count(distinct tx_id) AS total_stakes,
count(distinct case when succeeded = 'true' then tx_id end) as successful_stakes,
count(distinct case when succeeded = 'false' then tx_id end) as failed_stakes,
count(distinct case when event_type = 'delegate' then tx_id end) as delegate_events,
count(distinct case when event_type = 'withdraw' then tx_id end) as withdrawal_events,
count(distinct stake_authority) as total_stakers,
count(distinct stake_account) as stake_accounts,
count(distinct signer) as total_signers
from unnest_signers
where block_timestamp >= '2024-01-01'
and block_timestamp < '2025-01-01';
Last run: about 1 month ago
1
69B
18s