yam-finance/yam-www

Dune Analytics Dashboard

Closed this issue · 5 comments

ethedev commented

Dune Analytics Dashboard

Description

The treasury data is currently being pulled on the website https://yam.finance/#/dashboard from the yam api, we are also looking to have this data available on a dune analytics dashboard to experiment with updating it regularly, while we are working on the yam api for its long term implementation.

See yam treasury assets to understand where the treasury assets are located at, to be able to gather and build the dune analytics dashboard based off of that.

Requirements

  • Documenting the code.
  • Displaying on a counter, the calculation result of the total treasury assets values combined.
  • Displaying on a line chart the treasury history with all the assets at different block numbers (you can check every time something goes out/in the treasury and have that as a registered block number on the x axis) always including the very last block number. Limit the amount of block numbers to 15 only setting this as a changeable variable on the top of the query.
    • y axis: dollar value in millions.
    • x axis: block number values. (potentially display these as a formatted time instead of a block number).
  • Displaying on a pie chart all the treasury assets of the very last block number.
    • x column: asset name.
    • y column: asset balance.
  • Displaying on a table all current treasury assets names and balances.

Acceptance Criteria

  • Add limits to your queries, to not get blocked by dune analytics.
  • Test run all the queries to ensure everything works as expected and you dont get any errors.
  • Token holdings on addresses must be dynamically fetched.

Bounty

When applying for this bounty, provide an anticipated date for completion of the work in your work plan! And please be descriptive, add documentation where its most likely needed in the code, and add any additional comments here!

ethedev commented

Bounty will be 600$, i am yet to add the gitcoin connection into here!
Please comment if youre interested and think you will be able to complete on this.

mohitjain121 commented

Hello,

I came across yam finance on the recently posted dune bounty. Attaching my dune portfolio here: https://dune.com/shini
Adding a brief about me: I'm currently working as a product manager at a crypto investment startup based out of India. I've previously completed bounties for dune and Polygon DAO.

I'd love to work together with yam on this project. Let me know :)
I can be reached at Shini#3958
Best,
Shini

  • ❤️1
  • 🚀1
ethedev commented

Hello, thank you for your interest in the post @mohitjain121 and cool portfolio!
Started already with another developer ill be pinging you if it doesnt work out with him giving one day to see the results, stay tuned.

  • 👍1
rzeydelis commented

Hey, I would love to take this on if still available.

This is a dashboard I have just built for StakeWise:
https://dune.com/beeezeee/SWISE-BZ

And here are all of my queries:
https://dune.com/browse/queries/authored

Thanks!

ethedev commented

Hello @rzeydelis its been already assigned ill update you if anything changes, thank you for your interest