Moving to Earn in the Bear Market
Jul 13, 2022 - Q96. Move to Earn projects have been growing in popularity, especially on Solana after the explosion of StepN.Projects like Genopets and Stepn both won Solana Hackathon awards and are two of the most popular games in the field. Each of their own NFT ecosystems and two native tokens ($GMT and $GST for StepN, $GENE and $KI for Genopets). Compare these two projects in terms of users, token flows, and NFT volume. How can these tokens stay popular in bear market and build their own resilient gaming economies?
Aave - 2. Borrow Durations
Jul 26, 2022 - How long on average and median do wallets borrow on AAVE? Measure this duration across at least three different tokens. Compare the borrow duration on AAVE with at least one other lending platform like Compound.
Aave - 6. Aave User Dashboard
Aug 11, 2022 - Create a dashboard that allows a viewer to input a user address and explore their borrowing and lending activity. Include metrics like total origination, loan revenue, outstanding debt, etc.
Hacks, Scandals and Scams - 4. CEL token flows.
Jul 28, 2022 - What are the top addresses swapping and transferring CEL? How have the CEL swap volumes changed over the past 90 days? How are Celsius wallets interacting with the CEL token?
Kashi Contracts on Polygon
Jun 13, 2022 - Q90. Create a document that includes all addresses for all kashi pairs on polygon for sushi plus the addresses of the two tokens belonging to each pair. Ideally, define which one is the main asset and which one is the collateral. If you are using sources from sushi github, please include the link.
Flow vs Other L1s
Jun 19, 2022 - Q13. 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
Sushi rewards distribution
Apr 25, 2022 - Sushi’s “merkle distributor” is the contract that is used to distribute the rewards in SUSHI to eligible users. There was a vesting period of 27 weeks during which the rewards were gradually being assigned to users. But the vesting period finished on Oct 12th 2021 at 7:10 PM EDT. After this time, users should call the “merkle distributor” in order to withdraw their rewards because no more reward is being vested. How much in total has been distributed so far? (A daily chart could help too) How much is left to distribute today? What percentage of eligible addresses have not claimed anything so far? How many eligible addresses have not claimed anything so far? What percentage of the eligible addresses are dead addresses (A dead wallet is a wallet that has not executed any transaction in the last 3 months)
Distinct Wallets (Optimism Bridge)
Jun 17, 2022 - How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
Open Analytics Bounty: Avalanche
Jul 29, 2022 - Trader Joe ! The best lending protocol in Avalanche
Solana Free Square
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.
Aave - 1. AAVE Flash Loan Users
Jul 26, 2022 - Show the frequency and volume of AAVE Flashloan use in 2022. Create a profile for a typical Flashloan user in 2022. Some of the metrics to look at could be wallet balance, transaction frequency, and dapps usage.
Aave - 8. How does BTC funding affect rates?
Aug 10, 2022 - Create a dashboard that shows: Supply and lending rates for at least five tokens in Aave V2, and Total amount of Wrapped BTC supplied over time. Provide analysis on the volatility of rates. Measure the correlation between USDC borrow rates and total wBTC supplied.
Aave - 7. AAVE and stAAVE movements
Aug 7, 2022 - Create visualizations showing the following: Daily AAVE supplied and withdrawn on Aave protocol. Daily AAVE staked and unstaked.
Swap Fees
Jun 27, 2022 - Q21. Do fees on Osmosis differ when users swap to or from different tokens? On average, which tokens have the highest and lowest swap fees on Osmosis?
Flash Bounty: An Odyessy of Congestion
Jun 30, 2022 - Analyze network congestion on Arbitrum and connect it to the recent Odyssey marketing event. What percentage of transactions were the result of the Odyssey? Did just yield and gmx get flooded with transactions? Or did other non-airdrop-farming protocols see increased volume from the odyssey too? Feel free include any visualizations, insights, and other data you think could be relevant to analyzing that congestion.
$RUNE Upgrades
Jun 27, 2022 - Q.107 There has been a big push for users to upgrade their ETH.RUNE + BNB.RUNE -> native RUNE, as the wrapped versions will be depreciated.Have you seen an uptick in the amount of $RUNE being upgraded recently? Look at both the $RUNE volume + number of wallets. What is the trend over time + also how much is ETH vs BNB?
Solana Protocol Feature
Jul 13, 2022 - Q97. Choose a defi protocol from the following list and create a dashboard with the new Flipside layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the protocol and what is happening on it.
Distinct Wallets (zkSync)
Jun 16, 2022 - How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
Active Wallet Addresses
Jun 21, 2022 - Q105. We are interested in knowing how many users are currently in the ecosystem. In this case, how many are holding $RUNE in their wallet or have an open LP position. What is this number currently, and how has it trended over time?
Opening Positions
Jun 29, 2022 - Q1. Over the last month, what volume of assets are Mean Finance (Polygon) users opening positions with (selling)? What assets are they dollar-cost averaging into (withdrawing swapped assets)? Note any large positions that don’t make sense on Ethereum due to transaction fees.
Pact.fi LP Pool Actions
Apr 25, 2022 - Investigating the add and remove of liquidity in the pools of the Pactfi project
Algorand Scavenger Hunt
Jan 28, 2022 - First, we swapped 0.1 algo to 10 YLDY then we stake our 10 YLDY
Velodrome Locks
Jul 17, 2022 - Analyze new locks created on Velodrome Finance. What durations are most common? Which wallets have locked the most in the last 4 weeks? Which pools are wallets voting for with their locked tokens most often?
Tornado Cash Addresses
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online. (Hint: we also have them in our crosschain address labels table as well).
What makes a Top Shots moment valuable? (Part I)
Jul 24, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.
