NEAR Gas Guzzlers
Jul 24, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month?
Flipside's World Cup of Bounties Side Quest: Fifa+ Collect Collection Scorecard
Nov 13, 2022
NEAR Performance
Jul 18, 2022 - How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.
NBA Playoff Usage
Jun 27, 2022 - Q.15 Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume. What about NBA Top Shots?
ETH Deposited or Withdrawn
Jun 29, 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?
ETH Staked
Jun 15, 2022 - 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?
Algorand Price Correlation
Jun 28, 2022 - Q109. Is the price of Algorand more closely correlated with the crypto market, and assets such as BTC or ETH, or is it more correlated with network usage such as number of transactions or ALGO transfers? How does this compare to other networks such as Solana? Note your findings and anything else that may be interesting in relation to Algorand's price movement!
New Wallets In May
Jun 16, 2022 - Q101. How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May?
Opensea Fees
Jul 31, 2022 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
Bridger Destinations
Jul 31, 2022 - Where do people go when they bridge to Polygon from Ethereum? What are the 10 most popular first destinations for Polygon addresses that have just bridged from Ethereum?
Flow vs Other L1s
Jun 17, 2022 - Q13. 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
Polygon NFT
Jul 13, 2022 - Q3. How popular are NFTs on Polygon? Track daily volume over the past month/year/etc. How many Polygon users started off with NFTs? Who made the most profit?
ERC20 Tokens (zkSync)
Jun 16, 2022 - Q2. 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
What makes a Top Shots moment valuable? (Part I)
Jul 25, 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.
Polygon Block Performance
Jul 23, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
