mattkstew
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.
Liquid Staking ETH Platforms Analysis
Sep 6, 2022 - Consider all possible liquid staking ETH platforms. Then, find out the following:
Distinct Wallets (zkSync)
Jun 14, 2022 - How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
Cryptopunk Sales and Traders
Aug 27, 2022 - Which 10 wallets are the most successful Cryptopunk traders? Successful could either mean the wallet has accumulated a large balance from sales or has accumulated a large number of Punks. Explain your methodology and findings.
ERC20 Tokens (zkSync)
Jun 15, 2022 - Users can also deposit ERC20 tokens into ZkSync. Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days? Visualize and explain both findings.
Secondary Sales Activity
Jun 19, 2022 - How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings.
Highest Sales Volume
Jun 12, 2022 - Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX? These are transactions where someone redeems their NFTX tokens for a specific NFT
Uniswap Monthly New Users
May 15, 2023 - Continuing the set of easy bounty questions to form our new analysts, we are launching another bounty related to Uniswap on Ethereum chain. The question to be solved is the following: Is Uniswap attracting new users? How many transactions are they doing? Using the last twelve months of Ethereum data, visualize the number of monthly new users onboarding to Uniswap.
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.
Prizes
Jun 22, 2022 - In the past 60 days, how many PoolTogether prizes have been awarded and claimed? What’s the USD value of these prizes?
Total Metamask Users
Jun 23, 2022 - How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking?
Merge Staking Providers
Sep 6, 2022 - Choose 1 liquid staking provider (Ankr / Lido / rocketpool, etc) and answer the following question:
Tornado Cash Sanctions
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online. What is Tornado Cash and why would it be targeted by the US government? Why might an address interact with the service?
Distinct Wallets (Optimism Bridge)
Jun 14, 2022 - How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
Sushi Treasury
Jun 25, 2022 - What are the in-flows and outflows from sushi treasury? Analyze the trends. Build a dashboard.
Multichain Backend Upgrade Delay
May 31, 2023 - The Multichain Token experienced a significant price plunge of 30% due to a backend upgrade delay. In order to gain valuable insights and understand the repercussions of this news, we are seeking skilled data analysts to conduct a comprehensive analysis of relevant data points. The goal is to provide a thorough understanding of the Multichain Token's current state and its potential impact on the market, with a specific focus on the repercussions of the backend upgrade delay.
Most Common Transactions
Jun 23, 2022 - What are the most common transactions for Metamask users? Create an analysis that shows the most common wallet activities and the most common platforms for those activities.
Tornado Cash Addresses
Aug 9, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online.
Total Value Locked
Jun 30, 2022 - What is the total value locked in the Opyn Squeeth (osQETH) contract? And where does osqeth draw its value from?
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.
Opensea Fees
Aug 1, 2022 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
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?
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?
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.
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.
Aave and stAave Movements on Ethereum Mainnet
Jun 3, 2023 - Continuing with the set of easy questions for our newbie users, we are now asking for creating visualizations depicting the daily, weekly and/or monthly movements of AAVE tokens on the Aave protocol specifically occurring on the Ethereum Mainnet, including both supply and withdrawal activities, as well as the daily staking and unstaking of AAVE tokens.