strawbettyWhale Voters
Updated 2022-02-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with whales as (
SELECT DISTINCT(address) as unique_address, sum(balance_usd) as sum
FROM terra.daily_balances
WHERE date > CURRENT_DATE - 1
group BY unique_address
ORDER BY 2 DESC
LIMIT 1000
), whales_voted as (
SELECT DISTINCT(voter)
FROM terra.gov_vote
WHERE voter IN (SELECT unique_address FROM whales)
AND date_trunc('day',block_timestamp) > CURRENT_DATE- 90
)
SELECT
'Vote Compare', COUNT(*) as whales_voted, (SELECT COUNT(*) as whales_count from whales) as total_whales,
(whales_voted/total_whales)*100 as voted_percentage
from whales_voted
Run a query to Download Data