eileen-april
Anchor Dominance
Feb 14, 2022 - Question 148: What is the “Anchor dominance” for wallets on Terra? For active Terra wallets*, how much of their total asset value is held in Anchor at the time of analysis?
Top Pool Analytics
Jan 12, 2022 - For the top 10 Sushi liquidity pairs (by liquidity) show the following: liquidity, 24 hour volume, 7 day volume, 24 hour fees, 7 day fees, and one year fees as a percentage.
LUNA & Drawdowns
Apr 13, 2022 - Evaluate the price performance of LUNA following liquidation-inducing drawdowns. What is the average time (days) for LUNA to recover its previous price level. How does this period change relative to the size of the drawdown (in percentage terms)?
Sushi Token Activity
Jan 12, 2022 - Show the following for the past 30 days: Sushi staked (in USD), Sushi harvested (in USD), xSushi minted (in USD), and xSushi burned (in USD).
Outbound Traffic
Mar 16, 2022 - Question 166: The Terra Bridge has expanded its capabilities: https://twitter.com/Speicherx/status/1501883479457288193 Create a dashboard to track the outflows of LUNA and UST to Osmosis, Secret, Axelar, and Injective. What conclusions can you draw from the outflows thus far?
Airdrop Assessment
May 12, 2022 - Q4. Paraswap recently undertook a novel approach to conducting their airdrop. Provide a well-reasoned assessment: was this an effective airdrop design or not? What does it demonstrate about how to conduct airdrops to accomplish particular goals? How are you measuring these? Define and display at least two data-driven metrics for effective airdrops to support your answer.
It's Raining $RUNE!
Jan 18, 2022 - Which node operators have received the most rewards? Hint: Use thorchain.bond_actions
Uniswap - Monthly new users
Apr 9, 2022 - "Is Uniswap attracting new users? Using the last twelve months of Ethereum data, visualize the number of monthly new users onboarding to Uniswap. Definitions: -New users are addresses that have never used Uniswap before. -Onboarding to Uniswap means making any type of transaction on the protocol. Bonus points will be given to submissions that include data from other chains."
Average Price Shift for Synth Holders
Apr 14, 2022 - What is the typical price shift experienced by a synth holder? Compare the current price of the asset vs the price when they minted (relative to $RUNE).
124. [Easy] Anchoring LUNA
Dec 31, 2021 - Compare Anchor liquidations with LUNA price over time, discuss any potential correlations
MonkeDAO Validator
Feb 19, 2022 - The MonkeDAO was the first NFT DAO on Solana and also was the first NFT DAO to set up a validator in an effort to help decentralize and secure the network. When a user decides to stake their Solana, they delegate which validator to support with their staked Solana. How many unique wallets since February 1st have decided to delegate their staked Solana to the MonkeDAO validator? Create a visualization showing delegations per day.
141. Staking Yield, Mvmt. II: Anchor
Feb 3, 2022 - Imagine it is February 20 and the Anchor yield reserve has reached 0. Using data to support your answer, assess what the APY on Anchor Earn would be, based on LUNA staking yield and ANC incentives. How might this compare to stablecoin yields that are currently available from other protocols (not limited to Terra)?
126. [Hard] Liquidation Risks
Dec 31, 2021 - Explore the worst-case scenarios for liquidation on Anchor. When have the most liquidations occurred, how much, and how many users were impacted? Under what scenarios might significant liquidations occur again?
Bot Swappers
Apr 28, 2022 - Define bot swappers. How does the behaviour of bots differ from average swappers? For instance in terms of number of swaps, or in terms of distribution of swaps over a day. What percentage of swaps were executed by bots in the past 30 days? What pools and what pairs were most popular among bot swappers in the past 30 days.
Gainers and Losers
Jan 12, 2022 - Sort all of the liquidity pairs in terms of each of the following categories: fees in USD gained over the past 24 hours, volume in USD gained over the past 24 hours, and liquidity in USD gained in the past 24 hours. Repeat this process for the top 10 loser
Terra Builders
Feb 28, 2022 - Terra Q156: Imagine you are a Terra Developer. What are your main pain points? What tooling, services, and resources would make you more productive? Describe at least 2 pain points that make building on Terra more difficult (these can be technical but non-technical pain points are also acceptable). Describe at least two (2) services/tools/capabilities that would address these pain points. Provide a concise explanation for each of them and the value they would unlock. For example: Graph queries for Terra NFT index for Terra like Open Sea API used on Ethereum Terra Developer documentation For each capability you describe, provide a real-world example from another ecosystem and show how it enables/empowers developers in that ecosystem (can be another blockchain, but non-crypto examples are also acceptable).
Volume Market Share
Feb 13, 2022 - Question 41: Show daily transaction volume on Sushiswap as a proportion of the total volume across all of the DEXs over the past 60 days.
% of Solana Staked
Feb 13, 2022 - Using the "Events" table, what percentage of Solana that has been transacted is staked? How has that percentage changed throughout the month of January? Create a visualization showing % SOL staked over time. What is the average amount of Solana staked during a staking transaction?
