Solana Stake Accounts

MostlyData_Solana Stake Accounts

Updated 2025-02-12

with stake_data as(

select

credits_observed - lag(credits_observed) over (

partition by stake_pubkey

order by epoch

) as credits_diff

from solana.gov.fact_stake_accounts

where

(vote_pubkey = 'Chorus6Kis8tFHA7AowrPMcRJk3LbApHTYpgSNXzY5KE'

or vote_pubkey = 'CatzoSMUkTRidT5DwBxAC2pEtnwMBTpkCepHkFgZDiqb')

and active_stake > pow(10,-4)

)

select *, credits_diff / 6912000 * 100 as eff from stake_data

where

--epoch > 720

epoch = 740

--and credits_diff / 6912000 < 0.9

and (stake_pubkey = '8SWy8cePppycfhhcrnfBEBNqTZTpNRNGQARbgWaYeKjb'

or stake_pubkey = 'EmutJdbKJ55hUyth15bar8ZxDCchR44udAXWYg9eLLDL')

Last run: 2 months ago

	EPOCH	STAKE_PUBKEY	VOTE_PUBKEY	AUTHORIZED_STAKER	AUTHORIZED_WITHDRAWER	LOCKUP	RENT_EXEMPT_RESERVE	CREDITS_OBSERVED	ACTIVATION_EPOCH	DEACTIVATION_EPOCH	ACTIVE_STAKE	WARMUP_COOLDOWN_RATE	TYPE_STAKE	PROGRAM	ACCOUNT_SOL	RENT_EPOCH	FACT_STAKE_ACCOUNTS_ID	INSERTED_TIMESTAMP	MODIFIED_TIMESTAMP	CREDITS_DIFF	EFF
1	740	8SWy8cePppycfhhcrnfBEBNqTZTpNRNGQARbgWaYeKjb	Chorus6Kis8tFHA7AowrPMcRJk3LbApHTYpgSNXzY5KE	5LJ93G4SQh9GiewTQJNAu6X9sQ1VVyrpCAgbQsRSgn22	5LJ93G4SQh9GiewTQJNAu6X9sQ1VVyrpCAgbQsRSgn22	{"custodian":"Mc5XB47H3DKJHym5RLa9mPzWv5snERsF3KNv5AauXK8","epoch":0,"un...	2282880	513055129	147	18446744073709552000	173794.821617392	0	delegated	stake	174934.765667362	18446744073709552000	51a5c9117b50badb671df6f7259afef2	2025-02-11 02:40:38.196	2025-02-12 02:40:08.516	6878326	99.5128
2	740	EmutJdbKJ55hUyth15bar8ZxDCchR44udAXWYg9eLLDL	CatzoSMUkTRidT5DwBxAC2pEtnwMBTpkCepHkFgZDiqb	EMjuABxELpYWYEwjkKmQKBNCwdaFAy4QYAs6W9bDQDNw	EMjuABxELpYWYEwjkKmQKBNCwdaFAy4QYAs6W9bDQDNw	{"custodian":"11111111111111111111111111111111","epoch":0,"unixTimestamp...	2282880	295723391	596	18446744073709552000	2863297.47246289	0	delegated	stake	2863667.72618333	18446744073709552000	62288706c088929dcd5ee3b665feaaec	2025-02-11 02:40:38.196	2025-02-12 02:40:08.516	6886715	99.6342

1009B

flipside