kiacrypto
Voting Activity
Jun 19, 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.
Distinct Wallets (Optimism Bridge)
Jun 17, 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.
Active Addresses (polygon)
Jun 8, 2022 - Q4. How many addresses on the MATIC network are active? What’s the daily evolution of active addresses? Is the activeness related some how to the price? Hint: Active address is an address that has done at least one transaction or has received at least once a token in the past 3 months. medium
Total Metamask Users
Jun 25, 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?
Sushi Treasury
Jun 27, 2022 - Q97. What are the in-flows and outflows from sushi treasury? Analyze the trends. Build a dashboard. Hint: Treasury: 0xe94b5eec1fa96ceecbd33ef5baa8d00e4493f4f3 Operations multisig: 0x19b3eb3af5d93b77a5619b047de0eed7115a19e7 Sushi house: 0x7b18913D945242A9c313573E6c99064cd940c6aF
Gas Efficiency
Jun 8, 2022 - Q88. Which one of the sushi services consumes the most gas per transaction? The services to include in your comparison are : -Adding liquidity -Removing liquidity -Adding an asset for lending -Borrowing -Removing an asset from lending -Repaying a loan -Swapping Hint: each of these activities have a special event that only appears for that activity. For instance repaying a loan generates the “LogRepay” event.
Sushi Activity on Ethereum
Jun 27, 2022 - Q96. How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings? Hint: use the tables in Sushi schema: ethereum.sushi.
NFT Buying Behavior on Flow
Jun 12, 2022 - Q10. Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to on Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains? What do "whales" tend to focus on in Flow? How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? Are wallets more interested in new projects, or already existing projects on Flow?
Secondary Sales Activity
Jun 18, 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.
Gain or Lose (LIDO)
Jun 15, 2022 - Q10. Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap? Repeat the same analysis for stakers who have swapped stETH to ETH; how much ETH did they gain or lose?