Antonidas
Thala Labs
Jul 19, 2024 - Dashboard done for competition: https://x.com/flipsidecrypto/status/1813574478808723612
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
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)
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
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?
Uniswap - Voting Power Distribution
Jun 25, 2021 - To vote on governance in Uniswap, you can choose to self delegate or delegate to a trusted party to vote on proposals for the protocol. In the past 30 days, what is the distribution of addresses to votes? How many smaller volume addresses are voting vs. larger volume addresses? Please include your defintion of larger vs. small. Learn more about voting here: https://uniswap.org/docs/v2/governance/guide-to-voting/ Example transaction: https://etherscan.io/tx/0xb8d9a5b7dc439111e7a3123fdce18edf586ff8eac377ca94cfd9a9ae778ac172
The Flipside Helpdesk
Mar 15, 2023 - This is "THE BEST" Dashboard to teach you everything about Flipside's Data Application.
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.
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.
15. [Hard] On-ramping
Oct 30, 2021 - What is the breakdown of new users on-ramping onto thorchain by chain? Show a breakdown of each wallet’s first thorchain transaction. Which chain are they coming from? Are they swapping for RUNE or for an asset on another chain? Hint: use swaps + transfers
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
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
Terra - Analysis of fees
Jun 24, 2021 - On Terra, transaction fees generated by token swaps work to maintain the peg of stablecoins to their associated fiat currency. How many fees are being paid out each day for the past 30 days? Do we see any big differences between the different stablecoins?