binhachonThe Road So Far, Mvmt. I: Validators - Governance distribution
Updated 2022-03-15
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 TERRA_ADDRESS AS (
SELECT
address,
sum(balance_usd) as wallet_balance,
CASE WHEN WALLET_BALANCE >= 0 AND WALLET_BALANCE <= 1000 THEN 'a. 0-1k'
WHEN WALLET_BALANCE > 1000 AND WALLET_BALANCE <= 10000 THEN 'b. 1-10k'
WHEN WALLET_BALANCE > 10000 AND WALLET_BALANCE <= 100000 THEN 'c. 10-100k'
WHEN WALLET_BALANCE > 100000 AND WALLET_BALANCE <= 1000000 THEN 'd. 100k to 1m'
WHEN WALLET_BALANCE > 1000000 AND WALLET_BALANCE <= 10000000 THEN 'e. 1m to 10m'
WHEN WALLET_BALANCE > 10000000 THEN 'f. Above 10m' ELSE NULL END AS wallet_tier
FROM terra.daily_balances
WHERE date in (select max(date) from terra.daily_balances)
GROUP BY 1
),
TERRA_STATION AS (
SELECT
voter,
count(proposal_id) as proposal_voted
FROM terra.gov_vote
GROUP BY 1
),
FINAL AS (
SELECT
address,
voter,
wallet_balance,
wallet_tier,
proposal_voted,
CASE WHEN proposal_voted IS NULL THEN 0 ELSE proposal_voted END AS proposal_voted2,
CASE WHEN proposal_voted IS NULL THEN 'Non-voters' WHEN proposal_voted > 0 THEN 'Voted Once' END AS proposal_voted3,
CASE WHEN proposal_voted IS NULL THEN '1. Non-voters'
WHEN proposal_voted = 1 THEN '2. Voted 1 Time'
WHEN proposal_voted >= 2 AND proposal_voted <= 5 THEN '3. Voted 2 to 5 Times'
WHEN proposal_voted > 5 AND proposal_voted <= 10 THEN '4. Voted 6 to 10 Times'
WHEN proposal_voted > 10 AND proposal_voted <= 20 THEN '5. Voted 10 to 20 times'
WHEN proposal_voted > 20 THEN '6. Voted 20 times or More' END AS proposal_voted4
Run a query to Download Data