Thala Labs
Jul 19, 2024 - Dashboard done for competition: https://x.com/flipsidecrypto/status/1813574478808723612
![19. [Easy] Whale activity](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png "19. [Easy] Whale activity")
19. [Easy] Whale activity
Nov 6, 2021 - Among the wallets that own 10k+ RUNE, which pools are they currently LP-ing to?
pixel chart
Oct 28, 2023 - inspired by https://twitter.com/hildobby_/status/1717910521091940696
Voting Behavior
Jul 1, 2021 - Let's talk voting behavior. Pick the top 5 addresses that have had tokens delegated to them for voting; define the metric that makes them the largest; and briefly review their voting history over the past 6 months. Are there any common trends (ex. are they voting frequently or infrequently? Are the top 5 addresses tending to vote the same way?)?
17. [Easy] Who is getting Aave Rewards?
Oct 4, 2021 - Do a breakdown of who is getting rewards from lending/borrowing markets as well as from the staked Aave (stkAAVE) Pool.
Terra Mega Dashboard
Oct 15, 2023 - Requested by https://x.com/Levana_protocol/status/1713467396470509613?s=20. Maintained for TerraGrowthDAO
Getting Your Feet Wet, Part 2
Mar 6, 2022 - Question 161: Assess the extent to which new users interact with each of the following projects. For Definition, clearly define what “interact with” means, e.g. “at least 1 transaction”, “at least 5 transactions”, etc. Anchor, Mirror, Pylon, Astroport, Terraswap, Prism, Mars Bonus: to be eligible for the grand prize, complete at least one of the following: Display at least one visualization to demonstrate project participation, e.g.. “total # of users who have used each project”, “total # of transactions by project”, “TVL by project”. Include Randomearth, Knowhere and your analysis
Contractually Obligated
Mar 6, 2022 - Question 162: Based on your analysis for #161, provide the top 20 smart contract addresses that users interact with or the top 2 smart contract addresses per each of the protocols that you previously analyzed. Grand prize-winning submissions will assess both!
78. [Hard] APY Strats
Oct 4, 2021 - Develop a yield farming strategy that optimizes for APY using the Anchor and Anchor companion protocols. How does this APY compare to APY's that can be achieved on other platforms/protocols?
Flow Mega Dashboard
Mar 18, 2023 - Made this dashboard for the Flow Blockchain as an example to illustrate all the different techniques we can use based on "The Flipside Helpdesk".
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
stETH vs ETH
Jun 9, 2022 - Q2. How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
9. [Easy] Claimed Token Distribution
Dec 18, 2021 - What’s the average amount of ENS claimed from the airdrop? Create a histogram that shows claim size distribution.
ETH Price Drop and Liquidity Pools
Jun 26, 2021 - With ETH dropping below $2000 how is it affecting the liquidity pools for ETH? Are people decreasing liquidity of their v3 pools and re-entering it in a new range or are they staying put? With the people who are decreasing liquidity and not coming back in are they holding the amount they took out of their positions or are they moving it to another DEX pool (Sushi, Uni v2)?
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?
The Flipside Helpdesk
Mar 15, 2023 - This is "THE BEST" Dashboard to teach you everything about Flipside's Data Application.
Stat of the week - Polygon Gas
Feb 18, 2023 - Polygon's average gas price has been increasing in the last few days. Lets take a deeper dive into what's going on..
26. [Hard] Whale Activities (besides having diamond hand)
Oct 24, 2021 - hat are the most active Aave users doing differently on Mainnet vs. Polygon? Analyze metrics like use of leverage, transaction frequency, and volume.
25. [Hard] Most Popular Aave vs. Compound Combos
Oct 24, 2021 - Identify the 8 most popular supply + borrow combinations on Mainnet Aave and Compound (by volume). How do they vary? What is the Net APY for each on each platform?
zkSync - Chainbase Hackathon
Oct 28, 2023 - Analysis done on zkSync using chainbase api to extract data...
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
DeFi Users vs Newbies
Jul 1, 2021 - Are Uniswap users coming from other Defi projects? We want to understand if we are seeing a flow of users and tokens from other similar protocols or if many of the users are new to the DeFi ecosystem. To solve this challenge, you need to answer the following questions: - What is the USD-equivalent breakdown of tokens other than UNI in Uniswap users’ wallets/addresses? How has this changed over time? - Of users who have deposited in other pools/protocols, how much of their total wallet is UNI (share of wallet)? Has that changed over time?
