misaghlb
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?
Hop Bridge Volume
Apr 19, 2022 - How many Matic token were bridged in 2022 per day from ethereum to layer2 using Hop?
ETH Deposited or Withdrawn
Jun 25, 2022 - Q1. Starknet is a layer 2 chain, like polygon, 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?
SUSHI Noobs II
Jun 19, 2022 - Q94. What is the first thing new users do when they acquire SUSHI?
Bridge Volume (Optimism Bridge)
Jun 15, 2022 - Q2. Compare user bridge volume on the Optimism Native Token Bridge vs. another Mainnet <-> Optimism Bridge of your choosing (e.g. Hop). Can we conclude if there are differences in the types of users or transactions using the native bridge vs. the non-native bridge?
Voting Activity
Jun 21, 2022 - Q1. The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
Prizes
Jun 21, 2022 - Q3. In the past 60 days, how many PoolTogether prizes have been awarded and claimed? What’s the USD value of these prices?
ERC20 Tokens (zkSync)
Jun 15, 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.
USDC Deposits
Jun 21, 2022 - Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Bridge Transactions (Across)
Jun 19, 2022 - Q1. Analyze bridge transactions via the Across bridge over the last two weeks. What assets are users bridging from Ethereum, and to what chains? Across transaction event data is undecoded in the Ethereum core tables. Users can use these functions to parse and decode the data: regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data ethereum.public.udf_hex_to_int() Hint: A user begins a bridge transaction by calling the deposit function on the SpokePool contract from the origin chain. Ethereum SpokePool contract : 0x4D9079Bb4165aeb4084c526a32695dCfd2F77381
Distinct Wallets (Optimism Bridge)
Jun 15, 2022 - Q1. Many blockchain bridges exist allowing users to move assets between different blockchains. One of the blockchains currently receiving a lot of bridge volume is Optimism. There are several bridges you can use to move tokens to Optimism, but for this bounty we are particularly interested in Optimism’s bridge. You can find more information on their native bridge here and here. How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
ETH Staked
Jun 11, 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?
Pooly NFTs
Jun 21, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
Bridge Users (Hop Protocol)
Jun 17, 2022 - Q1. How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
Secondary Sales Activity
Jun 17, 2022 - Q2. How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings.