kiacrypto
Getting Your Feet Wet, Part 1
Mar 5, 2022 - Make a table containing wallet addresses whose first transaction was 90 days ago or less. Analyze how active they have been since that first transaction, based on either 1) the number of transactions; 2) the number of protocols interacted with, or 3) the number of different types of transactions undertaken. (deposit, delegate, vote) Note: grand prize-winning submissions will assess at least two of the activity metrics above.
Lido Rocket Pool Comparison
Apr 27, 2022 - Q13. Use the ethereum_core tables to compare deposits to Lido and Rocket Pool Hint: rETH contract: https://etherscan.io/token/0xae78736cd615f374d3085123a210448e74fc6393 Lido sETH contract: https://etherscan.io/txs?a=0xae7ab96520de3a18e5e111b5eaab095312d7fe84
Pooly NFTs
Jun 22, 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?
HODL or Sell (that is the question)
Apr 6, 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?
Moonbirds Gas Fees
Apr 22, 2022 - Q6. How much gas was spent minting? Was any gas lost due to failed transactions? How does it compare to other recent launches? Use the Ethereum_core schema. Hint: https://etherscan.io/address/0x23581767a106ae21c074b2276d25e5c3e136a68b
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.
Fuse Pool DAI Allocation
May 23, 2022 - Q1. How are the tokens in the DAI Vault being allocated into the various Fuse Pools?
Most Popular Jupiter Swaps
Feb 26, 2022 - Jupiter is the best swap aggregator on Solana, meaning that it optimizes the best token swap rate across all decentralized exchanges for users. Since February 1st, what have been the 10 most popular tokens to swap away? Over that same timeframe, what have been the 10 most popular tokens to swap for? What are the 10 most popular swapping pairs (combination of swap away to swap for)? Define 'popular' as the number of swaps and create a visualization showing total number of swaps over that time frame, highlighting these most popular tokens.
USDC, USDT comparison in Orca
Jun 15, 2022 - Q86. This week we want to try something new. We want you to essentially write your own bounty question and answer it yourself. Pick any topic around Solana that you find relevant and interesting and analyze it. Bonus points for creativity and uniqueness!
