banbannard
Aurory Expeditions
May 9, 2022 - Since Expeditions launched on April 17th, how many unique Aurorians have been staked? Do these expeditions seem to be more popular for ""fish"" or for ""whales""? Based on the rewards structures of the different expeditions, why do you think that is? How many Aurorians that were sent on an expedition were then sold after their return?
GMT Airdrop
Mar 20, 2022 - Create a graphic showing the wallets that received the GMT airdrop and highlight the top recipients of the airdrop. What have recipients done with the airdrop? Are these "trailblazers" holding their airdrop or are they selling? Have the top recipients been more or less likely to hold onto their tokens?
Proof-of-Work on Ethereum
Sep 9, 2022 - We will explore Ethereum miners and their transaction count per mined block in this dashboard
The State of DeGods and DUST Before Minting y00ts (33.3%)
Sep 4, 2022 - What did y00ts do to DeGods and DUST?
Anchor Dominance
Feb 16, 2022 - What is the “Anchor dominance” for wallets on Terra? For active Terra wallets*, how much of their total asset value is held in Anchor at the time of analysis?
Stability Fee
May 15, 2022 - How impactful is the stability fee (the interest rate) on DAI loans in terms of the impact on volume and dollar amount of loans taken out? How does activity with DAI tokens change when the stability fee is different?
Transaction Failure
Mar 20, 2022 - Establish the failed transaction rate for Terra over a time period of your choosing. Is this analysis correct? Additionally, make a case for what is causing the failure transaction rate you assess, and provide recommendations to mitigate it.
Tinyman Pool Health Score Card
Jun 9, 2022 - Create a dashboard/table that lists the Tinyman pools and a composite score illustrating the health of each active Tinyman pool. This score should help the public understand the health composition of the pool and whether or not its safe to create an LP for. Possible factors to be included in the score number of wallets holding Pool LP tokens, the number of mints/burns for the pool, the percentage of LP tokens held by wallets, the percentage of tokens involved in the LP held by the wallets, etc. Detail the methodology you used and the factors that go into your score. The table should include the overall score and metrics that attributed to the score so the public can understand how each pool score is calculated!
Humble Swap Launch
Jun 23, 2022 - A new dex has launched on Algorand built by the reach team: humbleswap(humble.sh). Let’s look at how its launched: -Total number of swaps by day over time -total number of wallets swapping by day -What are the most popular asset pairs to swap from and too -Top 10 assets swapping from -top 10 assets to swap to
RocketPool: User Profile - LIDO vs. RocketPool
Apr 25, 2022 - Compare and contrast activity on RocketPool vs. Lido over the past three months. Is one growing more quickly than the other? Can we conclude if one of these applications is better for users than the other? Are there different types of users using RocketPool compared to Lido, or are the user profiles similar? Visualize and explain your conclusions.
Kashi TVL
Apr 11, 2022 - What is the Total Value Locked (TVL) by liquidity pool on Kashi? draw a weekly chart for 2022. what are the top 10 pools?
State of RUNE Activity
Dec 22, 2023 - These metrics exclude data from arbitrage bots - excluding wallets that have conducted more than 150 swaps within a two-hour window.
Active Wallet Addresses
Jun 19, 2022 - We are interested in knowing how many users are currently in the ecosystem. In this case, how many are holding $RUNE in their wallet or have an open LP position. What is this number currently, and how has it trended over time?
ETH.RUNE upgrades vs BNB.RUNE upgrades
Jan 8, 2022 - What is the ratio of the number of ETH.RUNE upgrades vs BNB.RUNE upgrades? How has that ratio changed over time?
FWBpro Airdrop
Feb 23, 2022 - What percentage of people receiving the FWBpro airdrop have held onto their tokens? Were people more likely to sell right after the start of the airdrop or has selling happened over time? Are there any patterns to holding vs selling behavior among wallets? Were larger holders of $FWB Classic more likely to try and mitigate risk after the hack?
Moonbirds Crossovers
May 3, 2022 - Are there any notable cross overs between the Moon Birds community and other communities? How many holders also have BAYC, Doodles, etc
Limit Swap Orders
Feb 28, 2022 - How popular is the limit order functionality in sushiswap? How many users have used it so far by placing limit orders?
Tracking UST on SOL
Feb 16, 2022 - There has been a focus of integrating UST in the SOL ecosystem in 2022. Identify the three most popular applications of UST in SOL DeFi in February. Can you calculate yield generated from these pools? Are "whales" more or less likely to transact in UST than USDC or USDT on SOL (can calculate this through avg value of each coin)? Highlight the 10 largest transactions in terms of UST in February. Are there patterns to the "whale" transactions and wallets?
Market Share Dashboard
Aug 29, 2022 - [DAILY UPDATED] This dashboard tracks affiliate fee of Thorchain affiliates
Sushi Reward Program for Farmers
May 4, 2022 - How much in total has been distributed so far? How much is left to distribute? What percentage of eligible addresses have not claimed anything so far? What percentage have totally claimed their rewards? What percentage have partially claimed their rewards? What percentage of the eligible addresses are dead addresses (A dead wallet is a wallet that has not executed any transaction in the last 3 months)
aUST Analysis
Dec 20, 2021 - Provide an analysis of aUST usage in the past 80 days. Employ at least two metrics of your choice and at least one data visualization. What opportunities do you see for aUST to add value to the Terra ecosystem?
% of Solana Staked
Feb 12, 2022 - Using the "Events" table, what percentage of Solana that has been transacted is staked? How has that percentage changed throughout the month of January? Create a visualization showing % SOL staked over time. What is the average amount of Solana staked during a staking transaction?
Impact of Adding New Chains/Tokens
Jan 15, 2022 - THORChain is planning on adding support for Dogecoin soon. Traditionally, what has been the impact of adding another chain (or token) on THORChain? Does swapping activity or THORChain wallet creation spike up?
Seasonality
Mar 13, 2022 - Is it true that the average gas fee paid by users is lower during festive seasons? Choose two festive seasons in 2021 to put this claim to the test! What else can we say about the festive seasons?
Mango Market Flows
May 10, 2022 - Track Exchange wallet flows and volume in and out of Mango Markets. Generate a daily aggregate of how the following venues exchange value with Mango Markets and also between each other on the Solana blockchain. Is FTX a central source of capital flowing into Mango? From what protocols does capital seem to be flowing into Mango programs? Where do users send assets to after using Mango Markets? Limit the analysis since the month of March.
Have staking rewards impacted the amount of $RUNE bonded or in LPs?
May 29, 2022 - Before Staking 2.0, users participated in single-sided staking that rewarded LP-ers via emissions. Now, $THOR stakers receive a liquid token of their staked allocation, in addition to a percentage of fees from swaps. Chart an analysis on Staking 2.0’s effect on the pendulum incentive. What’s been the impact on the flow of funds into staking from LPs or bonded $RUNE, (have users been swapping from $RUNE to $THOR and staking?), and how that might be affecting the ratio of capital in LPs vs in bonds.
MIM + Anchor
Feb 9, 2022 - How much of the current deposits to Anchor Protocol’s Earn product are from the MIM Degenbox Strategy? How has this changed over the past 30 days ? What would be the implications of Disabling MIM Degenbox Strategy? Could Anchor limit the MIM Degenbox Strategy to a certain percentage of deposits?