mattkstew
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?
Avalanche Lido stETH Redemption Analysis
May 20, 2023 - Lido Finance, a decentralized finance protocol, recently enabled withdrawals of Ethereum (ETH) in the form of staked Ethereum 2.0 tokens (StETH). This feature attracted significant attention and led to an impressive rush of StETH redemptions, with $500,000 worth of StETH redeemed in just three hours. Make a comprehensive analytical report on the Lido StETH redemption rush, focusing on the key factors, implications, and trends observed during the event.
Arbs, Arbs Everywhere!
Jul 14, 2022 - 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?
Gain or Lose
Jun 10, 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?
Groundhog Day
Jan 13, 2023 - let’s turn to our friend the groundhog for an early crypto-winter prediction: are we nearly through to spring, or will winter’s cold snap continue on even longer? Back your assertion by creating a dashboard with on-chain data that supports your arguments in favor of either a continued downturn in the space or a soon-to-come rally.
wETH Deposit Rate
Jun 13, 2022 - Calculate the deposit rate of wETH over time on Osmosis. How does this compare to SushiSwap and Thorchain now? How does the wETH deposit rate compare to when wETH was a relatively new asset (or the protocol was relatively new)? Is Osmosis growing at a faster rate than Thorchain and Sushiswap?
Largest Tokemak DEX Pools
Jun 22, 2022 - What are the largest dex pools for TOKE (UNI, SUSHI, etc.)? What is the behavior of TOKE holders on these token pools currently?
Memecoins and the market
May 15, 2023 - How long does a meme last? Recently, memecoin activity and prices have spiked and crashed. Where did the liquidity come from, and where has it gone? Are markets returning to a risk-off mentality?Compare recent memecoin price action and activity with historical trends for memecoins of prior fame. Among today's notable choices are $pepe, $bonk, $chad, (etc), whereas older coins include $doge, $shib, etc.
Metamask vs. Other Platforms
Jun 23, 2022 - How many users are swapping via MetaMask vs other platforms? How much volume have these users done? Chart a comparison between the two, and show the following metrics over a time period of your choosing: transaction volume, average amount swapped, and a comparison of fees.
ETH Shanghai Countdown
Apr 7, 2023 - Shanghai is right around the corner. Starting April 12, 18M Eth (~$32.5B) will start to unlock, marking the first time in history that users are allowed to withdraw their staked ETH. Time to dig into the chain. What do YOU think is going to happen and what metrics are you keeping an eye on? What LSD derivatives are primed for the most gains? Why? Tell us your narrative.
Ethereum Easy Question
Apr 27, 2023 - Choose 1 pool on Uniswap V3 where one of the token pair is USDC. Show the daily volume of transactions where USDC was swapped for the other token. Show the daily volume of transactions where the token was swapped for USDC. Show the aggregate daily total swap volume of your chosen pool. Show the daily number of transactions that used this pool.
Uniswap On Avalanche
Jul 21, 2023 - In this dashboard I am going to be covering Uniswap Activity on Avalanche. For this Analysis I am going to be looking at Uniswap Overall on the platform, Uniswap compared to other DEX's on Avalanche, as well as Uniswaps activity on Avalanche compared to Uniswaps Activity on other Platforms.
HODL or Sell?
Jun 10, 2022 - Identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. Have they held or sold their stETH?
USDC: AVAX vs L2
Jun 16, 2023 - Create a dashboard that crafts a narrative of USDC on Avalanche vs L2s. Compare the utilization of USDC across Avalanche vs Optimism, Arbitrum and Polygon. Explore the amount of USDC that has been minted and burned on each chain. Dive into the number of holders, the velocity of USDC transfers, the average amount of transfers, and any other statistics that craft a narrative of USDC usage on Avalanche compared to L2s Optimism Arbitrum and Polygon. Next using labels, dive into what protocols we see USDC being used most heavily on. Lastly, look at swapping activity involving USDC. What assets are users swapping to and from that involve USDC?