Soheil_MK
Active Wallet Addresses
Jun 28, 2022 - Q.105 We are interested in knowing how many users are currently in the ecosystem. In this case, how many are holding $RUNE in their wallet or have an open LP position. What is this number currently, and how has it trended over time?
What makes a Top Shots moment valuable? (Part I)
Jul 21, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.
Tourist Journeys
Oct 24, 2022 - lect one of the key Districts from the NEAR tournament, and compare it to a similar district in another “city” (that is, another Layer 1 blockchain).
Solana NFT Project Feature
Jul 20, 2022 - Choose a NFT project from the following list and create a dashboard with the new Flipside dashboard layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the project. Note any noticeable trends or current events for the project. Highlight how liquidity is flowing in and out of the project and what types of buyers and sellers are interacting with the project.
Swap Pairs on Optimism
Jul 20, 2022 - Create a document that includes all addresses for all swap pairs for Sushiswap on Optimism plus the addresses of the two tokens belonging to each pair. Getting the decimals for each of the tokens in the pair would be a bonus. If you are using sources from sushi github, please include the link.
$RUNE Movement from Crypto.com
Jun 18, 2022 - Q104. Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
ETH Staked with Lido
Jun 10, 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?
Sushi Activity on Ethereum
Jun 25, 2022 - Q96. How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
Layer 2 Blocks
Jun 26, 2022 - Q2. How many layer2 StarkNet blocks have been accepted on Ethereum (L1) chain so far? How much fees have been paid(generated) to Ethereum network? Has StarkNet contributed to saving in transaction fees for its users?
Flipside's World Cup of Bounties Side Quest: Pool Props: Decentralized Sports Exchange
Nov 29, 2022
ETH Deposited or Withdrawn
Jun 26, 2022 - Q1. StarkNet is a layer-2 chain that ensures interoperability with Ethereum mainnet. People are using it to move real ETH to starknet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors?
Flow vs Other L1s Pt (II)
Jul 18, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum.
Welcome to the City
Jul 18, 2022 - Q4. Once you’ve bridged to NEAR, what is a user’s first activity? Chart the protocols that users are leveraging after porting tokens through the Rainbow Bridge specifically
HODL or Sell?
Jun 12, 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?
ERC20 Tokens (zkSync)
Jun 14, 2022 - Q2. 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.
Opensea Fees
Jul 30, 2022 - Q6. Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
USDC Deposits
Jun 20, 2022 - Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Distinct Wallets (Optimism Bridge)
Jun 14, 2022 - Q1. How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
Solend Demographics
Jul 31, 2022 - Q101.Solend is the leading lending protocol on Solana. What are the demographics of the Solend userbase? What is the user distribution by size of account? (How many have between $1-1,000, 1,000 - 100k, etc). Is the protocol largely influenced by whales, or by average Solana users?
NEAR Gas Guzzlers
Jul 22, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month?
Celsius Swaps
Jun 22, 2022 - Q95. Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps?
Sushi Extra Yield for Kashi Users
Jul 19, 2022 - Sushi is offering extra incentives for people who are depositing capital for lending on Kashi. The depositor can not only earn APY from lending, but they can also earn extra APY by staking their lending position into an ONSEN farm. Analyze the behaviour of kashi lenders. What percentage of lenders farm their lending position for extra yield? What percentage of kashi TVL is being farmed? Which farms are the most popular? Is there a relationship between Kashi farm rewards and TVL for Kashi pools?