SOL Staker Activity
Apr 9, 2022 - How frequently are SOL stakers interacting with DeFi protocols over the past month? Which protocols are they interacting most with? Which actions are they mostly taking? Staking? Farming? Swapping? Mining?
Moonbirds Mint Analysis
Apr 22, 2022 - What was the distribution at mint? How many wallets minted? Who minted the most?
Impact of Adding New Chains/Tokens
Jan 18, 2022 - THORChain is planning on adding support for Dogecoin soon. Traditionally, what has been the impact of adding another chain (or token) on THORChain? Does swapping activity or THORChain wallet creation spike up?
DAI on the Market
Jan 18, 2022 - Analyze large shifts in the amount of DAI on the market over the past year. What might have caused these shifts? Are these events related to Maker directly? Are they related to the crypto ecosystem as a whole? Provide metrics to support your analysis.
Airdrop Actually Claimed
Oct 17, 2021 - What percentage of addresses that the airdrop was made available to claimed the LOOP airdrop and how much was claimed total?
Wallet Statistics
Feb 7, 2022 - For your average Sushi LPer - what proportion of their wallet is Sushi tokens? What proportion of their wallet is LP tokens? Is your average user supplying liquidity to more protocols than Sushi?
NFDomains
Jun 23, 2022 - NFDomains are .ALGO domains NFTs that have launched on Algorand. Lets look how many domains NFDomains have sold
Sushi Borrowing + Lending
Mar 6, 2022 - Has the recent price slump affected the sushi borrowing and lending activity? Describe the patterns and correlations with price, if any.
Uniswap Active AMM Users
Mar 17, 2022 - how do the the number of active users (wallets) on Uniswap and Sushiswap over the past year.
Coinbase Adds SOL Ecosystem Coins
Feb 14, 2022 - On January 31st, Coinbase added two Solana ecosystem coins to its listings: Bonfida and Orca. Create a visualization that shows the amount of FIDA and ORCA transferred from within wallets in the ecosystem to Coinbase. Did transfers spike right after the listing or has there been continued volume?
ETH Staked
Apr 4, 2022 - 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?
Secondary Sales Activity
Jun 18, 2022 - 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.
Crazy Goose Flock and $CRUMB Token
Jun 7, 2022 - Crazy Goose Flock is one of the strongest growing NFT communities on Algorand. Let’s look at the holders of the CGF!
Aave Fee Metrics Dashboard
Sep 24, 2021 - visualizes generated fees from Deposits, Flash Loans, liquidations, liquidity mining distribution, and staking fees on Aave V1, Aave V2, the Aave AMM, and Aave on Polygon, and the ability to break all of these metrics down by the currency that the fees were generated in; for any given week in the past year. Additionally, provide the ability to compare each of these metrics week over week. Reference bounty submissions from the previous round for some helpful boilerplate SQL to get started with.
THORChain and $vTHOR Overlap
May 23, 2022 - Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards.
Stablecoins
May 30, 2022 - The growth of non-volatile assets pegged to a fiat currency has been a one of the clear trends in crypto in the last few years. However, during the past days, a big fatal event occurred when Terra UST peg token started to depegging from $1.
To Go Bankless or Not To Go Bankless
Mar 7, 2022 - Why might someone go Bankless? Outline the BED index strategy deployed by Bankless DAO. Show how the BED index strategy has performed over time compared to a more traditional investment route
Voting Activity
Jun 18, 2022 - 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.
User Activity
Jun 10, 2022 - Analyze user activity providing and removing liquidity from NFTX vaults. Which three vaults have seen the most activity over the past 60 days? Are there any similarities between these vaults or NFT projects? Explain and visualize your findings.
LP Size Distribution
May 1, 2022 - What is the current distribution of LP size for each pool? You will have to use both 'add_liquidity' and 'remove_liquidity' to determine which LPs are stil current.
HODL or Sell?
Jun 11, 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?
User Journey and Outflows
Nov 13, 2021 - Show the number of users leaving the Sushi ecosystem every day (haven’t made a transaction in over a month and have no liquidity provided). Where are these users going? Why might users be leaving Sushi for other protocols?
