Antonidas
30. [Easy] Net Liquidity
Dec 17, 2021 - - How much liquidity is being added and removed from the THORChain pools over time? - Is there a noticeable trend?
Inflows and Outflows on Polygon
Aug 16, 2021 - What is the volume of ETH and a stable coin of your choice that's moved between the Polygon network and the Ethereum network across the bridge? How has that changed over time?
9. [Hard] Bridger Destinations
Sep 13, 2021 - Where do people go when they bridge to Polygon from Ethereum? What are the 10 most popular first destinations for Polygon addresses that have just bridged from Ethereum? What has this been for each day in the past month? Bonus: Use a network graph
14. [Hard] Pool Stats
Oct 30, 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
Aave Liquidity Concentration
Aug 19, 2021 - What percentage of the liquidity on Aave is provided by the top 10 liquidity providing addresses?
AAVE - GhostHunt
Aug 18, 2021 - Some of my deposits and withdrawals on the polygon network:)
4. [Easy] How Do You Like Your Eggs
Dec 15, 2021 - -How many Eggs are there? -What is the breakdown/count of Legendary, Ancient, Rare, and Common -What percentage of Meteors become Eggs?
Lido Hunt
Oct 8, 2021 - o show completion and receive your rewards, make a dashboard that shows off at least two of the transactions you completed and share it with us using this form.
10. [Easy] Pool Sizes
Oct 29, 2021 - What is the volume of each pool by TVL? How does that compare to the depth of each pool in terms of the unique number of liquidity providers? Hint: use daily_pool_stats + liquidity_actions
Transaction Fees
May 22, 2022 - How many transaction fees are being paid out each day for the past 30 days? Does a certain type of transaction result in a greater amount of fees being collected?
Liquidity Pools on TerraSwap
Jul 5, 2021 - What are the largest liquidity pools (by 24 hour swap volume) on Terraswap?
1. [Easy] Active Daily Users
Dec 15, 2021 - Show the unique addresses depositing into Stader each day. How do these numbers compare to other protocols on the Terra blockchain? How much are these addresses depositing?
3. Daily stETH Metrics
Oct 2, 2021 - Lido’s staked ETH (stETH) metrics questions: - Daily volume of stETH? - Average stake size? - Number of stakers over time? - Average time staked? - Percentage of stETH converted to bETH and bridged to Terra?
26. [Hard] Network Load
Dec 4, 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?
112. [Easy] Who Validates the Validators
Dec 12, 2021 - Tell us what makes an excellent validator, listing two or three validators as examples. Provide at least one visualization, using Flipside data, to support your assessment.
AAVE Best Pools
Aug 23, 2021 - Rank the top 5 Aave pools by fees paid by week over the past 6 months. Using metrics to support your answer, determine if they are fairly close to one another or is there one that is dominant. Provide a brief analysis of why the distribution that you find might be the case.
8. [Hard] Trading by time
Oct 23, 2021 - What time periods (GMT) see the heaviest swap, LP add/withdrawal volumes by asset?
113. [Easy] Top 10 Validators - Last 60 Days
Dec 13, 2021 - -How have the top 10 validators changed over the last 60 days? -How much LUNA has been delegated to each of the top 10? (change over time?) -Have the top 10 validators gained more voting power, or lost some? (is the Terra staking ecosystem becoming more widespread, or is it fairly concentrated between our top 10 validators?)
18. [Easy] Wealth distribution
Nov 6, 2021 - What is the distribution of wealth within the THORChain ecosystem? Show a histogram of the breakdown
20. [Easy] Aave Staking Reward Flows
Oct 16, 2021 - Identify the top 10 addresses by delegated voting power. Bonus: Identify whether these are individuals or syndicates
Anchor Collateral Ratio
Jul 31, 2021 - What has happened to Anchor's collateralization ratio over the past two weeks? What impact has this had on user behavior on Anchor? Pick at least 2 metrics to quantify the impact. (ie. TVL, 24hr volume)
Magic Eden vs OpenSea vs Random Earth
Mar 20, 2022 - Q39. Create a dashboard highlighting at least 3 metrics comparing marketplace performance and adoption between Magic Eden on Solana, OpenSea on Ethereum, and Random Earth on Terra since January.
27. LP Participation
Dec 12, 2021 - How many RUNE addresses are currently providing liquidity in 1 pool? 2 pools? 3+ pools?
77. [Hard] Apollo Inflow
Oct 4, 2021 - Where have the deposits into Apollo originated from? ie. How much came from UST vs. existing LP positions? How much new liquidity was added from the bridges and exchanges?
Terra - Peg variance
Jun 25, 2021 - How stable are the stablecoins on Terra? Calculate how far from peg the stablecoins have performed in the past 6 months.
Daily New Users + Monthly
May 9, 2022 - Daily and Monthly new Wallets with an offset to account for Before Col-4 Data.
21. [Elite] THORSwap Airdrop
Nov 19, 2021 - What did users do with the airdropped THOR tokens? Did they swap/hodl/LP? Were there any predictors of behavior (e.g. did those that got them from the THORStarter IDO more likely to swap? or were those that were active on THORSwap for a longer time more likely to hodl/LP?)
11. [Easy] Liquidity provision
Oct 29, 2021 - What is the daily change in volume of each pool over time (added + removed + net)? Now show the same chart, but instead of volume, show the number of unique LP-ers adding / removing liquidity each day. Hint: use daily_pool_stats + liquidity_actions
8. Swap Volume
Dec 3, 2021 - Compare swap volume on the top 10 pools -- what is the best stablecoin pool and any differences you notice between Ethereum and Polygon
25. [Hard] Same-Chain Swaps
Dec 4, 2021 - What percent of swaps occur on the same chain (e.g one Ethereum token to another) vs differing chains (e.g. BTC -> LTC)