purple898
Flow vs Other L1s Pt (II)
Jul 16, 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.
Q103.Fees on Kashi Markets
Jul 12, 2022 - How much fees each Kashi market has generated and which are the top markets in terms of fees generated? Hint: you can use the cross-chain sushi ez_lending and ez_borrowing. Note: Currently the polygon data is only showing the recent months. We will back-fill the data in the future. Make sure your dashboard mentions the starting date on polygon data.
Q11.HODL or Sell?
Jun 12, 2022 - 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. 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.
Celsius Swaps
Jun 18, 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?
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. You can read more about ZkSync here. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
SUSHI Noobs II
Jun 19, 2022 - Q94. What is the first thing new users do when they acquire SUSHI?