Funding Request: UMA DAO Dune Analytics Dashboard

Author: Henrystats

Summary

Proposal to request funding of 1,500 $UMA tokens to build a Dune analytic dashboard for UMA DAO.

Description

High level scope: I’m proposing funding to create a Dune analytic dashboard that will allow UMA DAO community members to track UMA Governance data, UMA DAO treasury.

There’s a lot of rich data that’ll be useful to everyone in the UMA DAO ecosystem.

Detailed specifications

Contracts

DAO Treasury Metrics

  • $UMA Tokens Balance (Counter)
  • $UMA DAO Assets (Table)
  • $UMA DAO Assets USD Value (Counter)
  • $UMA DAO Assets USD Value (Pie Chart)
  • $UMA DAO treasury transactions

$UMA Tokenomics

  • $UMA Daily Price (Bar Chart)
  • Total supply (Counter)
  • Market cap (Counter)
  • Latest $UMA price (Counter)
  • Token holders count Ethereum (Counter)
  • Token holders count Polygon (Counter)
  • Token holders count Ethereum last 90days (Graph, results include change per day)
  • Token holders count Polygon last 90days (Graph, results include change per day)
  • Top 20 $UMA token holders including their balances in USD (Table)
  • Top 10 $UMA token holders with label (Pie chart, include sum of others)
  • Last 100 $UMA Transfers in to a top 20 $UMA token holder (Table)
  • Last 100 $UMA Transfers out from a top 20 $UMA token holder (Table)

$UMA Voting Information

  • Voting APY of the last 30 votes (Bar chart)
  • Voting APY SUM, last 3 months, last 6 months, last year (Counters)
  • $UMA tokens earned on 1,000 $UMA, last 3 months, last 6 months, last year (Counters)
  • No of unique voters all votes including count of new voters (Bar, Line chart)
  • Unique voters (Counter)
  • Total historical UMA Votes (Counter)
  • Total DVM Data requests (Counter)
  • ACROSS V2 Data requests (Counter and Table)
  • ACROSS V1 Data requests (Counter and Table)
  • Polymarket Data requests (Counter and Table)
  • $UMA voting results (Table)
  • $UMA Voting results sorted by contentiousness (Table)
  • Last 30 votes UMA voters count (Bar chart)
  • Last 30 votes $UMA tokens sum (Bar chart)
  • Last 30 votes UMA voters count, majority vs minority (Bar chart)
  • Last 30 votes $UMA tokens sum majority vs minority (Bar chart)
  • Top $UMA Vote participants and the number of votes they participated in, includes balance of $UMA tokens (Table)
  • Store contract assets (Table)
  • Store contract USD SUM (Counter)

Calculators

  • Query the addresses that participated in a vote
  • Query the addresses that participated in a vote (including what they voted)
  • Query the addresses that voted with the majority in a vote
  • Query the addresses that voted with the Minority in a vote
  • Query the results of a vote
  • Query the votes an address participated in and what they voted
  • Query how much $UMA you’d earn in the past 3 months, 6 months and 1yr by entering your $UMA token balance.

Delivery

~ 1 - 2 weeks

SQL lines will be submitted as a pr to UMA’s github repo.

Total Budget Requested

1,500 UMA

1, 500 UMA will be sent into an Administrative Multisig managed by Risk labs.

0x049355e4380f8DB88Cb8a6ec0426B1a1A3560c67

1,000 UMA will be sent to

0xe5fF2C80759db9408dC9fD22b155b851Cd5aAA94

at the completion of the dashboard. Remaining 500 UMA will be held by Risk labs.

I will keep updating the dashboard based on changes to contracts and to reflect feedback and requests. After 6 months from when this proposal passes, I’ll request the additional 500 UMA tokens.

Some example Dune analytics dashboard here on layer3.xyz

Cost is usually between 2,500$ - 3000$

Posting this as an UMA DAO member

Edit on 10, July '22
Included the text `Posting this as an UMA DAO member for clarity.

Edit on 13, July '22
Included Risk labs address and myaddress
Included 5 day voting poll.

  • For
  • Against

0 voters

8 Likes

Hey Henry-

Thanks for posting a proposal. A couple of quick thoughts/feedback-

1.) I know you have previously been compensated, employed, or affiliated with UMA, Risk Labs, and the SuperUMAns. In both the UMA discord as well as here you are listed as an admin or part of the team. I think it may be beneficial that along with the proposal you clarify if you are just posting and acting as a DAO member or if there is any overlap with other roles or renumeration. I don’t think there is, but would be good to confirm.

2.) I think the dashboard and metrics are well thought out and do think the tool would have utility for the UMA DAO as well as the amount being reasonable. I am supportive of the dashboard being built and the compensation for it.

3.) My main feedback for this proposal (and future similar ones in nature) is that I would like them to be structured more like a bounty for anyone to try and participate in and be compensated for. I think this would allow for some competition and potentially heightened quality of the dashboard in this case. I recognize you likely have put in some prep work, but after seeing this commentary in the discord that you are 95% complete with the tool (Discord), I have hesitation funding this directly to you instead of opening it up to anyone wanting to try to do this as more of a bounty structure.

Thanks.

-EA

Hey @EAsports, thank you for your feedback.

  1. I agree, thank you, I’ve edited the proposal and included that.

  2. I agree as well, hehe.

  3. I understand why it being structured in a bounty format with multiple people allowed to participate would be great and I think for similar proposals in the future we should keep it this way.

While I mentioned that I’m 95% complete with the tool, I’d like to also mention that I have spent about a week and half building and fine-tuning it.

So, I’ll keep my proposal up but I think for future proposals, we should go through this route and we should also set up a process for getting these kind of bounties set up.

Thanks.

  • Henry

Posting this as an UMA DAO member.

5 Likes

Thanks @henry. I appreciate the clarification that this is purely from the perspective of an UMA DAO member.

I recognize and appreciate that you have put time and effort into the work already for the dashboard, but would want this to be an open bounty to personally support the proposal instead of directly sent to you as a payment.

I think there is a good chance given the thought and prep that you would “win” the bounty with a submission, but I don’t like the idea of the DAO paying for something to a individual (even if valuable) that was not an existing request or something that limits competition or ability for anyone to try and submit a solution as I think it helps with quality, value, and opportunity within the DAO structure.

I agree with you that a bounty is better. But I think that given this isn’t side-stepping an existing process (UMA DAO doesn’t have a bounty for this, nor any agreed-upon bounty process other than this gov forum) we should consider the proposal as it stands today, and use it as a motivation to consider such a bounty process for the future.

5 Likes

Looking through this proposal i’d say it’s well detailed and has a good bang for buck. The proposal promises a large amount of valuable data for a very modest and reasonable amount of funding.

@EAsports regarding your concerns about it being a bounty instead, i feel this should be viewed from an angle of value instead. For me, the necessary question that should be asked is if this dashboard is valuable enough and worth the amount required. Another thing worthy of note is the fact that is that the payment structure is fashioned in a KPI manner thereby making it have my support as a uma DAO member, tokenholder and voter since the funds don’t get paid out until completion and verification of the deliverables by risklabs.

Lastly, changing this to a bounty would have been justified if the idea for the dashboard was birthed and requested from the onset by risklabs or the uma DAO but in this case the poster took out valuable time to come up with and work on building a valuable tool for the DAO. It would be “unfair” if this was made a bounty as the poster would stand a risk of losing which would result in all of the ingenuity, hardwork, effort and time of the poster all going to waste.

2 Likes

The result of the temp check was

  • 11 voters
  • 91% in favour
  • 9% against.

The proposal has gone forward to a snapshot vote.

Link to snapshot

If the proposal achieves 51% of votes with a quorum of 10% of the circulating supply it will go forward to the UMA voter dapp for UMA tokenholders to vote on-chain.

The final results on the snapshot vote for this proposal were

  • For - 4.4M UMA (99.9%)
  • Against - 4.3K UMA (0.01%)
  • Quorum - 4.4m / 3.3M

This proposal will now go forward for an onchain vote