boomer77whale voting anchor
Updated 2022-02-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with raw as (select date, address, sum(balance) as LUNA_balance
from terra.daily_balances
where currency in ('LUNA')
and address not in ('terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh', 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6',
'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts', 'terra1jgp27m8fykex4e4jtt0l7ze8q528ux2lh4zh0f', 'terra1n6txvxn6cf02nn5slra57vs22mdsdy27kv2kuc',
'terra1swggaf7nw9p680q4lngs340ar24g3lecr7x9ed', 'terra13u66u4knssnws7n7w0n38mzyyqak5ygp807gyl')
and date = CURRENT_DATE - 1 and balance >= 10000
group by 1,2
order by luna_balance desc
)
select poll_id, count(distinct voter) as whale_vote, (whale_vote/1386)*100 as percentage_vote
from anchor.gov_vote
where voter in (select address from raw)
group by 1
order by 1 desc
Run a query to Download Data