jackguy
yveCRV Vault
Sep 22, 2021 - How has the introduction of the yvBOOST Vault impacted usage of the yveCRV Vault?
Unique Users
Jul 26, 2021 - How many unique new users have been onboarding to Terra per day? How has this changed? What has been the largest event, project, or initiative that Terra has released so far in terms of how many unique new users joined that day?
LUNA Distribution Mvmt 1: The Basics
Jan 21, 2022 - People who do not like crypto often cite wealth inequality as a reason: they claim that the tokens are concentrated in the hands of a few whales. Assess this claim for LUNA. How much of circulating supply is held by the top 100 addresses? Top 1%? Top 10%? BONUS: compare this to wealth distribution vs. a country or an index of your choosing.
Impacts of UST on STBL
May 18, 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.
Dynamic Rate, Mvmt. I
Mar 19, 2022 - Based on defensible assumptions for key inputs (e.g. Anchor’s collateral blend and growth, as well as rates paid to borrowers), define a target range (+/- 1.5%) for the Anchor Earn rate that you think would be sustainable without regular capital infusions Assess the impact of declines in “earn rate” for other protocols, e.g. Aave, Compound, on key protocol metrics (e.g. user growth/decline, rate of user growth/decline, capital deposited, etc.)
THORChain Daily Reward Distribution
Oct 24, 2021 - Total block rewards distributed to nodes and LP's by day.
Solend
Mar 2, 2022 - showcase traction and success in a data-driven manner. Most importantly, your insights should help our readers answer the question ""How healthy is this project? what happens after a borrow of SOL on Solend?
Governance Participation Rate of UNI holders
Apr 1, 2022 - What percentage of current UNI holders voted on at least one governance proposal? What percentage voted on all five of the latest proposals?
ETH Interest
Aug 28, 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?
Anchor Emissions
Feb 21, 2022 - Create a table of all addresses that have made at least one Anchor borrow in the last 3 months. Do some basic analysis and produce at least one interesting insight about Anchor borrowers.
Rekt Dashboard
Nov 1, 2021 - What are the top 20 addresses that have been liquidated the most in USD equivalent value? What was the average collateralization ratio of their positions that got liquidated?
New Mirror Assets
Aug 10, 2021 - Pick two times from Jan-Jul 2021 when a new asset was introduced on Mirror - was there an increase or a decrease in volume or TVL for other existing Mirror assets when this happened? What does this say about how elastic capital on Mirror is to different asset offerings?
Network Load
Dec 6, 2021 - What is the highest number of swaps THORChain has handled in a single minute? What is the highest number of swaps in a single minute broken down by each day?
Algorand Price Correlation
Jun 30, 2022 - Is the price of Algorand more closely correlated with the crypto market, and assets such as BTC or ETH, or is it more correlated with network usage such as number of transactions or ALGO transfers?
THOR-versary!
Apr 18, 2022 - THORChain Chaosnet just hit its 1-year anniversary. Calculate the following metrics, comparing THORChain in its first 30 days vs the last 30 days
The Road So Far, Mvmt. I: Validators
Mar 16, 2022 - Provide a brief summary of what we have learned so far, via various bounties, about Terra's validator network.
Uniswap Defi and the Bear.
May 6, 2022 - When crypto prices drop, TVL decreases across most pools on Uniswap. When crypto prices drop, are LP's exiting pools or are they staying put? Visualize the price of ETH against net liquidity flows on Uniswap over time.
Most Popular ASA To Swap From ALGOs
Apr 14, 2022 - Let’s look at what ASAs(Algorand Standard Assets) are most popular to swap into from ALGOs in 2022 using the swaps table
V2 vs. V3 Volume
Sep 11, 2021 - Visualize the volume of trades on v2 vs. v3 over the past 6 months. Has the difference between the two stabilized or is it still dynamic? Elaborate.
Outbound Traffic
Mar 17, 2022 - 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?
Average Price Shift for Synth Holders
Apr 11, 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).
NFTerra: Continued
Dec 21, 2021 - Using at least one data visualization and one metric of choice, analyze your favorite Terra NFT project over a time period of your choice. Using on-chain data to support your answer, explain why you think this project has strong potential in 2022.
Deposit rate from L1s
Jun 11, 2022 - Look at users swapping from native L1 assets to $RUNE. Are there any trends by chain or over time?
Wormhole User Personas
Jan 12, 2022 - Investigate the Wormhole user base and establish user personas based on their on-chain behavior. What are the main types of Wormhole users? What conclusions can we draw about each user persona?
Algorand Assets Using Account Asset Table
Feb 4, 2022 - Lets explore the Account Asset Table and look at popular ASAs(assets) being held in the Algorand ecosystem: Using the Account Assets Table what are currently the top 10 most popular assets to hold outside of Algos?(Do not include any assets that include Pending Props in the name) For these top 10 assets lets map when they were added to users wallets over time? Create wallet holding distribution charts for 3 of the biggest projects in the Algorand Ecosystem: Yieldly, Opulus, SmileCoin.
Binance Comparison
Nov 24, 2021 - Compare transactions on the Binance Bridge (Ethereum-Binance Smart Chain) to Ethereum-Binance Smart Chain transactions via Wormhole. How do these compare over time? Provide and support a thesis for the relative usage of each and how it might change over time.
PEOPLE on the Secondary Market
Jan 24, 2022 - Has anyone bought PEOPLE tokens on the secondary market and then redeemed them instead of selling them or holding them? In cases where this happened, did they make or lose money?
Lockdrops Keep Fallin' On My Head
Jan 24, 2022 - Explain, in your own words, what a “lockdrop” is. Choose a metric for ASTRO tokens (price, circulating supply, amount sold vs. HODL) and display it visually over a time period of your choosing.
Vote!
Feb 14, 2022 - Create a visualization that compares the number of non-vote transactions to vote transactions per block since the start of February (hint, use the block table and the votes_block_agg table). What is the average ratio of votes to non-votes in a block? Have there been any timeframes of noticeable fluctuations of this ratio?
Prep for Flight
Jan 18, 2022 - Investigate the timing for people who use both Shuttle and Wormhole. For users who use Shuttle, how long is it before they adopt Wormhole? Do they continue using Shuttle after using Wormhole? If so, do they continue to use both protocols? How much? As with #132 - which may be helpful for this analysis - you have discretion to explore topics of interest. The goal, once again, is to understand the user bases for both Shuttle and Wormhole and to use their on-chain activity to investigate their motivations and incentives.
Chai Payments Dashboard
Aug 13, 2021 - What has the monthly volume of payments been on Chai over the past year? What have been the total monthly fees been on Terra over the past year?
Daily stETH Metrics
Oct 8, 2021 - Lido’s staked ETH (stETH) metrics questions: Daily volume of stETH? Average stake size? Number of stakers over time? Average time staked? Percentage of stETH converted to bETH and bridged to Terra?
Aave launches and TVL
Oct 6, 2021 - What effect does a new token launch have on AAVE's total TVL? Can you identify "cannibalization" effects (transfer of liquidity to the new protocol) from existing lending/borrowing tokens when a new token is added?
Standardized TVL Over Time
Apr 26, 2022 - Select one pool of your choice and show the total number of asset tokens (non-RUNE tokens) in that pool over time
ROI Reserves Pools
Jan 20, 2022 - Find the top 100 pools in terms of base reserves (in USD). What is the yearly ROI of these pools? Monthly ROI? Daily ROI?
Market Volatility
May 24, 2022 - The second week of May saw some huge volatility in the market and prompted many to sell their volatile assets and take a flight to safety.
Liquidity Space Voyage / Mini-Terra Tutorial
Jan 29, 2022 - Since the launch of Astroport, many have moved their liquidity from Terraswap pools to Astroport pools. Plot the total value of TVL that might have moved from Terraswap to Astroport for the LUNA/bLUNA pair by showing the total withdrawals from Terraswap and deposits to Astroport since Astroport launched.
Uniswap Governance
Mar 11, 2022 - Pick at least three data points that you think reflect the level of decentralization of the Uniswap Governance platform (e.g. UNI holders share, voting participation, voting trends, etc.) to analyze and comment on the trends and changes across different Snapshot off-chain votes and formal on-chain votes.