hyoeiseman
Active Wallet Growth_SOLANA
Feb 3, 2022 - What is the number of unique active wallets (signers) over the past 7 days? Create a visualization showing the number of active wallets per day since the start of 2022. What trends do you see?
Untitled Board
Nov 22, 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.
MonkeDAO Validator
Feb 19, 2022 - The MonkeDAO was the first NFT DAO on Solana and also was the first NFT DAO to set up a validator in an effort to help decentralize and secure the network. When a user decides to stake their Solana, they delegate which validator to support with their staked Solana. 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.
Arbs, Arbs Everywhere!
Jul 21, 2022 - Q.112 One of the core actors in the THORChain ecosystem are the “Traders” (https://docs.thorchain.org/roles/trading). These traders swap at a high frequency to make a profit and are a key cog to helping balance prices on THORChain We are taking a deep dive on these traders. To do so, you have 2 options: 1) Identify the Ethereum arb bots and show their activity over time. How many are there? What is their average swap frequency and volume? Which tokens are they swapping? Are they interacting with synths or non-synths? How much profit are they making? 2) Identify a single Ethereum arb bot and show similar metrics. What is their THORChain address and what is their ETH address? Are there any other addresses that they are associated with (e.g. do they control several different addresses and transfer between them)? What is their average swap frequency and volume? Which tokens are they swapping? Are they interacting with synths or non-synths? How much profit are they making? Hint: use thorchain.swaps and ethereum.core.ez_dex_swaps (to get the profit)
Sushi Borrowing + Lending
Mar 10, 2022 - Question 49: Has the recent price slump affected the sushi borrowing and lending activity? Describe the patterns and correlations with price, if any.
Head to head
Mar 31, 2022 - Q172. Excluding the respective foundations, what are the top 10 addresses by amount of UST held? What are the top 10 addresses by amount of DAI held? Do you have any guesses to whom those addresses belong?
The Nightmare Scenario
Apr 22, 2022 - Q183. Recently, attacks have been leveled against Terra, suggesting that it is doomed to collapse as UST reaches unsustainable levels. Specifically, concerns have been raised that at a low enough LUNA price, users will no longer be able to redeem $1 of UST for $1 of LUNA.
Volume Market Share
Feb 14, 2022 - Show daily transaction volume on Sushiswap as a proportion of the total volume across all of the DEXs over the past 60 days.
Gain or Lose
Jun 16, 2022 - Q10. 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?
The Law Offices of NEAR
Aug 4, 2022 - Q7. Provide your best assessment of the number of smart contracts deployed on NEAR and clearly outline your methodology (after all, contract lawyers love clearly specified terms).
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?
Stablecoins on Kashi
Jul 14, 2022 - Q102. Analyze the behavior of stablecoins on Kashi markets. Which ones are being deposited for lending? Which ones as collateral? Do this for both polygon and Ethereum. You can use the cross-chain sushi ez_lending and ez_borrowing. Note: Currently the polygon data is only showing the recent months. We will back-fill the data in the future. Make sure your dashboard mentions the starting date on polygon data.
Polygon NFT
Jul 17, 2022 - Q3. How popular are NFTs on Polygon? Track daily volume over the past month/year/etc.
RUNE bonded + slashed amounts
Jun 12, 2022 - Q103. How much RUNE is bonded, how much RUNE has been slashed from those bonds (total and or over time)?
Untitled Board!
Oct 15, 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? Note any interesting trends or outliers that you see.
Untitled Board
Oct 4, 2022 - Which user action results in the highest rate of failed transactions? Compare swapping, borrowing, lending, and adding/removing liquidity on Sushiswap-Ethereum.
Untitled Board!
Oct 15, 2022 - What does a Daily Active User look like on Osmosis? First, plot out how many DAUs there are on Osmosis. For this exercise, consider a DAU would be any wallet transacting on Osmosis a majority of days every week. Once you have the DAUs, what does their activity look like? Do they LP more or swap more? How often do they transfer tokens into Osmosis? Where are these transfers coming from?
Outbound Traffic
Mar 17, 2022 - Question 166: The Terra Bridge has expanded its capabilities: https://twitter.com/Speicherx/status/1501883479457288193 Create a dashboard to track the outflows of LUNA and UST to Osmosis, Secret, Axelar, and Injective. What conclusions can you draw from the outflows thus far?
Bot Swappers
Apr 28, 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.