iloveOreo
Sushi and the Merge
Sep 30, 2022 - The Ethereum merge brought some uncertainty to DEFI markets. It got many market makers (MM) to remove liquidity from defi to lower their risk. After the merge, some have redeployed the liquidity, and some haven't.
Pooly NFTs
Jun 22, 2022 - How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
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?
Highest Sales Volume
Jun 10, 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.
Distinct Wallets (zkSync)
Jun 16, 2022 - How many distinct wallets have deposited ETH into zkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
Distinct Wallets (Optimism Bridge)
Jun 16, 2022 - How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
Flash Bounty: NFT Royalty Comparison
Oct 6, 2022 - Which platform is the king of NFT royalties?
User Activity
Jun 10, 2022 - Analyze user activity providing and removing liquidity from NFTX vaults. Which three vaults have seen the most activity over the past 60 days? Are there any similarities between these vaults or NFT projects? Explain and visualize your findings.
Liquid Staking ETH Platforms Analysis
Sep 1, 2022 - Let's look at the ETH staked on each platform.
Tourist Journeys - Citizens of NEAR and Ethereum
Oct 25, 2022 - If NEAR and Ethereum were a city, who would the citizens be? and how do they live?
Gain or Lose
Jun 13, 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?
ETH Derivatives
Sep 12, 2022 - Consider the liquid staking ETH derivatives from ankr, rocketpool and lido(aETH , rETH and stETH ). What are some trends around the price volatility for these tokens? Swap activity?
USDC Deposits
Jun 22, 2022 - In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Bridge Volume (Optimism Bridge)
Jun 16, 2022 - Compare user bridge volume on the Optimism Native Token Bridge vs. another Mainnet <-> Optimism Bridge of your choosing (e.g. Hop). Can we conclude if there are differences in the types of users or transactions using the native bridge vs. the non-native bridge?
ERC20 Tokens (zkSync)
Jun 16, 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.
Inflows and Outflows
Sep 13, 2022 - What is the volume of ETH and a stablecoin of your choice that's moved between the Optimism network and the Ethereum network across the bridge? How has that changed over time?
Ethereum miners
Sep 8, 2022 - Do certain miners prefer mining blocks with lower transaction count? Do certain miners only mine blocks with high transaction count?
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.
Voting Activity
Jun 17, 2022 - The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.