mb1124
MakerDao: Skill-building Bounty 3
Aug 25, 2022 - question: Shows the vault depositor Amount of WETH deposited into the vault as collateral Amount of DAI borrowed Create a scatter plot showing the percentage of DAI borrowed divided by the WETH deposited (in USD values) Who are the top borrowers?
New NEAR Users
Sep 7, 2022 - Q9. What actions does a user take when they deposit money into the NEAR ecosystem? Show the most common actions taken by users on NEAR (new users using NEAR for the first time) over the past 3 months.
Not Your Keys
Nov 18, 2022 - In wake of the issues surrounding FTX, the old adage "not your keys, not your crypto" reinforces itself. Let's see how this played out during the fallout. Did bridge activity spike over the last 7 days? If so, to what ecosystems? At a more granular level, track net outflows from FTX onto Ethereum. Did any of these outflows flow across Satellite to another destination chain?
Adding to the Margin with MarginFi
Feb 27, 2023 - MarginFi just launched to mainnet as a lending foundation for Solana. After the FTX collapse, Solana defi has been somewhat nonexistent outside of dex swaps. MarginFi is the first new product in the wave of "Defi 2.0" on Solana. Create a dashboard that tracks key KPI's for MarginFi. How has adoption been so far and what pools have been most popular? What type of user has experimented with MarginFi so far? What other programs have users been exposed to (Solend, Jet etc) that are now using MarginFi? What do borrowers do with their new found capital after using MarginFi? Are there signs of early growth of this new wave of Solana defi?
The Battle of the Solana NFT Aggregator
Oct 29, 2022 - Hyperspace and Coral Cube are the two most popular NFT aggregators on Solana. This means that they list all NFTs across different marketplaces along with allowing listings on their own marketplace. Create a dashboard comparing KPIs between Hyperspace and Coral Cube. Which marketplace has done more volume? Which collections are popular on each marketplace? Why would I use one marketplace over the other? Are there any noticeable market trends between the marketplaces, especially after Solana marketplaces moved to a 0% creator royalty?
DUST is in the Air
Sep 8, 2022 - Q107. $Dust is the utility token behind the most popular NFT project on Solana - Degods. The team and the community have been building with $DUST. How is $DUST being used in the Solana ecosystem? What are its most popular use cases and where are buyers of $DUST coming from? Highlight at least 3 metrics showing $DUST trends in Solana.
Evaluating NEAR Social Metrics
Jun 25, 2023 - Provide metrics on NEAR Social. +User engagement: How many users are actively using the platform, and how frequently are they posting, commenting, and sharing content? +User retention: How many users continue to use the platform over time, and how often do they return to the platform after their initial visit? +Network effects: How quickly is the user base growing? Provide any other metrics that may be useful in this analysis. +NEAR Horizon: How much of NEAR social transactions/activity is being used for NEAR Horizon? Percentage? Number of users? Please provide a detailed breakdown of these metrics, including any significant trends or changes observed over the past two years. Graphs, charts, or visual representations are encouraged to enhance the clarity of the analysis
Pooled Validator Participants
Sep 19, 2022 - Q118. Who are the unique new entities that are participating in pooled validators that did not participate in classic validators?
Untitled Board
Oct 7, 2022 - What's going on with LUNA, aka LUNA 2.0? Is there any unusual activity? Major whales buying or selling? What dApps are people using?
Optimism NFT Purchasing Behavior
Oct 15, 2022 - Show the distribution of all NFT sales on Optimism by price. What percentage of all sales have been above .01 ETH? Above .1 ETH? 1 ETH? Do you think that there is a limit to how high a floor for a NFT collection on Optimism can reach compared to on Ethereum?
2022 Retrospective
Dec 21, 2022 - Let’s explore some key indicators of the health of the Web3 industry. Project ETH supply growth for 2023 by using various average gas prices. What is the highest value DEX swap, by protocol? Where was there the most DEX swaps by protocol? Which were the highest gas consuming NFT mints?
Osmosis Governance: 362 and Beyond
Nov 22, 2022 - Governance in the Cosmos ecosystem has been a hot topic of late - first with Cosmos Hub 82 and now in Osmosis. Osmosis Prop 362 is a vote to decide the fate of the Osmosis Grants Program (OGP). Contention aside, there have been many points and counterpoints, AND a ton of vote switching. Let's take a look at the governance behavior surrounding Proposal 362. On the outside, it seems that a ton of voters have been switching their votes - is this actually true, or is it just big whales/validators causing these swings? What is the average wallet size (in OSMO) of the people voting? Of the people who have changed their vote more than once? Compare and contrast voting behavior of validators and average users in this context. Further, is Prop 362 significantly different than other proposals from an engagement perspective? Analyze voting for 362 vs. other recent governance proposals.
Defi on FLOW
Nov 19, 2022 - Flow’s DeFi landscape is nascent but growing quickly. For DeFi enthusiasts coming to Flow, what information might they need to best understand this part of Flow’s growing ecosystem? Build an analysis that tracks prices for Flow fungible tokens, looking for the following data points: ticker, volume on DEX by ticker, volume on CEX by ticker, liquidity on DEX, price, market capitalization, and fully diluted value.
What's All The Hubbub for Hubble Protocol?
Oct 8, 2022 - Create a KPI dashboard that shows Hubble metrics such as: daily active users, new users, mint/burn rates, different rates of instructions etc. (anything you find relevant) Show the flows of USDH, where it is being used in the Solana ecosystem, is it gaining adoption, and if so how? Provide metrics on its growth rate and adoption so far. How is it being used?
Realms vs Snapshot
Aug 31, 2022 - question: What trends do you see between governance behavior between the two chains? Does a platform seem to capture more market share of its users on their respective chain than the other? What seems to influence voting behavior on each platform? Does one platform have more proposals and voting opportunities than the other? Are whales more powerful on Realms or on Snapshot? How can each platform become more decentralized?
Governing the Underworld
Mar 8, 2023 - Hadeswap goverance has taken a turn for the dramatic after their purchase of the SMB IP. Since then, the DAO has hosted notable governance proposals Create a dashboard that shows Hadeswap governance activity and key metrics for each proposal made. How does Hadeswap governance compare to other DAOs on Solana. Is there more active voting participation relative to typical governance behavior we see on Realms? How concentrated is the voting power in these proposals? Is this normal, or is Hadeswap controlled by a loud minority? How often are wallets transferring $Hades before casting a vote? What about purchasing $Hades to make a vote? Is it possible holders are spreading voting power among multiple wallets? How do you envision the "bribe wars" continuing to shake out?
Solend Demographics
Aug 3, 2022 - Q101.Solend is the leading lending protocol on Solana. What are the demographics of the Solend userbase? What is the user distribution by size of account? (How many have between $1-1,000, 1,000 - 100k, etc). Is the protocol largely influenced by whales, or by average Solana users?
FLOW's Path To Decentralization
Nov 14, 2022 - Flow is becoming more permissionless! Flow’s long-term vision is to optimize for security and scalability and move toward decentralization over time. With the release of permissionless contract deployment and new nodes for staking, build an analysis around the state of staking on Flow. Display the progress toward decentralization, answering questions like (but not limited to): how much total $FLOW is staked? How much $FLOW is staked/unstaked per day? How many unique stakers there are? What is the amount of $FLOW staked vs. $FLOW circulating?
Liquid Staking ETH Platforms Analysis
Sep 4, 2022 - Consider all possible liquid staking ETH platforms. Then, find out the following: 1-How much ETH was staked over time? 2-How many unique depositors are there? 3-How likely are depositors to use multiple platforms vs using a single platform? 4-Are depositors Dollar cost averaging their ETH into the platforms? 5-What is the avg/median/max/min/distribution of ETH deposits? 6-Compare all the metrics above between the various ETH staking methods/platforms
Inflows and Outflows (redux)
Nov 2, 2022 - What is the volume of ETH and three stablecoins of your choice that's moved between the Optimism network and the Ethereum network across the bridge? How has that changed over time?
Across Protocol Airdrop
Nov 29, 2022 - The ACX airdrop took place this week. Create an analysis of the Across protocol bridge volumes, airdrop distribution and TVL. Compare this to any other bridges, like Synapse or Hop.
Dimension X Activity
Mar 29, 2023 - Dimension X is one of Flow's hottest NFT games where you can create a team of heroes to go on quests and battle enemies. Each quest is a competition with other hero teams. Analyze Dimension X activity by showing MoM active users, monthly user growth, new users over time, average transactions per user, and MoM fees paid (if any). Explore Dimension X yourself and see if you can uncover other useful metrics to compare Dimension X to other popular NFT games (you can compare to games on other chains if you'd like).
Who's Got The Flow?
Nov 27, 2022 - Who is holding the most FLOW? Build a list of rankings to help us find the address with the most FLOW tokens. Identify any trends or outliers you see in this collection of whales. Bonus points if you can identify the wallet holders.
NEAR City Layout
Nov 8, 2022 - How centralized or decentralized is NEAR, really? Choose at least two distinct measures of decentralization that can be explored with on-chain data; clearly define those metrics; and outline how NEAR performs based on those metrics. In your view, is NEAR becoming more centralized or decentralized over time?
NFL ALL (THANKSGIVING) DAY
Dec 2, 2022 - The NFL's annual Thanksgiving games recently drove record viewership in the U.S., with 42 million people tuning in to see the Giants take on the Cowboys. Did FLOW NFT project NFL ALL DAY see similar boosts in popularity? Create a dashboard that analyzes NFL ALL DAY NFT activity over the past week, and compares it to activity over the past year. Include at least these metrics, along with any others you find notable or interesting: Sales volume (daily) Total Sales Volume Daily Average Sales Price and 7-day moving average Total Unique Buyers Average Buyers/Day
ETH Flash Bounty: What’s Next?
Sep 30, 2022 - The Merge has come and gone — what will be the next story, trend, or outlier to dominate the ETH space? Identify at least 3 developing trends or events that could have a large impact on Ethereum between now and the end of this year. Back up your assertions with data and visualizations.
ERC20 balance: Skill-building Bounty 4
Aug 24, 2022 - question: 1-create a chart that shows the latest top 10 holders of that token with the token amounts. 2-create the same graph but this time showing the USD prices of that token instead of the amount.
Flash Bounty: Merge Staking Providers
Sep 6, 2022 - Choose 1 liquid staking provider (Ankr / Lido / rocketpool, etc) and answer the following question: 1-How much ETH was staked? 2-How many unique depositors are there? 3-What is the avg/median/max/min/distribution of ETH deposits?
ETH Removed
Sep 11, 2022 - question: Examine user behavior in recent weeks leading up to the merge on at least 3 major protocols. Have there been any changes in the amount of ETH removed from protocols like Uniswap and Aave? Note any trends or outliers you find.
Solana Since The Mango Hack
Oct 14, 2022 - What has been happening in the Solana defi ecosystem since the Mango Markets Hack? Has activity increased? Decreased? Are users flocking to any particular defi apps? Are they leaving the ecosystem? Chart flows in and out of centralized exchanges from the Solana ecosystem. Has staking behavior changed on Solana since the hack?