mattkstew
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?
Stablecoin Landscape on DEX
Jun 9, 2022 - Q87. 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?
Celsius Swaps
Jun 17, 2022 - Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps?
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?
SUSHI Noobs II
Jun 17, 2022 - What is the first thing new users do when they acquire SUSHI?
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.
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?
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.
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.
Sushi Activity on Ethereum
Jun 25, 2022 - How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
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?
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.
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.
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?
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?
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?
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.