cancelo-sergio
Flow vs Other L1s Pt (II)
Jul 20, 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.
Total Metamask Users
Jun 26, 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?
Quixotic NFT Dashboard
Aug 4, 2022 - Q7. Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism! Include any data you think is relevant in our Optimism tables and tell us the most interesting trends you can find with the secondary NFT market.
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.
HODL or Sell?
Jun 16, 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 17, 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. 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.
NEAR Gas Guzzlers
Jul 28, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month?
HODL or Sell (that is the question)
Apr 7, 2022 - Q8. In a time period of your choice, 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?
Distinct Wallets (zkSync)
Jun 17, 2022 - Q1. 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. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.