Kaka
OPtimitic or Pessimistic?
Oct 18, 2022 - Are you optimistic or pessimistic about the future of the layer-2 chain known as Optimism? How do you think it will fare going forward compared to other L2s? Make your case with Flipside data. Include at least three visualizations in your submission, and note any particularly interesting trend our outliers you see.
Distinct Wallets (zkSync)
Jun 16, 2022 - Q1. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
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.
FLOW User Retention vs Other Chains
Dec 19, 2022 - How sticky are the users on Flow? Create a detailed analysis comparing user retention on Flow vs. other L1 chains like Ethereum and Solana. How often do users who make a transaction come back and make another transaction one month later? How do monthly active users compare between chains?
Stable Coins Lent on Kashi
Jun 15, 2022 - Q92. Draw a chart showing the TVL of Stable coins on kashi pairs across all markets. Hint: You can include USDC, USDT, DAI and UST in your analysis and look for the transactions where they are deposited on Kashi for lending. The event name would be 'LogAddAsset'. Removing them will generate 'LogRemoveAsset'.
Going Down The Wormhole
Aug 11, 2022 - Q103. Create a dashboard that can refresh daily with metrics that provide a detailed picture of Wormhole activity both from Ethereum to Solana and from Solana to Ethereum.
Exchange Flows in the Bear
Aug 13, 2022 - Let's understand whether the bear market and recent issues with CeFi products have changed centralized exchange users' behavior.
HODL or Sell?
Jun 13, 2022 - Q11. 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?
ETH Staked
Jun 15, 2022 - Q9. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
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.
Most Common Transactions
Jun 25, 2022 - Q1. 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?
Pooly NFTs
Jun 22, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
Flash Bounty: Art Gobblers
Nov 3, 2022 - Art Gobblers is a pre-reveal NFT project that generates "goo" when you feed it (upload) art you've created. Some say the project is revitalizing NFTs in the bear market - Compare various metrics across NFT activity to support or oppose that idea. Then evaluate how the project's metrics stack up to other top NFT collections before their art reveals.