jxboi
Weekly Fees
Nov 21, 2021 - Show the total weekly fees collected each week over the past year. How has the total amount changed over time?
How Relevant is Justin Sun?
May 4, 2022 - This dashboard will explore the algorithmic stablecoin USDD recently announced by Justin Sun, $10B of crypto as collateral, and it's promised 30% yield.
Top Anchor Users: Part 1
Dec 19, 2021 - Explore the power users of the Anchor Protocol. Define “power user” according to at least two metrics of your choice, and analyze Anchor users based on these metrics. Are they retail investors? Whales? Do they transact regularly or infrequently? What conclusions can we draw from your explorations?
Where’s The Pot of Gold?
Mar 20, 2022 - Q168. What % of the bAsset market cap for bLUNA and bETH is locked as collateral on Anchor? Show where else bLUNA/bETH is being held, and explain why you think this is.
New vs. Existing Holders
Dec 20, 2021 - What has grown more since the airdrop, the number of unique wallets creating a domain for the first time, or the number of wallets adding additional domains? What do you expect to grow more over the next 6 months? Provide at least one visualization to support your thesis.
Polygon Fees
Sep 12, 2021 - Visualize the daily fees on Polygon since June 1, 2021. Compare these to the daily fees on Ethereum over the same time period - are they coorelated? Do they diverge significantly at any points? Provide analysis as to why you think this might be.
2. Algorand Governance
Jan 13, 2022 - What percentage of non-closed wallets have committed to Algorand governance? How many wallets total is this? What percent of wallets committed to period 1? What percent of wallets committed to period 2? What percent of wallets committed to period 1 and period 2?
How Do You Like Your Eggs
Dec 15, 2021 - - How many Eggs are there? - What is the breakdown/count of Legendary, Ancient, Rare, and Common - What percentage of Meteors become Eggs?
LUNA Price Action
Aug 31, 2021 - Effectively a content bounty: What is driving LUNA price to go so ham?
4. Weekly Fees
Jan 10, 2022 - Show the total weekly fees collected by each pool over the past year. How has the total amount changed over time? What happens when new pools get added to Curve? How do the weekly fees compare to the number of active weekly users? How do they compare to weekly volume?
User Growth Per Sector
May 3, 2022 - What sectors / Apps are driving user growth on Terra ?Choose the top apps per sector (DEXs, Borrowing, Staking, NFTs ...) and create a dashboard of user growth per sector and App. Are there any sectors / apps that are driving more user growth than others?
Dynamic Rate, Mvmt. I
Mar 23, 2022 - Q170. A recent governance proposal (https://forum.anchorprotocol.com/t/dynamic-anchor-earn-rate/3042) offers a dynamic Earn Rate as one solution to the problem of Anchor Protocol’s sustainability. Assess the following two questions: Based on defensible assumptions for key inputs (e.g. Anchor’s collateral blend and growth, as well as rates paid to borrowers), define a target range (+/- 1.5%) for the Anchor Earn rate that you think would be sustainable without regular capital infusions Assess the impact of declines in “earn rate” for other protocols, e.g. Aave, Compound, on key protocol metrics (e.g. user growth/decline, rate of user growth/decline, capital deposited, etc.)
4. [Easy] Transactions
Feb 26, 2022 - Visualize daily transactions on Harmony blockchain over a period of your choice? What interesting patterns you observe? Why could be the reason?
UST Competitive Advantages
May 4, 2022 - This dashboard will explore the strength and weakness of DAI and UST as well as the reasons why would a user choose to transact using UST over DAI (and vice versa).
38. Rune Upgrades
Jan 9, 2022 - How many unique addresses have upgraded their rune in first week of 2022? How does that rate compare with the previous 4 weeks? Hint: use thorchain.upgrades
Delegator APY
Sep 11, 2021 - Show the average APY for delegators. How has this changed over the past 6 months?
20. Sushi Token Activity
Jan 8, 2022 - Show the following for the past 30 days: Sushi staked (in USD), Sushi harvested (in USD), xSushi minted (in USD), and xSushi burned (in USD).
Bots and success rate
Apr 28, 2022 - This dashboard will attempt to analyze the success rate of transactions executed by bots vs retails for the past 60 days.
New Money
Dec 8, 2021 - Of the TVL for the community farming event, how much was new money (from outside Apollo’s vault) vs. a transfer from Apollo’s existing vaults?
Entering and Exiting yvBOOST
Sep 25, 2021 - Question: Yearn's new Zap contract allows users to enter vaults from a variety of tokens and to exit vaults into a number of tokens. What tokens are people using to enter the yvBOOST Vault? What tokens are people using to exit the yvBOOST Vault?
Whale Voters
Feb 13, 2022 - Question 146: For whale voters*, how many of them have voted in at least one Terra/Anchor/Mirror governance vote in the past 90 days? What is the percentage of whales who have voted?
Gas Used vs Gas Limit
Sep 13, 2021 - Question: Find the largest transactions in the past 30 days. How does the gas fee limit set on these transactions compare to the actual gas used for them?
Impact of UNI price on trading
Mar 31, 2022 - The price of UNI has been trending downwards since the start of 2022. How is UNI price correlated with trading volume? Does this have an effect on the number of liquidity providers?
21. Top Pool Analytics
Jan 12, 2022 - For the top 10 Sushi liquidity pairs (by liquidity) show the following: liquidity, 24 hour volume, 7 day volume, 24 hour fees, 7 day fees, and one year fees as a percentage.
Anchor Emissions (Hard Mode)
Feb 20, 2022 - What percentage of Anchor (ANC) borrow emissions are sold within 7 days of receiving them? How has this percentage changed over time? Question 150: What percentage of Anchor (ANC) borrow emissions are sold within 7 days of receiving them? How has this percentage changed over time? BONUS: What insights would you offer the Anchor team on how to reduce the percent of emissions that are being sold shortly after receiving them?