Friktion SOL vs mSOL Volts
Feb 21, 2022 - Friktion offers an income generating covered call product to users. A covered call option involves holding a long position in a particular asset, for example, SOL, and writing a call option on that same asset with the goal of realizing additional income from the option premium. How much SOL was deposited during the February 4th and February 11th epochs and how many unique users were in the SOL covered call volt? How much mSOL was deposited during those same epochs and how many unique users were in the covered call volt? Why do you think one volt has been gaining more adoption than the other?
Total Metamask Users
Jun 24, 2022 - Q1. How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking?
Sushi during Volatile Times II
May 29, 2022 - Q86. During the recent spike in market volatility, which chain saw the most activity in swaps for sushi? Polygon, Ethereum or Harmony?
$RUNE Price before & after Cap Raises
Dec 12, 2021 - In this dashboard, we will look into how cap raises will change the price of $RUNE with prices before and after three cap raises.
Folks Finance Deposits and Redeems
May 19, 2022 - Q68. Folks Finance enables borrowing and lending on the Algraond Blockchain. We are going to look at the deposits and redemption of the assets on the protocol. We want to get a better understanding of how wallets are depositing and withdrawing assets over time and how Folks Finance is growing.
Gard.Money Algorand’s First Algorithmic Stablecoin
Apr 18, 2022 - Q55. GARD is the world's first algorithmic stablecoin on Algorand's blockchain. Let’s look at the collateral debt positions(CDP) users are taking on. This is where users put ALGOs up as collateral and in turn get GARD(Asset ID 684649988) in return. Gard is a stable coin pegged to $1 in value.
Velodrome Health
Aug 16, 2022 - Q10. Create at least 3 metrics on Velodrome with a description for each that 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?"
Around & Around We Go (Circulating Supply)
Feb 21, 2022 - Question 151: Display the circulating supply of LUNA over the past 3 months. Use on-chain data for your calculation, but you are welcome to reference outside sources to support and validate your answer.
Pact.fi LP Pool Actions
Apr 30, 2022 - Let’s look at mint and burns for the Pact.Fi pools to see what pools users are most interested to stake their assets in.
CowSwap DEX Activity
Apr 19, 2022 - Q1. Using the Ethereum_core schema, find all transactions that interacted with the CoW settlement contract on ETH Mainnet (0x9008d19f58aabd9ed0d60971565aa8510560ab41) that also used Sushiswap as part of the execution. Why might they have done so?
Bridge Users (Hop Protocol)
Jun 19, 2022 - Q1. How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
Steady As She Goes
Feb 27, 2022 - A common talking point on Twitter is that LUNA is resistant to broader market downturns, when compared to other leading cryptocurrencies. Assess this claim, using data drawn from a time period of your choosing. In making your argument, acknowledge the unknowns and address potential criticisms of your chosen position. Additionally, clearly define your definition of stability or resistance to broader market pressures, as well as your benchmarks for comparison (i.e. what are you comparing LUNA to, and how does it perform vs. its peers/competitors?)
Active Daily Wallets
Mar 1, 2022 - Algorand Q30: Let's look at daily active addresses on Algorand. -Compare the number of active daily wallets for the month of January 2022 to December 2021 and January 2021. What day had the most active number of wallets in January 2022? Was there an event on Algorand associated with this date?
Pleasure to Burn
Feb 26, 2022 - How much LUNA has been burned over the past 30 days? How has the supply of UST changed over the same time period? Display both of these, using visualizations.
NEAR Performance
Jul 20, 2022 - Q5. How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.
IL Payout vs LP Age
May 7, 2022 - Show a breakdown of the average IL payout by the amount of time spent in the pool
Hop Whales
Jun 19, 2022 - Q3. Are whales choosing Hop to go to L2s? Or are they choosing the native bridges? Compare Hop vs the native bridges for Polygon, Optimism, and Arbitrum over the following metrics: unique users on each, frequency of use, and the average amount of assets moved on each?
Where’s The Pot of Gold?
Mar 20, 2022 - Q168. What % of the bAsset market cap for bLUNA and bETH is locked as collateral on Anchor? Show where else bLUNA/bETH is being held, and explain why you think this is.
Friktion's Crab Strategy
Apr 24, 2022 - Friktion recently launched a new product offering, Volt #03 - a volatility yield strategy for stablecoins in crab markets. Track the deposit activity into the Crab Volt. How many unique wallets have used the strategy since April 11th? What other Friktion Volts have these wallets used since March 1st? What is the crossover between the Volt #1 Bitcoin strategy and the Crab Volt? Why would a wallet prefer to use this Crab Volt instead of the other products?
Standardized TVL over time (all pools)
Apr 16, 2022 - Q64. Traditional TVL metrics are imperfect because they are influenced by both the quantity and price of the tokens over time. We would like to see a version of this metric that abstracts out the price influence on this metric.
Secondary Sales Activity
Jun 21, 2022 - Q2. How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings.
Balloonsville Rug Pull
Feb 22, 2022 - Balloonsville is an NFT project that launched on the Magic Eden marketplace on February 5th, 2022 and rugged the following day. Due to the nature of the rug, this caused a large controversy in the Solana NFT community. Since February 5th, what is the total volume of Balloonsville secondary sales on Magic Eden? Over the same time period, what is the average sales price of Balloonsville NFTs on Magic Eden? Create a visualization of the sales volume and price over time of Balloonsville NFTs and provide insights about any spikes or trends you see.