banbannard
Distinct Wallets (zkSync)
Jun 17, 2022 - ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. You can read more about ZkSync here. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
Metamask vs. Other Platforms
Jun 25, 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.
Gas as a proxy of activity
Jun 7, 2022 - How much did sushi users pay for gas in 2022? Is there a correlation with the price of ETH? Can you comment on the spikes in the chart?
Pooly NFTs
Jun 21, 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?
Volume Scoring with NBA Top Shot
Jun 6, 2022 - NBA Top Shot allows users to buy, sell, and collect NBA NFTs that showcase influential “Moments” minted on the FLOW blockchain. Create a visualization tracking the total sales volume traded on NBA Top Shot since May 9th by day. How many unique wallets have made a trade on Top Shot over that timeframe? How do those metrics compare to sales volume and unique users of Magic Eden on Solana and OpenSea on Ethereum?
Token Reactor Rankings
Jun 22, 2022 - Rank the token reactors by their TVL, analyze the pattern of liquidity (withdrawals, deposits) on the top ones. Is there a reason why some reactors have more liquidity than others?
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?
Active Addresses
Jun 6, 2022 - How many addresses on the MATIC network are active? What’s the daily evolution of active addresses? Is the activeness related some how to the price? Hint: Active address is an address that has done at least one transaction or has received at least once a token in the past 3 months. medium
Bridge Users (Hop Protocol)
Jun 20, 2022 - How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
Stablecoin Landscape on DEX
Jun 8, 2022 - 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?
Sushi During Volatile Times
May 30, 2022 - How did the recent spike in market volatility affect the overall activity of sushi on ethereum? Analyze both swaps and lendings?
Voting Activity
Jun 20, 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.
Distinct Wallets (Optimism Bridge)
Jun 17, 2022 - How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
Solana NFT Growth
Apr 27, 2022 - -Total mints and growth rates of mints over time -Total NFT sales and growth rates of sales over time -Total unique wallets that have minted or purchased a Solana NFT and growth rates over time -Total Unique Signers of Metaplex programs -Total minters of NFTs using Candy Machine V1 and total minters of NFTs using Candy Machine V2 -Total users of Metaplex's Auction House program Compare these metrics with NFT activity on Ethereum. How do the two chains compare and how are they trending?
Secondary Sales Activity
Jun 20, 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.
SUSHI Noobs
Jun 20, 2022 - From which address do users acquire their first $SUSHI token ? is it CEX ? DEX ? Dual LP Staking Rewards ? Airdrop ?
New Celsius Wallets
Jun 15, 2022 - Build a dashboard that tracks the activity of the newly identified Celsius wallets. Let’s look at incoming vs. outgoing transactions over time. What is the average amount being moved? What are the wallet compositions by token?
User Activity
Jun 11, 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.
Highest Sales Volume
Jun 11, 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.
Single-Sided Liquidity Pools
Jun 22, 2022 - Across uses single-sided liquidity pools to execute transactions between chains. How are Ethereum mainnet users interacting with these pools? How do these pool rewards compare to other liquidity pools?
zkSync Scavenger Hunt
Jun 14, 2022 - I had fun completing this zkSync Hunt. Thanks Flipside :D
Hop Whales
Jun 20, 2022 - Are whales choosing Hop to go to L2s? Or are they choosing the native bridges? Compare Hop vs the native bridges for Polygon, Optimism, and Arbitrum over the following metrics: unique users on each, frequency of use, and the average amount of assets moved on each?
Price + Circulating Supply
Jun 6, 2022 - Draw a chart showing MATIC’s circulating supply from the start till today. Compare it with MATIC’s price.
ERC20 Tokens (zkSync)
Jun 17, 2022 - ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. You can read more about ZkSync here. 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.