![[AAVE-6] Stablecoin Interest Rate](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png "[AAVE-6] Stablecoin Interest Rate")
[AAVE-6] Stablecoin Interest Rate
Sep 1, 2021 - What has the interest rate for the current top 2 stablecoins by volume on Aave been over the past 6 months?
[Terra-63] TerraSwap Pool Fee Performance
Sep 8, 2021 - What are the top 5 TerraSwap Liquidity Pools by fee APR over the past 6 months?
Saber and daoSOL
Feb 18, 2022 - Saber is the leading cross-chain stablecoin and wrapped assets exchange on Solana. As we learned in the scavenger hunt last week, you can create a liquidity pair with staked SOL from the MonkeDAO created DAOPool with SOL to earn additional yield on Saber. Since the start of February, how much liquidity has been deposited in the daoSOL-SOL pool per day? How many unique wallets have added liquidity to that pool since February 1st? Create a visualization showing liquidity trends with this pool.
Sushi-19. [Hard] Wen Sushi moon?
Dec 31, 2021 - Explain to someone with little knowledge of the crypto world whether the Sushi token is a good investment or not. Show how it compares to the tokens of other DEX’s. Go ham.
Sushi-68.Swap Volume and Ukraine War
Apr 17, 2022 - -- Q68. How has the Ukraine war affected the swap volume on Sushi and Uniswap? Has there been a surge in demand for a particular token?
Sushi-65.Kashi TVL
Apr 11, 2022 - -- Q65. What is the Total Value Locked (TVL) by liquidity pool on Kashi? draw a weekly chart for 2022. what are the top 10 pools?
157.Terra-State of the State
Mar 5, 2022 - -- Question 157: Many bounties come from Terra clients. This time, Flipside is the client! -- Review the existing Terra Console for accuracy: https://consoles.flipsidecrypto.com/terra/overview/index -- Accuracy: Are there any data errors you can identify? -- Usefulness: Is there anything missing that would be critical for new users to Terra? -- For Definition, describe the process you used to check the data. -- For Completeness, make your case for what needs to be included that is currently lacking.
Solana-57.Tracking USDH
Apr 18, 2022 - -- Q57. Hubble is a decentralized finance protocol built on Solana. -- Hubble will offer multiple Hubble currently focuses on borrowing and minting USDH - a stable coin. -- Users can deposit multiple kinds of crypto assets like SOL, BTC, ETH, and others to borrow up to 90.9% LTV in USDH. -- While borrowing, users can earn yield on their deposits. -- Therefore you can take your USDH and invest it in other protocols. -- Track where USDH is being used the most on other Solana defi protocols. -- What are the most popular pools where users are depositing USDH? -- Why do you think wallets are choosing to interact with those protocols with USDH? -- What tokens is USDH most commonly swapped for? -- What are some ways that USDH can become more adopted within the Solana ecosystem?
Terra-114. [Easy] New Validators - Last 60 Days
Dec 15, 2021 - -How many new validators have been delegated to in the last 60 days? -What validators have gained the most traction in the last 60 days? -Why might these validators be gaining attention, why are people delegating to them?
Algo-77.Swapping for YLDLY on DEXs
May 21, 2022 - -- Q77. Let’s get a better understanding of how people are swapping Yieldly(YLDY: Asset ID: 226701642). -- Show us the total volume inflow and outflow of Yieldly(YLDY: Asset ID: 226701642) by day in 2022 then break it out by DEX as well. -- Is swapping for YLDY more popular on some DEXs than others? Additionally what assets are users swapping for YLDLY? -- Are there any standout days of swap volume for Yieldly? If so, write about what may have caused that spike. Note any other interesting findings related to YLDY swaps!
THOR-26. [Hard] Network Load
Dec 6, 2021 - What is the highest number of swaps THORChain has handled in a single minute? What is the highest number of swaps in a single minute broken down by each day? Hint Use thorchain.swaps
Thor-62.THOR-versary!
Apr 15, 2022 - Q62. THORChain Chaosnet just hit its 1-year anniversary. Calculate the following metrics, comparing THORChain in its first 30 days vs the last 30 days
11. CVX Whale Behavior
Feb 25, 2022 - How much CRV does CVX own? How much CVX have DAOs accumulated? Who are other top holders of CVX and/or CRV?
Thor-89.IL Protection By Pool
May 14, 2022 - -- Q89. Which pools have paid out the most IL protection in the last week? Month?
Algorand Scavenger Hunt
Jan 25, 2022 - What’s This For? The best way to understand a crypto project is to get involved in it yourself. We at Flipside are here to help you do exactly that. This set of steps is your portal into the world of Algorand (and all the data we’ve gathered to help you shine a light on its furthest expanses). Think of it as a “pre-flight checklist” for a space launch. Once you’ve completed these steps, you’ll be successfully immersed in the Algorand ecosystem, familiar with its core token (ALGO) and some of its core applications. Got questions? Reach out in the algorand-hunts or query-troubleshooting channels in our Discord.
10. Diversification of the Largest Liquidity Providers.
Mar 18, 2022 - -- Count the number of liquidity providers that are amongst the 100 largest providers in more than one pool. -- Which address appears most often in the list of the top-100 largest liquidity providers of different pools?
SUSHI-15. [Easy] Impacts of Price Changes
Dec 29, 2021 - The Sushi token has been trending downwards in price for the month or so. How do the changes in price affect trade volume? How do they affect number of users staking and amount staked?
Terra-129. Transactions on Wormhole
Jan 12, 2022 - Assess transaction size & volume of transactions on Wormhole. Define a number of buckets, e.g. Minnow, Fish, Whale, and group the transactions into them. How many transactions are in each bucket?
Abracadabra-2.[Easy] aUST Analysis
Dec 19, 2021 - Provide an analysis of aUST usage in the past 80 days. Employ at least two metrics of your choice and at least one data visualization. What opportunities do you see for aUST to add value to the Terra ecosystem?
87. [Easy] Ideal Airdrop Recipients: Part One
Oct 9, 2021 - As you have seen, many of the recent bounties are related to airdrops on Terra. This is because a number of Terra protocols are interested in the question: "who is the ideal recipient for airdrops? To whom do I want to airdrop my tokens, so that they become loyal and active members of my project?" We've provided some metrics that may help identify "valuable addresses", i.e. Terrans who are active, loyal members of the Terra ecosystem. This question is asking you to share the metrics you think are important. Share at least two metrics (more is fine) that you think are important to identify ideal airdrop recipients, and provide a brief description of how you would find these metrics with on-chain data. Note: Since every Terra project is different, feel free to talk generally, or to focus on a particular upcoming Terra project and talk about what metrics that project is likely to care about.
Thor-35. [Easy] Good Tidings of Great Fees
Dec 25, 2021 - Which wallet address has paid the most in fees over the last 30 days? Hint: Use thorchain.swaps
Angel-1. [Easy] Angel has risen
Jan 1, 2022 - How much has been donated to Angel's charity wallet so far this year? Create a visualization of your choice to show the donations either a) over time or b) by top donor. To be eligible for the grand prize, add your own analysis of charitable donations to Angel this year and make suggestions for increasing donations. HINT: The charity wallet address: https://finder.extraterrestrial.money/mainnet/address/terra1zxtczmxtw8mk8xncvr8lcq2qmvk4dz88ek6f79
69. [Hard] KRT vs UST Activity
Sep 14, 2021 - What are the top activities for KRT and UST holders? Provide analysis for how the behaviors of these holders overlap or are distinct and thoughts on why this may be the case (include data like staking yields if this makes the thesis for explaining the differences stronger).
Osmo-7.In The Stars
May 29, 2022 - -- Q7. Stargaze Zone is an IBC NFT launchpad and marketplace, and new launchpad projects drop on mint every Friday at 4:00 PM EST. -- Does the volume of swaps involving Stars change around this time? -- Analyze the volume of swaps involving STARS from March 20th until present. -- Hint: Use the msg_attributes table and select transactions that have an appropriate msg_type for swaps. -- The token address for STARS and other tokens can be found by joining to the labels table.
Sushi-63.Profit for AMMs
Apr 11, 2022 - -- Profit for AMMs -- Payout 20.33 SUSHI -- Grand Prize 60.99 SUSHI -- Level Intermediate -- Q63. What is the total profit (in dollars) per day that is generated from swaps out of the liquidity pools in 2022? -- Do you see a trend? Can you compare sushiswap with Uniswap?
50. Swap n' Slippage
Jan 29, 2022 - How does the size of a swap affect the slippage? Hint: use thorchain.swaps (from_amount_usd + swap_slip_bp columns). the swap_slip_bp column represents the slippage % * 100, so a swap_slip_bp of 72 represents a 0.72% slippage.
OlympusDAO - 5. My word is my bond
Apr 14, 2022 - -- Users can purchase OHM at a discount using bonds. -- What do they do with this discounted OHM? -- What proportion is staked vs sold? Has this changed over time? -- To be grand prize eligible, provide additional insights such as: -- what types of users sell vs stake, or what assets are purchased with discounted OHM.
THOR-14. [Hard] Pool Stats
Nov 3, 2021 - -- For each pool, show the following stats by day -- -Liquidity -- -Swap volume -- -Number of swaps -- -Total fees -- -Fees per $1000 swapped -- Hint: use daily_pool_stats
StepN Growth
Feb 26, 2022 - -- StepN is a Solana based ""move-to-earn' game (you earn the game's native token GST by moving around using their NFT sneakers and GPS system). -- The game has seen steady growth in popularity since it launched at the end of December -- (transitioned from a private beta mode to its current public mode). -- Create a visualization showing -- the number of unique wallets that have transacted with GST by day since January 1st. -- How much total GST has been transacted per day since January 1st? -- Provide some insights over the adoption of GST and how long it can accommodate its limitless supply as an in-game token.
Apollo-105. [Easy] Apollo’s Treasure
Dec 8, 2021 - During the $HALO farming event, how much new volume entered the Apollo vaults? Do you detect any trends? Provide at least one visualization to support your answer. Link to farm: https://farmers-market.apollo.farm/
ENS-5. [Easy] Was the ENS airdrop a secret?
Dec 12, 2021 - Look at ENS registrations before and after the cutoff date for the airdrop. Do you notice anything suspicious that makes you think that some people knew the airdrop was coming?
39.Sushi-TVL Sushi vs. Uni
Feb 13, 2022 - Question 39: Show the daily Total Value Locked (TVL) on Sushiswap over the past 3 months. How does this compare to the daily TVL on Uniswap over the same time period?
Forefront-4.Forefront Participation Incentives
Mar 28, 2022 - Q4. Compare the incentives for participating in Forefront with at least two other social tokens/DAOs of your choice citing two metrics of your choice. In terms of payout opportunities and upside, does the S2 Forefront seem optimal for encouraging development? Create a dashboard showing payouts aggregated for each role type and if each role has influenced what contributors do with their payments? What are some methods that would encourage payments to be reinvested into Forefront besides just time? Hint: Find all contributor addresses in the dashboard here https://www.forefront.club/dashboard Hint: treasury address 0x2Fb9F0ef424b24a8D293999298F392a33Fe6A8b5
ORBS-2. [Easy] Active Weekly Users
Dec 7, 2021 - Show the number of unique users (wallets) per week that transacted with Orbs over the past year.
[Flash] On-chain swap volume for UST <> LUNA
Jan 14, 2022 - - deliverable: show on-chain swap volume for UST <> LUNA relative to the daily $100 million redemption capacity
Thor-67.Impact of Terra integration on new wallets created
Apr 15, 2022 - -- Q67. Show the daily number of new Thorchain wallets created in the 10 days prior to and after the integration of LUNA and UST.
Uniswap - 6. Crossing that Bridge
Mar 18, 2022 - What percentage of Eth Uniswap users have crossed over to Polygon. How do they compare with Eth Uniswap users as a whole? Are they whales? Frequent traders? Create some compelling visualizations to support your findings.
[Terra-45] Chai Payments Dashboard
Aug 18, 2021 - What has the monthly volume of payments been on Chai over the past year? What have been the total monthly fees been on Terra over the past year?