0xBlackfishLiquid Stakers
Updated 2023-10-11
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
count(distinct s.signer) as signers
, count(distinct case when s.last_tx_date >= date('2022-10-01') then s.signer end) as signers_last_yr
from solana.core.ez_signers s
where
(
array_contains('MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'::variant,s.programs_used) or -- marinade
array_contains('CrX7kMhLC3cSsXJdT7JDgqrRVWGnUpX3gfEfxxU2NVLi'::variant,s.programs_used) or -- lido
array_contains('SPoo1Ku8WFXoNDMHPsrGSTSG1Y47rzgn41SLUNakuHy'::variant,s.programs_used) or -- jito, blaze, marginfi
array_contains('Stake11111111111111111111111111111111111111'::variant,s.programs_used)
)
Run a query to Download Data