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
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
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?
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.
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..
1. CRV Token Uses
Sep 13, 2021 - What else do people do with the CRV token (besides vote-lock)? Reminder: provide at least two visualizations to support your answer.
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?
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
The Flipside Helpdesk
Mar 15, 2023 - This is "THE BEST" Dashboard to teach you everything about Flipside's Data Application.
Distinct Wallets (Optimism Bridge)
Jun 14, 2022 - Q1. How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
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.
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?
Terra6 - Best Yield-Farming Opportunities for Terra assets on Ethereum
Jun 25, 2021 - Create a dashboard of the best yield-farming opportunities for Terra assets on Ethereum. Please note you will have to use the Flipside ETH tables (documentation provided here: https://app.gitbook.com/@flipside-crypto/s/flipside-docs/our-data/tables/table-schemas)
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.
20. [Hard] Aave Staking Reward Flows
Oct 11, 2021 - Analyze how Aave rewards (staking) are spent on mainnet -- are they reinvested into positions? Used to pay down loans? Simply liquidated/swapped for ETH?
Sample Hamas Dataset
Oct 27, 2023 - Can crypto-twitter OSINT outperform the WSJ’s chain analysis? Sample Data sold @ https://app.sollinked.com/AqsKuYXToEGneeKLFAxuXyPKHE4RCmgbXS4anj6NEfpr/content
Opensea Fees
Aug 17, 2021 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions. Show fees earned in USD total, and also by token amounts. Also show the top 10 NFT’s generating fees for Opensea on Polygon.
zkSync - Chainbase Hackathon
Oct 28, 2023 - Analysis done on zkSync using chainbase api to extract data...
Yearn - Treasure Hunt
Jul 30, 2021 - - Show your acquisition of YFI - Show confirmation of a deposit
