scottincrypto
Terra Tax Rate
Jul 17, 2021 - - How has the tax rate changed over the past 10 epochs (weeks)? -What dynamics in the other macroeconomic factors in Terra including Seigniorage Rewards and Total Staked Luna may have informed these changes? (Resource: https://docs.terra.money/dev/spec-treasury.html#observed-indicators)
Uniswap V3 Fee Volatility
Aug 14, 2021 - What has the day over day change in fee generation been for Uniswap V3 over the past 1 month?
Compound Crash Analysis
Jun 10, 2021 - What happened to leveraged borrowers with the crashes a few weeks ago? Please choose the metrics that were most impacted. Has anything similar happened in the past 6 months? Can we predict how long it will take for borrowing to recover based on past patterns?
DeFi Users vs. Newbies
Jul 5, 2021 - Are Uniswap users coming from other Defi projects? We want to understand if we are seeing a flow of users and tokens from other similar protocols or if many of the users are new to the DeFi ecosystem. To solve this challenge, you need to answer the following questions: - What is the USD-equivalent breakdown of tokens other than UNI in Uniswap users’ wallets/addresses? How has this changed over time? - Of users who have deposited in other pools/protocols, how much of their total wallet is UNI (share of wallet)? Has that changed over time?
Terra Transaction Fees
Jun 28, 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?
Terra Validators - Self Validating
Jul 27, 2021 - The following dashboard attempts to answer the questions: For the top 5 validators, what percent of the LUNA that they hold is their own as opposed to delegated to them? Has this proportion changed over time?
Exploring Mirror Airdrops
Aug 21, 2021 - A collaboration between ryanl and @scottincrypto
Compound Strategy
Jun 12, 2021 - Imagine you are deploying $50,000 to Compound. Devise a strategy that maximizes yield and characterize the risk of that strategy.
Compound Volatility
Jun 13, 2021 - In terms of borrowing, how often do APY rates change dramatically? Why might these changes take place? Show the sharpest changes in APY rates in the past six months and explain why these might have occurred.
Compound - How are miners benefiting from liquidations?
Jun 5, 2021 - The material below attempts to answer the question regarding the Compound Protocol: In the past 30 days, how much was paid in gas fees for liquidations? How has that changed over time? Are there any days that have stood out and a hypothesis as to why?
Typical Compound Users
Jun 11, 2021 - Understanding the typical Compound user - How many addresses have supplied to more than one Compound market in the past 30 days? How many addresses have borrowed from more than one market in the past 30 days? How many have done both?
EIP-1559 New Feature - Flexible Block Size
Aug 5, 2021 - The hype around EIP-1559 has centered on the burn of the basefee, potentially making Ethereum a deflationary asset. This dashboard will look an overlooked but important other benefit of the change - congestion management via elastic block sizes.
Compound Flash Loans & Network Fees
Jun 7, 2021 - This board attempts to answer the question of how have network fees impacted flash loan activity in the past 30 days? How has price slippage impact flash loan activity?
Uniswap Voting Behaviour
Jul 3, 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?)?
Terra New User Inflow
Jun 26, 2021 - Show new user inflow to Terra. Relate this to new user inflow to Mirror and Anchor - for example, are the majority of Mirror and Anchor users new to the Terra ecosystem? Are the Whales on the Terra ecosystem engaging with Mirror and Anchor? Note: Please include how you define "Whales"
Weird Column Header Behaviour
Jul 4, 2021 - When presenting a table with a decimal point in a column header, everything looks OK in the query window. When inserted into a dashboard, numerics come back as NaN and strings come back blank. Proof of concept below.
Terra Delegator Behaviour
Jul 25, 2021 - Map the behaviour of delegators versus non-delegators. Is there a distinct difference in where they engage in the Terra ecosystem? Tip - Start with the top 10 delegating and non-delegating accounts and scale from there.
Peg variance
Jun 27, 2021 - How stable are the stablecoins on Terra? Calculate how far from peg the stablecoins have performed in the past 6 months.
Decentralisation of Terra Validator System
Jun 27, 2021 - How decentralized is the validator system? Show the distribution of the staked amounts on the top nodes.
Community Treasury
Jul 16, 2021 - This page attempts to answer the question: Where in the world is the Terra community treasury address? What are some likely contenders and why?
Compound Flash Loans
Jun 6, 2021 - This dashboard attempts to answer the question: Find the transactions (loans) where a borrow event and repayment event occur simultaneously. How often are these loans taken out compared to standard loans? How do the dollar amounts of these loans compare to the dollar amount of standard loans? We make the assumption that a flash loan is where a Compound loan event and repayment event occur during the same block with the same borrower.
