nitsAlgorand Governance Period 1 Breakdown By Committed Amount
Updated 2022-01-11
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
›
⌄
WITH exi as(SELECT distinct address as users_
from algorand.account
where account_closed='FALSE'),
gov1 as (select *
from algorand.payment_transaction
where receiver = 'GULDQIEZ2CUPBSHKXRWUW7X3LCYL44AI5GGSHHOQDGKJAZ2OANZJ43S72U')
, all_votes as
(select *, case when contains(vote, 'a') then 'a' else 'b' end as voted_at
from
(select * ,substring(TRY_BASE64_DECODE_STRING(tx_message:txn:note),10 ) as vote from gov1
where not contains(vote, 'com') and vote is not NULL)
where contains(vote, '3'))
(select sender, committed_amount, voted_at from
(select sender as s, committed_amount from
(select *,substring(vote,8) as xyz,substring(xyz,1,len(xyz)-1) as committed_amount
from
(select * ,substring(TRY_BASE64_DECODE_STRING(tx_message:txn:note),10 ) as vote from gov1
where contains(vote, 'com'))))
inner join all_votes
on sender =s )
-- group by sender
Run a query to Download Data