TX_FROM | VOTE_CHOICE | VOTES_CAST | |
|---|---|---|---|
1 | EvnRmnMrd69kFdbLMxWkTn1icZ7DCceRhvmb2SJXqDo4 | No | 5358191433004880 |
2 | 5pPRHniefFjkiaArbGX3Y8NUysJmQ9tMZg3FrFGwHzSm | No | 4121041700000000 |
3 | CW9C7HBwAMgqNdXkNgFg9Ujr3edR2Ab9ymEuQnVacd1A | No | 3737025621014250 |
4 | GoeW4aFK4dGoekJySgUynWDxBZiQJqm8GDAF4H53tDK9 | No | 3241244000000000 |
5 | Ninja1spj6n9t5hVYgF3PdnYz2PLnkt7rvaw3firmjs | No | 2517299330261340 |
6 | 46nbPAKDbvAFEDQxP16QR7dQHTMVGhnrN6gPs3FrSJzc | No | 2115283462986000 |
7 | 722RdWmHC5TGXBjTejzNjbc8xEiduVDLqZvoUGz6Xzbp | No | 1818924078692050 |
8 | UPSCQNqdbiaqrQou9X9y8mr43ZHzvoNpKC26Mo7GubF | No | 1611513454395610 |
9 | DWvDTSh3qfn88UoQTEKRV2JnLt5jtJAVoiCo3ivtMwXP | No | 1507360000000000 |
10 | GYx8kpp7SsRwtQEEsGQjAxb4hFMMmT91kFJuDeky3YGQ | No | 866493174118308 |
11 | PUmpKiNnSVAZ3w4KaFX6jKSjXUNHFShGkXbERo54xjb | No | 845178964359403 |
12 | Frog1Fks1AVN8ywFH3HTFeYojq6LQqoEPzgQFx2Kz5Ch | No | 668230157226188 |
13 | Diman2GphWLwECE3swjrAEAJniezpYLxK1edUydiDZau | No | 582104369840512 |
14 | Va1idLRtYEtVFJFsvz8vtt1uCJgea4Q1zi2Rh3eraJh | No | 560707597928446 |
15 | G1bLKfyNm7zsmmYEL9dyxBvMtxpFcwy2s84bHDj2ZFUY | No | 509496252198572 |
16 | BeaCHioStqCEFDFxKwAEzyrUPYxqnBPhJ98gDKeEiTPb | No | 462463354426749 |
17 | mint13XHZSSxtgHuTSM9qPDEJSbWktpmpM4CZxeLB8f | No | 394575220187498 |
18 | AMukCLCr52XxsEjXoDxKKxjNg4FpnsReXNaQx8aR6DJF | No | 392717034517525 |
19 | 8pyp3vfVPRziYdAYEyqkwytdBbdVbQmHqfQAVDcRV3w | No | 383676271262179 |
20 | 23SUe5fzmLws1M58AnGnvnUBRUKJmzCpnFQwv4M4b9Er | No | 365939385825270 |
Pine Analyticsdeveloping-chocolate copy copy copy
Updated 2025-03-13
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
›
⌄
select --*
tx_from,
case when tx_to like 'YESsimd228111111111111111111111111111111111' then 'Yes'
when tx_to like 'nosimd2281111111111111111111111111111111111' then 'No'
when tx_to like 'ABSTA1Nsimd22811111111111111111111111111111' then 'Abstain' end as vote_choice,
sum(AMOUNT) as votes_cast
from solana.core.fact_transfers
where mint like 's228VmFcuiEfroSCQTvEp1pYUownL7JRZMTd7FqHJVK'
and tx_to in (
-- 'YESsimd228111111111111111111111111111111111'
'nosimd2281111111111111111111111111111111111'
-- 'ABSTA1Nsimd22811111111111111111111111111111'
)
group by 1,2
order by 3 desc
--limit 1000
Last run: 22 days ago
...
460
31KB
7s