jackguy
MonkeDAO Vote
Apr 5, 2022 - Track the wallets that voted yes and no for the SMB proposal. What were people's voting preferences based on the number of SMBs that they owned? What have these wallets done with their SMBs since the voting? Was the nearly unanimous voting a bullish event? Have wallets that voted yes bought more monkes? Were those who voted no more likely to sell after the fact and on which marketplace? What percentage of all monke sales involved a selling wallet that voted at all?
New Validators - Last 60 Days
Dec 11, 2021 - how many new validators have been delegated to in the last 60 days? -What validators have gained the most traction in the last 60 days? -Why might these validators be gaining attention, why are people delegating to them?
Sushi Token Activity
Jan 11, 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).
Most Popular Aave vs. Compound Combos
Oct 22, 2021 - Identify the 8 most popular supply + borrow combinations on Mainnet Aave and Compound (by volume). How do they vary? What is the Net APY for each on each platform?
Distance between LP position bounds
Jul 24, 2021 - What is the distance on average between the bounds of LP positions on the top 10 pools? Is this impacted by position size? Do larger positions tend to have larger bounds?
Release of AlgoDex
Feb 23, 2022 - AlgoDex launched on Feb 9, 2022, let's look at the performance of AlgoDex's first day:
MonkeDAO Validator
Feb 18, 2022 - How many unique wallets since February 1st have decided to delegate their staked Solana to the MonkeDAO validator? Create a visualization showing delegations per day.
Volume Scoring with NBA Top Shot
Jun 4, 2022 - NBA Top Shot allows users to buy, sell, and collect NBA NFTs that showcase influential “Moments” minted on the FLOW blockchain. Create a visualization tracking the total sales volume traded on NBA Top Shot since May 9th by day. How many unique wallets have made a trade on Top Shot over that timeframe?
MNDE Liquidity Pool Deposits
May 16, 2022 - Track the flows of MNDE being deposited into liquidity pools across the Solana ecosystem. What protocols have seen the most MNDE deposits over time in liquidity pools (hint look into Orca, Rayidum, Serum, anything else?).
Algorand Unique Users Growth
Feb 7, 2022 - Chart how many unique wallets are added each day(Tip: Use the Account Table) Do we see an increase in wallets created during the governance commitment periods compared to non governance commitment times? Governance Commitment Period 2: September 20th 2021 - October 14th 2021 Governance Commitment Period 2: Dec 24th 2021 - January 7th 2022
Gainers and Losers
Jan 11, 2022 - Sort all of the liquidity pairs in terms of each of the following categories: fees in USD gained over the past 24 hours, volume in USD gained over the past 24 hours, and liquidity in USD gained in the past 24 hours. Repeat this process for the top 10 losers for each of the same categories.
End of Year CEX Transfers
Jan 19, 2022 - Did the volume of transfers to centralized exchanges increase towards the end of December compared to the volume of transfers at the beginning of December? (Hint: you will need to use the "Labels" table). Create a visual to show the trend of these transfers in the month of December. Based on the trends you discover, give some reasoning to why this occurred.
What Happens to the Loot
Dec 20, 2021 - Analyze to what extent Anchor stakers are selling their ANC rewards. What factors correlate with selling behavior vs. hodling behavior?
Marinade's Non-fungible Chefs
Apr 20, 2022 - Marinade Finance officially launched their protocol governance system on April 4, 2022. In order to participate in governance, holders of the protocol's native MNDE token lock their tokens in exchange for an NFT.
Marinade's Non-Fungible Chefs
May 2, 2022 - Marinade Finance Non-fungible Chef NFTs began minting on April 4, 2022. How many unique holders of the NFTs are there? Create a chart showing trading activity and SOL volumes on Magic Eden.
Transaction Fees
May 22, 2022 - How many transaction fees are being paid out each day for the past 30 days? Does a certain type of transaction result in a greater amount of fees being collected?
Average Trade Sizes
Sep 3, 2021 - What are the average trade sizes across the top 5 assets by volume traded with native Terra swaps currently?
Aave Liquidity Concentration
Aug 19, 2021 - What percentage of the liquidity on Aave is provided by the top 10 liquidity providing addresses?
LUNA Distribution, Mvmt II
Feb 5, 2022 - What is the distribution of LUNA for active wallets (i.e. wallets with at least one transaction in the past 90 days? What is the distribution of LUNA if wallets that have never transacted are excluded?
Impacts of Price Changes
Dec 26, 2021 - The Sushi token has been trending downwards in price for the month or so. How do the changes in price affect trade volume? How do they affect number of users staking and amount staked?
Fee Volatility
Aug 15, 2021 - What has the day over day change in fee generation been for Uniswap V3 over the past 1 month?
Anchor Borrows and Deposits
Dec 25, 2021 - How have the average and total borrows and deposits on Anchor changed over time?
How is UST Being Used?
Jul 1, 2021 - What are the main uses of the UST stablecoin on Terra? Is UST being used on protocols/apps or with centralized exchanges? Look at both volume and number of transactions.
Bonded vs. Unbonded LUNA Amount
Aug 28, 2021 - Visualize the amount of bonded LUNA vs unbonded LUNA there has been in the Terra ecosystem over the past 6 months. Has it remained fairly stable or is it volatile? Are you able to tell patterns of when people unbond their LUNA?
When Do Flow Transactions Fail
Jun 4, 2022 - what addresses and contracts are causing the majority of failures? What types of activities and events are these addresses doing that are spamming the network? What types of arbitrage opportunities are they seeking and how profitable are these efforts?
xSushi
Jan 24, 2022 - Explain the mechanism behind xSushi. Show the total supply of xSushi over the past 3 months. How does this relate to the total supply of Sushi over the past 3 months?
Self-Validating
Jul 25, 2021 - For the top 5 validators, what percent of the LUNA that they hold is their own as opposed to delegated to them? Has this proportion changed over time?
Stablecoin Pegs
May 12, 2022 - How have USD-pegged stablecoins across different chains, and with different backing mechanisms, fared through the last 5 days? Compare volume, peg stability, and any other metrics you think are relevant, and present a dashboard the summarizes your findings and conclusions.
ALGO Transaction Payment Size
Mar 31, 2022 - Let’s look at the quantities of ALGOs being sent in transactions since January 1st 2022 to see if we see any upwards or downwards trends. Group the transactions(algorand.payment_transactions) by size 0-10ALGOs, 10-100ALGOs,100-1000ALGOS, 1,000-10,000ALGOs and 10,000+ ALGOs. Count the number of transaction in each size and chart them by day from January 1st 2022 to current.
DeFi Users vs. Newbies
Jul 1, 2021 - Are Uniswap users coming from other Defi projects? We want to understand if we are seeing a flow of users and tokens from other similar protocols or if many of the users are new to the DeFi ecosystem.
Out of Range Positions
Aug 22, 2021 - Visualize the proportion of active positions on Uniswap V3 that have been out of range vs. in range daily since the launch of Uniswap v3.
Tinyman LP Actions
Mar 4, 2022 - - Show the number of mint and burn actions each day. - Create a table of the LP pools with the most mint and burn actions
Friktion SOL vs mSOL Volts
Feb 19, 2022 - How much SOL was deposited during the February 4th and February 11th epochs and how many unique users were in the SOL covered call volt? How much mSOL was deposited during those same epochs and how many unique users were in the covered call volt? Why do you think one volt has been gaining more adoption than the other?
Fastest Growing Uniswap Pool
Apr 1, 2022 - What is the fastest growing pool in the last 30 days? Define any metrics that you use to determine what the “fastest growing pool” means.