banbannard
Gain or Lose?
Apr 5, 2022 - Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap? Repeat the same analysis for stakers who have swapped stETH to ETH; how much ETH did they gain or lose?
What Are Users Swapping gALGO3 For?
Apr 29, 2022 - Show the number of trades to gALGO3 and from gALGO3 by day? Also chart the volume of trades to gALGO3 and from gALGO3 by day? Are there any notable days? If so, what may have caused this? What DEXes are users swapping gALGO3 on? Show the breakout of number of gALGO3 swaps(to or from) by day for each dex. What are the top 10 most popular to swap from to get gALGO3? What are the top 10 most popular to swap to from gALGO3?
Gard.Money Algorand’s First Algorithmic Stablecoin
Apr 22, 2022 - Chart how much GARD has been minted by day Chart how many wallets mint GARD each day. How much has Gard.Money generated in ALGO fees? Show the fees accumulation over time. -What is the total amount of ALGO collateral currently backing the GARD?
Fractional.art NFT Sales
Apr 26, 2022 - Using the Ethereum_core schema, analyze the 3 most actively traded fractional NFT vaults on Fractional over the past 3 months. How many NFTs are in these collections? What is the total trading volume? Add any other data points to your analysis that you find valuable.
Stablecoin Landscape on DEX
Jun 8, 2022 - Analyse the stablecoin landscape on Sushiswap, identifying the various tokens available and their main metrics (volume, number of swaps, TVL, and other relevant for you). Which one is the most successful? Is it the same at Uniswap?
Sushi During Volatile Times
May 30, 2022 - How did the recent spike in market volatility affect the overall activity of sushi on ethereum? Analyze both swaps and lendings?
Kinetic Money Scavenger Hunt
Apr 30, 2022 - I completed this scavenger hunt on April 30th and I enjoyed it!
Gas Efficiency
Jun 7, 2022 - Which one of the sushi services consumes the most gas per transaction? The services to include in your comparison are : -Adding liquidity -Removing liquidity -Adding an asset for lending -Borrowing -Removing an asset from lending -Repaying a loan -Swapping
Borrowing On Folks Finance
May 18, 2022 - Chart number of borrow actions by day. Additionally chart the number of borrow actions by day for each asset. Chart the volume that is borrowed for each asset by day(USDC, USDt, goBTC, goETH, ALGO), are there any notable borrowing days? What might have caused this? Note the average collateral debt position of ALGO(fALGO) to the borrowed asset for each asset. Then create a scatter plot for each asset plotting the collateral ratio for each borrow(x-axis is date) and highlight which ones were above the average collateral ratio and which ones were below. If you have a better way to visualize showing the borrows each day that were above and below the average collateral ratio for the asset show us!
Getting Your Feet Wet, Part 1
Mar 5, 2022 - Make a table containing wallet addresses whose first transaction was 90 days ago or less. Analyze how active they have been since that first transaction, based on either 1) the number of transactions; 2) the number of protocols interacted with, or 3) the number of different types of transactions undertaken. (deposit, delegate, vote)
Net Swapping Rations
Jan 16, 2022 - Which tokens have the highest and lowest ratio of being swapped from / to? (e.g. if users swapped from a total of 100 $BTC and to a total of 200 $BTC, the ratio would be 1:2)
UST-LUNA Highway
Apr 17, 2022 - Over a time period of your choosing, display the following: -daily minted UST and burned LUNA -daily burned UST and minted LUNA What are some trends you can observe for each of the charts above?
Bot Swappers
Apr 27, 2022 - Define bot swappers. How does the behaviour of bots differ from average swappers? For instance in terms of number of swaps, or in terms of distribution of swaps over a day. What percentage of swaps were executed by bots in the past 30 days? What pools and what pairs were most popular among bot swappers in the past 30 days.
USDC Deposits
Jun 21, 2022 - In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Anchor Emissions
Feb 20, 2022 - Create a table of all addresses that have made at least one Anchor borrow in the last 3 months. Do some basic analysis and produce at least one interesting insight about Anchor borrowers.
Tracking USDH
Apr 18, 2022 - Track where USDH is being used the most on other Solana defi protocols. What are the most popular pools where users are depositing USDH? Why do you think wallets are choosing to interact with those protocols with USDH? What tokens is USDH most commonly swapped for? What are some ways that USDH can become more adopted within the Solana ecosystem?
Sushi Token Activity
Jan 10, 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).
Saber Proposals & Gauges
Jun 1, 2022 - Create a visualization showing the total amount of SBR locked over time and voter participation rates. How many wallets that have locked SBR actually voted on a proposal? How many wallets that have locked SBR actually voted on a gauge? Wallets that have voted on proposals and gauges? What trends are you seeing in voter participation?
When Do Transactions Fail?
May 28, 2022 - Do times of high transaction volume lead to more transaction failures? Create a visualization that shows the relationship between transaction volume and success rate of transactions since May 9th. Are there any noticeable patterns to when transactions are more likely to fail? Were there specific events that seem to cause transaction failures?
SUSHI Noobs II
Jun 20, 2022 - What is the first thing new users do when they acquire SUSHI?
Net Synth Amounts
Apr 30, 2022 - Show the net synth amounts (mints - burns) for each chain and each asset? Are there any patterns?
Terra Builders
Feb 27, 2022 - Imagine you are a Terra Developer. What are your main pain points? What tooling, services, and resources would make you more productive? Describe at least 2 pain points that make building on Terra more difficult (these can be technical but non-technical pain points are also acceptable). Describe at least two (2) services/tools/capabilities that would address these pain points. Provide a concise explanation for each of them and the value they would unlock. For each capability you describe, provide a real-world example from another ecosystem and show how it enables/empowers developers in that ecosystem (can be another blockchain, but non-crypto examples are also acceptable).
Friktion SOL vs mSOL Volts
Feb 20, 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?
Assets Removed from Osmosis
Jun 10, 2022 - What was the total dollar amount of assets that was improperly removed from pools due to the bug, and what is the list of addresses that had joined a pool since the upgrade? What is the dollar value deposited of those addresses joining pools? What is the cumulative value of funds that joined and exited?
MNDE Liquidity Pool Deposits
May 15, 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
Swaps to $THOR
May 27, 2022 - On May 4th, $THOR staking was enabled that yielded rewards for stakers based on THORSwap volume. Did we see a spike of swaps to $THOR around that time? Has there been any noticeable change in $THOR swapping since that event?
Tinyman LP Actions
Mar 3, 2022 - Let's look at LP actions on Tinyman since launching Tinyman 1.1 at the beginning of 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
New User Activity
Feb 12, 2022 - For new users, what is the most common first program that users interact with on Solana (as in what is the most popular first transaction for a new wallet)? What is the average number of transactions a "new wallet" makes in their first 24 hours? (New wallet defined when a wallet makes its first transaction). Do you think this is more or less than other chains? Note: Limit this analysis to the month of February.
Tinyman Dex Popularity
Mar 24, 2022 - Chart the number of swaps by day for each DEX in 2022. Note when the swaps started for each PactFi, AlgoFi, and Wagmiswap and describe whether we see a change in the number of swaps on TInyman after the launch of the other DEXs.
stETH/ETH Fluctuation
Jun 13, 2022 - Analyze the price of stETH in ETH denomination and find meaningful correlations that explain its fluctuation. Possible correlations could be with ETH’s price in USD, ETH’s gas price, volume in the curve pool, Curve stETH/ETH pool composition, etc.
Mona Lisa- Lil Pump ft Soulja Boy MFT
May 26, 2022 - Opulous is a launchpad for music NFTs, where you can take ownership in artists’ songs, albums, and artworks and earn royalties from them. One of the first songs released was Mona Lisa- Lil Pump ft Soulja Boy -Show us the distribution of the number of shares each MFT holder has for the asset(725937713). -Have all the shares been claimed? Show the claims of the MFT shares over time so we can understand the effectiveness of the claims process -Have any wallets exchanged their shares? If they did, how much did they exchange them for? -Note any other interesting findings!