KowalskiDeFi
A world without Anchor Protocol
Apr 30, 2022 - Imagine a world without Anchor Protocol... What would be the impact on Terra ecosystem Focus on UST Growth, User Growth, Impact on Market Module. Create Charts & Dashboards to back your analysis.
Successful Bids on Kujira
Apr 10, 2022 - Determine the total unique users placing bids on Kujira since its inception. Compare bids on bLUNA vs bETH. What portion of these users is seeing their bids filled?
ERC20 Tokens (zkSync)
Jun 16, 2022 - Users can also deposit ERC20 tokens into ZkSync. Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days?
Unstakers | Osmosis
Jul 16, 2022 - How frequently do users on Osmosis unstake their Osmosis? What do they do with the OSMO once unstaked? Do they re-delegate, enter an LP position, or swap into another token? Do they re-delegate to specific validators more frequently than others? Why might this be so?
The Path To Riches
May 6, 2022 - Construct scenarios on cross Defi usage on Terra and how many wallets followed the suggested path For example: Use a CEX to buy Luna, Stake Luna on Lido, Deposit staked Luna on Anchor and Borrow UST, Use borrowed UST to buy more Luna on TerraSwap, e.t.c For fun, imagine you are a new Defi user with fiat money (no crypto exposure). What path would you follow? Can you map the whole process using on-chain data?
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)? Note: this question has the potential for a really interesting analysis in exchange for a big-time spend. We will award at least 1 bonus LUNA to all submissions of 11.0 or higher.
Bot Swappers
Apr 26, 2022 - - Define bot swappers. - How does the behaviour of bots differ from average swappers? - For instance in terms of the 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.
Nebula Scavenger Hunt
Apr 28, 2022 - - Purchase NEB via depositing UST Bootstrapping pool - (Optional) Stake the NEB tokens you acquired
Transactional Nature
Mar 27, 2022 - Question: In your own words, briefly explain how transaction volume relates to fees paid to stakers. Then, create a graph to show the fees derived from transactions and native swaps. Hint: Native swaps are swaps between LUNA and stablecoins (UST, KRT, etc) and vice versa
Ecosystem Anchor
Mar 15, 2022 - Question: Create a graph to show either: a) the token price (over a time period of your choosing) OR b) a bubble chart with total value locked, for all the Terra projects that depend on Anchor to create their yield.
Polygon vs Harmony
Jun 1, 2022 - Draw a chart comparing Polygon with Harmony on the following metrics: - Average tx_fee - Average number of transactions per hour
New Wallets In May | Algorand
Jun 13, 2022 - How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May?
Early Pool Activity
May 13, 2022 - For each pool, show the swap volume and the liquidity after its first week of going live (you can use the first swap date to determine when a pool went live)
Impacts of UST on STBL
May 15, 2022 - This week we saw the depeg of UST(a stablecoin built on Terra) and it sent shockwaves through all blockchain ecosystems causing the crypto market to crash. STBL is a 100% fully collateralized stablecoin created by the AlgoFi protocol. Let’s look at how the circulating supply of STBL was impacted by the events from May 8th to May 14th.
Trident
May 4, 2022 - Describe using a visual document how Sushi's Trident works and compare, if possible, with other similar products in Defi.
Cross-chain Anchor
Mar 30, 2022 - Question: Compare the Earn sides of Anchor protocol on Terra vs. Avalanche. What does the Earn side look like on Avalanche? In the last week, are people using it more? Is there more volume?
Mirror Fundraising
Jun 25, 2022 - How much total funds have Mirror raised? How many unique sponsors are there? How many total publications have been written? What are the most popular accounts?
Lost Anchor Funds
May 5, 2022 - There has been an increase in reports of new Anchor users losing funds. Analyze the following transactions, noting any suspicious user behaviour. How did these new users lose their funds? How can this be prevented?
Gas as a proxy of activity
Jun 8, 2022 - How much did sushi users pay for gas in 2022? Is there a correlation with the price of ETH? Can you comment on the spikes in the chart?
New Addresses
Jun 1, 2022 - Draw a chart showing the number of new addresses on the Polygon (MATIC) network every day. New addresses are unique addresses that appeared for the first time in a transaction of MATIC.
Redemption Arc
Apr 6, 2022 - Q177. Explore the limitations of redemption on Terra, i.e. the burn and mint mechanism. In what scenarios would the ability to burn & mint be insufficient for demand? Using data, illustrate occasions where these scenarios have occurred or come close to occurring. There are a number of ways to do this; one approach is to quantify a “Redemption Utilization”, i.e. a performance metric that encapsulates the extent to which demand for redemptions outstrips or comes close to the programmed caps, and then to explore the number of days over a specified time period that this metric has crossed a concerning threshold.
Top Kashi Pairs
May 14, 2022 - Find the top 5 Kashi pairs on Ethereum based on TVL. Choose one that you like and describe the following information: 1. How many people are borrowing this pair at the moment? 2. How much collateral has each user added to the pair? 3. How many users have already partially paid their loans?
Sushi x Optimism
Oct 23, 2022 - Show the contribution of SushiSwap to the growth of the Optimism user base. Measure the daily number of new Optimism users having interacted with SushiSwap in any of their first two transactions. What share of total daily new Optimism users do these new SushiSwap users represent?
Terra LP-ers: Aftermath
Jun 21, 2022 - What did people that were LP-ing in the Terra pools do? Are they just holding onto their $RUNE now or are they back in the arena LP-ing somewhere? Or did they sell their $RUNE and leave the ecosystem completely.
Let it burn!
Apr 23, 2022 - Find the week that the most volume of Luna burning happened. What caused this event? Show some effects this burning had on the Terra ecosystem in your opinion.
Distinct Wallets (zkSync)
Jun 14, 2022 - ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design.
Sushi and the Merge
Sep 29, 2022 - Analyze the behavior of Sushi MMs 2 weeks prior to and after the merge. How much capital did they withdraw? Which pools/chains got affected the most? Have they redeployed back their capital? Can we say anything about their identity (Tokemak, etc)?
Most Common Transactions
Jun 25, 2022 - What are the most common transactions for Metamask users? Create an analysis that shows the most common wallet activities and the most common platforms for those activities.
Transaction Failures
May 27, 2022 - Establish the failed transaction rate for Osmosis over the last 4 months. Make a case for what is causing the failed transaction rate that you assess and provide recommendations to mitigate it.
Price + Circulating Supply
Jun 8, 2022 - Draw a chart showing MATIC’s circulating supply from the start till today. Compare it with MATIC’s price.
Terra 2.0 Dashboard
Oct 7, 2022 - Core Metrics + Other (Only TRANSACTIONS/BLOCKS table is available for Terra 2.0 Core currently [2022-10-07])
Validator Voting vs. Investor Inclinations
Apr 27, 2022 - Analyze the last 5 governance proposals. Out of the total Luna that voted in favour, how many % are from validators vs. retail investors for each proposal and on average? Grand Prize Worthy: are there any cases you can identify where retail voters and major validators tended to vote against each other?
State of the State
Mar 9, 2022 - Review of data & suggestions for additions to the Terra Console
Bots and success rate
Apr 27, 2022 - Compare the success rate of transactions executed by bots in the past 60 days with average users' transactions in the same time period. Is there any difference and any trends identifiable?
Reactor Scavenger Hunt
Apr 29, 2022 - - Some UST to swap for $RCT tokens - A Flipside App account to prove completion; sign up here if you don’t have one
Stability Fee (May 13)
May 15, 2022 - How impactful is the stability fee (the interest rate) on DAI loans in terms of the impact on volume and dollar amount of loans taken out? How does an activity with DAI tokens change when the stability fee is different?
Yet another Acme Question
Apr 17, 2022 - Q184. Refer to submissions for #175 - your own, or those of others. Pick your favourite Terra metric or visualization and recreate your own version. Your SQL can be similar or even identical to the original, but you should put your own narrative and explanation. Why is this metric/visualization your favourite? If you improved it, what changes did you make?
The Nightmare Scenario
Apr 17, 2022 - Q183. Recently, attacks have been levelled against Terra, suggesting that it is doomed to collapse as UST reaches unsustainable levels. Specifically, concerns have been raised that at a low enough LUNA price, users will no longer be able to redeem $1 of UST for $1 of LUNA.