MostlyData_Stake Program - Claims table
Updated 2025-03-14
999
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
›
⌄
-- forked from Share to claims @ https://flipsidecrypto.xyz/studio/queries/d5e39007-162f-4b12-ab40-b9251a4ef4dc
with simd_data as(
select
case
when {{simd}} = 228 then 's228VmFcuiEfroSCQTvEp1pYUownL7JRZMTd7FqHJVK'
when {{simd}} = 123 then 's1233un3oMnNWo4EuKsEjtV7QtXfimhybHMQP7GLPwM'
end as mint,
case
when {{simd}} = 228 then 'YESsimd228111111111111111111111111111111111'
when {{simd}} = 123 then 'YESsimd123111111111111111111111111111111111'
end as yesVote,
case
when {{simd}} = 228 then 'nosimd2281111111111111111111111111111111111'
when {{simd}} = 123 then 'nosimd1231111111111111111111111111111111111'
end as noVote,
case
when {{simd}} = 228 then 'ABSTA1Nsimd22811111111111111111111111111111'
when {{simd}} = 123 then 'ABSTA1Nsimd12311111111111111111111111111111'
end as abstainVote
)
,stake_data as(
select
*
from solana.gov.fact_stake_accounts
where
epoch = 752
and activation_epoch < 752
and active_stake > 0
and type_stake = 'delegated'
and authorized_staker in (
'mpa4abUkjQoAvPzREkh5Mo75hZhPFQ2FSH6w7dWKuQ5', -- SFDP
'6iQKfEyhr3bZMotVkW6beNZz5CPAkiwvgV2CTje9pVSS', -- Jito
QueryRunArchived: QueryRun has been archived