marquSIMD 123 - Vote yes pass
Updated 2025-03-14
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
vote_txs as (
select
block_timestamp
, block_id
, tx_id
, tx_from
, amount
, case
when tx_to = 'YESsimd123111111111111111111111111111111111' then 'yes'
when tx_to = 'nosimd1231111111111111111111111111111111111' then 'no'
else 'abstain'
end as vote_option
from solana.core.fact_transfers
where mint = 's1233un3oMnNWo4EuKsEjtV7QtXfimhybHMQP7GLPwM'
and tx_to in (
'YESsimd123111111111111111111111111111111111'
, 'nosimd1231111111111111111111111111111111111'
)
and fact_transfers.block_id >= 325296000 -- start Epoch 753
and fact_transfers.block_id <= 326591999 -- end Epoch 755
)
select
sum(amount) as cast_all
, sum(case when vote_option = 'yes' then amount else 0 end) as cast_yes
, cast_yes / cast_all * 100 as cast_yes_pct
from vote_txs