Antonidas
12. [Easy] Wallet population
Oct 29, 2021 - Show the number of unique thorchain wallet addresses that have been created and done at least 1 transaction on thorchain. Show daily numbers as well as cumulative. Hint: use transfers
5. Olympus Pro Bonding
Dec 18, 2021 - Olympus Pro offers competitive bond markets where bonders effectively bid for the greatest discounts on different protocols native tokens. For each market, calculate the effective discount on the underlying protocol's native tokens over time. Additionally, provide insights to the following questions: - Are there key players in these bond markets? - What are the largest discounts traded in each market? - Are users generating profits by selling out after the vesting period?
105. [Easy] Apollo’s Treasure
Dec 4, 2021 - During the farming event, how much new volume entered the Apollo vaults? Do you detect any trends? Provide at least one visualization to support your answer.
6. [Easy] Number of LPs
Oct 23, 2021 - Distinct number of addresses in swaps in total and by pool, today and daily.
Have staking rewards impacted the amount of $RUNE bonded or in LPs?
May 22, 2022 - Q97. Chart an analysis on Staking 2.0’s effect on the pendulum incentive. Have there been meaningful impacts?
116. [Hard] NFTerra, Part 2
Dec 13, 2021 - -How many unique wallets own Terra NFTs? -How many unique wallets have purchased an NFT?
16. [Hard] Affiliate Fees
Oct 30, 2021 - What Addresses are being used to collect affiliate fees? What are the incomes over time? Hint: use swap_events Read this (https://docs.thorchain.org/developers/transaction-memos#affiliate-fees) and this (https://medium.com/thorchain/affiliate-fees-on-thorchain-17cbc176a11b) to find out how to identify affiliate fees
19. [Easy] Whale activity
Nov 6, 2021 - Among the wallets that own 10k+ RUNE, which pools are they currently LP-ing to?
Anchor Withdrawals over the last 24 hours
May 7, 2022 - Analyze the Anchor withdrawals over the past 24 hours. Identify the major addresses that are making withdrawals; display the withdrawal activity; highlight addresses who could be considered whales; and provide any insights into withdrawers and their activity
2. Visualize governance staking of $MINE over time
Oct 30, 2021 - What are the trends? Compare $MINE staking trends with $LUNA staking, do you think a lockup period would be beneficial? For those that have stopped staking, what did they decide to do instead in the Terra ecosystem?
Terra Explorer Hunt
Jun 24, 2021 - To show completion and receive your LUNA, make a dashboard that shows off at least two of the transactions you completed.
Interactive Users
May 5, 2022 - Determine the number of “passive” Terra users. By “passive”, we mean a user that is not initiating an action on Terra, but is somehow involved in an on-chain interaction. So, for a user sending LUNA from X to Y, Y would be the passive user. The complexity here is that not all passive users are involved in a transaction (see example txs).
55. [Hard] Fee Choice Analysis
Sep 12, 2021 - Develop a Flipside dashboard to display and analyze similar themes to this tweet: https://twitter.com/ashwathbk/status/1435668152831021056?s=20 Namely - which fee choice/tier is getting the most bang for their buck? Does the answer to this seem to be stable or fairly dynamic?
1. Free Square
Oct 30, 2021 - In this dashboard, we take a look at the Deposits in Pylon Pools for TWD Token
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.
4. [Easy] Total volume swapped by pool and over time
Oct 23, 2021 - Show the swap volume over time, broken down by each pool on THORChain.
19. [Easy] DeFi Saver Flash Loan Dominance
Oct 11, 2021 - What percent of flash loan traffic is driven by Defi Saver?
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.
5. Galactic Punks
Oct 30, 2021 - How much UST has been deposited into the lottery since it’s inception? What has been the average UST deposit amount?
3. [Easy] Monthly Swap Volume
Dec 4, 2021 - Show the total monthly swap volume of Orbs over the past year. How has the swap volume changed over time? Which DEX’s is most of the swap volume coming from?
ETH Interest
Aug 29, 2021 - What has the ETH interest rate been on Aave over the past 6 months? Also show the total supply of ETH in Aave over this time period as well. Is there any correlation between these two metrics? Why do you think this may be?
Mirror & Anchor TVLs
Jul 31, 2021 - How have the TVLs on Mirror and Anchor changed over the past two weeks? Are there any correlations that you can see? What might be some reasons for these relationships?
Daily Transactions and Unique Addresses
Aug 28, 2021 - ount and plot the number of daily transactions and unique addresses on polygon, beginning June 1, 2021. In your estimation, discuss whether polygon is still launching up, has reached a plateau, etc.
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?
9. The Next Big Thing
Dec 11, 2021 - What is the fastest growing pool in the last 30 days? Define any metrics that you use to determine what the “fastest growing pool” means.
24. [Easy] Swap Size Distribution
Dec 4, 2021 - What is the distribution of the size of swaps on THORChain? How does that differ based on the chain?
30. [Hard] Sankey Swap Diagrams
Dec 12, 2021 - Produce a Sankey chart of the most common swaps. Velocity doesn’t currently support Sankey charts, so feel free to get creative with how you produce them!
1. Active Weekly Users
Nov 14, 2021 - Show the number of active users (wallets) per week on Uniswap and Sushiswap over the past year. How do these two charts compare? Why might this be?
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