CryptoIcicleTerra - 9. Governance Grind - 1.Participation Date
Updated 2023-01-23
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
›
⌄
-- As Terra 2.0 has expanded, we’ve seen a number of governance proposals come to light. Analyze the voting activity on the most recent 5 proposals.
-- Can you identify any trends or patterns in voting?
-- Bonus: Dig up and compare the text of 2 governance proposals. What do you think of these proposals? What would have made them stronger or likelier
-- to gather more votes? Do you have any improvements to recommend?
-- Basis of Payment:
-- To be eligible for payment.
-- The submission must be sent before the deadline indicated on the bounty page.
-- The submission must score a minimum of 6 points according to the Evaluation Criteria.
-- 💰 Payout
-- Rank Based Payout
-- Payout is in LUNA and xMETRIC, where the top eligible scorers are paid the amounts below.
-- The first, second and third place submissions must have a score of 10 or higher to be eligible for higher payout amounts.
-- If there are not enough eligible submissions for a category, remaining funds will either be paid to lower tier submissions
-- or reserved for future bounty programs. Final determination of payouts and rankings are at the discretion of the MetricsDAO Bounty Operations Team.
-- LUNA Payouts:
-- First place 400$ in LUNA
-- Second place 150$ in LUNA
-- Third place 150$ in LUNA
-- 4th through 15th place 75$ in LUNA
-- 16th through 21st place 50$ in LUNA
with
first_txns as (
select
tx_sender as tx_from,
min(block_timestamp) as first_txn
from terra.core.fact_transactions
group by tx_from
),
first_vote as (
select
voter,
min(block_timestamp) as first_vote
Run a query to Download Data