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
FLASH - Critical Anchor KPIs
Dec 11, 2021 - The Anchor Protocol's public metrics are valuable but simplistic. With several billion dollars AUM, a deeper and more rigorous analysis is necessary to help the public - and potential investors and institutions of every stripe - review the fundamental health of Anchor. A rich, data-driven content bounty can help advise decision-makers and stakeholders on what specific metrics would be important for Anchor Protocol to track and visualize.
zkSync - Chainbase Hackathon
Oct 28, 2023 - Analysis done on zkSync using chainbase api to extract data...
Flash - Delphi
Nov 9, 2021 - The ask: We’re working on giving Delphi insights on some Terra data. A DappRadar report had mentioned that 2M daily unique active wallets interact with dapps, we want to see that stats on Terra alone. tl;dr: Query on-chain data to find the number of daily active wallets on Terra from the past 90 days and give an analysis on findings.
1. Olympus <> PoolTogether
Dec 15, 2021 - - How active is the PoolTogether OlympusDAO integration? - How unequal has the distribution of winnings been over time? - Which addresses have won the most sOHM?
The Typical Minter - Godmode Edition
Jun 8, 2022 - Analyze the Ethereum profile of those who minted during the first hour after launch. How many of them moved the minimum .1 ETH into their minting wallet vs. already had at least .1 ETH in that wallet? How many of them have been active in NFT purchases over the past six months? Can you construct a “typical minter” profile/profiles based on their wallet behavior?
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
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)?
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?
Uniswap - Increase/Decrease Liquidity Frequency
Jun 17, 2021 - How many times have unique wallets increased liquidity (using lp_actions) in the past week? How about decreased liquidity?
Daily New Users + Monthly
May 9, 2022 - Daily and Monthly new Wallets with an offset to account for Before Col-4 Data.
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".
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?
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..
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
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.
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?
The Flipside Helpdesk
Mar 15, 2023 - This is "THE BEST" Dashboard to teach you everything about Flipside's Data Application.
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!
Growth of New Users Buying/Minting NFTs
May 7, 2022 - Please replicate this graph for a comparison on the Ethereum and Solana blockchains.
1. Content Bounty: Spooky Web3 Tale
Nov 1, 2021 - Content Bounty: Tell your spookiest web3 tale - have you been rugged? Did you mistype a character in an address and lose funds forever? Have you had an hour of panic where a transaction cancelation wasn't going through or a transaction wasn't showing up? Reghoul the Flipside community with your trials and tribulations of degening across the multiverse.
