Sniper
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.
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.
Liquidity Providers Stats
Aug 24, 2022 - Q109. Liquidity providers stats 1. Evaluate the distribution of various target segments who provide liquidity (LP) 2. Evaluate the profitability of an LP Provider & Yield Farmer
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'.
Stablecoins on Kashi
Jul 14, 2022 - Q102. Analyze the behavior of stablecoins on Kashi markets.
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?
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?
wETH Deposit Rate
Jun 14, 2022 - Q11. 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?
Who's Got The Flow?
Nov 27, 2022 - Build a list of rankings to help us find the address with the most FLOW tokens. Identify any trends or outliers you see in this collection of whales
NFT Buying Behavior on Flow
Jun 14, 2022 - Q10. Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to on Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains? What do "whales" tend to focus on in Flow? How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? Are wallets more interested in new projects, or already existing projects on Flow?