vivianngdora
Killer Crossover, Mvmt. I: LUNA/Solana
Feb 23, 2022 - Question 149: Friktion on Solana offers a “covered call” strategy for numerous assets, including LUNA. This strategy’s overall return depends on how often the call options are exercised, i.e. how often LUNA ends up above the strike price of the option. Determine how many weeks during the past month that LUNA’s price has increased more than 15% in a 7-day period. Based on this performance, what insights or implications can you draw about the true profitability of a LUNA covered-call strategy?
3. Active Wallet Growth
Jan 29, 2022 - What is the number of unique active wallets (signers) over the past 7 days? Create a visualization showing the number of active wallets per day since the start of 2022. What trends do you see?
Uniswap - 13. UNI token distribution
Mar 25, 2022 - What is the token distribution of UNI for active wallets (i.e. wallets with at least one transaction in the past 90 days? How much is controlled by whales (defined as you want, such as top 100, top 1000, top 1%, etc)? Does this distribution change if inactive wallets are included?
Pooly NFTs
Jun 23, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
Miso User Base
Sep 17, 2022 - Q112. Analyze the user base of Miso. How many users does it have across how many chains? Chart that by week and by month. Has the recent bear market affected that?
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.
Who's That Going Across My Bridge (Redux)
Apr 25, 2022 - Pick one bridge from Terra and a destination of your choice. (e.g. Shuttle bridge Terra <-> Ethereum or Wormhole Terra <-> Solana). Assess the daily and cumulative amount of UST that goes through that bridge, both inflow and outflow. How many users are using the bridge on a daily basis? How many transactions take place on a daily basis?
Sushi rewards distribution
Apr 28, 2022 - Sushi’s “merkle distributor” is the contract that is used to distribute the rewards in SUSHI to eligible users. There was a vesting period of 27 weeks during which the rewards were gradually being assigned to users. But the vesting period finished on Oct 12th 2021 at 7:10 PM EDT. After this time, users should call the “merkle distributor” in order to withdraw their rewards because no more reward is being vested. How much in total has been distributed so far? (A daily chart could help too) How much is left to distribute today? What percentage of eligible addresses have not claimed anything so far? How many eligible addresses have not claimed anything so far? What percentage of the eligible addresses are dead addresses (A dead wallet is a wallet that has not executed any transaction in the last 3 months)
Daily stETH Metrics
Jun 9, 2022 - Q3. Find the following stETH metrics: -Daily volume of stETH? -Average stake size? -Number of stakers over time? -Average time staked? -Staking/unstaking per day?
RUNE bonded + slashed amounts
Jun 13, 2022 - Q103. How much RUNE is bonded, how much RUNE has been slashed from those bonds (total and or over time)?
BendDAO Balance Sheet
Sep 8, 2022 - Q2. Build a comprehensive balance sheet dashboard for BendDAO. Include things such as collateral by collection, total debt, total reserves, utilization rates, and any other metrics you feel are relevant.
Tokemak Popularity
Mar 3, 2022 - Tracer Q3: Tokemak is a protocol that allows tracer governance token holders (TCR) to seek further ROI by way of yield farming. What is the popularity of Tokemak among tracer users?
14. [Hard] Revenue Distribution
Dec 24, 2021 - How much revenue has been generated from ENS name registrations since the airdrop? How much revenue has been generated from ENS name renewals since the airdrop? Create at least one visual depicting the relationship between these two revenue streams. How do you expect this dynamic to change over the next two years.
9. [Easy] Claimed Token Distribution
Dec 20, 2021 - What’s the average amount of ENS claimed from the airdrop? Create a histogram that shows claim size distribution.
Uniswap - 14. The DEX Kings of L1
Mar 26, 2022 - Uniswap is the leading DEX on Ethereum. Use the standard metrics to compare Uniswap with similar dominant DEX's in other L1 chains such as Raydium, Terraswap, Tinyman, etc
Stablecoin Dominance
Jun 28, 2022 - Q20. Compare the transaction volume for USDC, USDT, and DAI on Osmosis. Is there a stable coin that Osmosis users prefer?
Profit for AMMs
Apr 13, 2022 - Q63. What is the total profit (in dollars) per day that is generated from swaps out of the liquidity pools in 2022? Do you see a trend? Can you compare sushiswap with Uniswap?
Steady As She Goes
Mar 1, 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?)
Whale Transaction Volume
Feb 10, 2022 - Question 35: Show the daily swap volume of wallets with over 1 million Sushi tokens. How has this volume changed over time? How has the number of ‘whales’ changed over time?
Head to Head
Mar 31, 2022 - Q172. Excluding the respective foundations, what are the top 10 addresses by amount of UST held? What are the top 10 addresses by amount of DAI held? Do you have any guesses to whom those addresses belong?
Uniswap - 16. UNI Market Correlation
Apr 1, 2022 - Does the price of UNI correlate with the price of ETH? Compare this with the correlation of UNI to other DEX coins (such as AAVE, SUSHI, or anything else you find suitable)
Anchor Dominance
Feb 15, 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?
[25. [Hard] Same-Chain Swaps]
Dec 8, 2021 - In this dashboard, I will calculate the percent of swaps occur on the same chain as well as cross chain.
Bot Activity
May 17, 2022 - Q86. Create a way of identifying bots within THORChain (could be something like a certain number of swaps / day made). What % of the swaps and swap volume are made by bots? Are there certain strategies you can see them employing (most of them are likely arbitrage bots)? Are there many bots or mainly just a few that conduct a high % of bot activity?
Votes, Votes, Votes
Apr 22, 2022 - Q185. On average, how much voting power (in Luna) was used to vote 'YES' for governance proposals? Out of this, how much Luna comes from validators vs regular wallets?
31. - Sushi and Uni Gas
Feb 3, 2022 - Compare the daily ETH gas fees on Sushiswap over the past 2 months to those on Uniswap. Show the average gas fee per transaction as well as total gas fees collected.
124. [Easy] Anchoring LUNA
Dec 30, 2021 - Compare Anchor liquidations with LUNA price over time, discuss any potential correlations
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.
Tracking Realms DAOs
Aug 17, 2022 - Q104. We now have Solana Realms governace data! Their team would love to be able to see a list of DAOs / multisigs built on SPL Governance, and understand their: - Number of Members (assuming unique voters is what he means here) - Total Votes - Number of Proposals - Date of Last Proposal - Date of Creation Track these metrics and any other metrics that you find interesting for the following DAOs: Mango, Grape, Psy Finance, Solend, MonkeDAO, Metaplex, Jet, Serum, The Imperium of Rain, Synthetify
Hacks, Scandals and Scams - 3. Whales On Alert
Jul 30, 2022 - Identify active wallets with a high balance of ETH (whales). Visualize the ETH transaction history of these whales in May and June 2022.
Transaction Failure
Mar 22, 2022 - Q169. Make reference to this tweet: https://twitter.com/alphaDefi_/status/1504522066674003972/photo/1 Establish the failed transaction rate for Terra over a time period of your choosing. Is this analysis correct? Additionally, make a case for what is causing the failure transaction rate you assess, and provide recommendations to mitigate it.
Velodrome Locks
Jul 18, 2022 - Analyze new locks created on Velodrome Finance. What durations are most common? Which wallets have locked the most in the last 4 weeks? Which pools are wallets voting for with their locked tokens most often? For more information on Velodrome, please visit: https://docs.velodrome.finance/
The Law Offices of NEAR
Aug 4, 2022 - Q7. Provide your best assessment of the number of smart contracts deployed on NEAR and clearly outline your methodology (after all, contract lawyers love clearly specified terms). Visualize the number of new smart contracts deployed over time over a time period of your choosing. What are the top 5 new smart contracts interacted in that period of your choosing?
$THOR Staking Reward + APY
May 25, 2022 - Q93. Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards. Show the daily / weekly staking rewards and calculate the daily / weekly APR for $THOR stakers. How has it progressed since staking was introduced?
OlympusDAO - 3. Profile of an OHM Staker
Apr 16, 2022 - What are the top 3 protocols that OHM stakers have interacted with in the last 6 months?
Which 10 wallets are the most successful Cryptopunk traders?
Aug 30, 2022 - Which 10 wallets are the most successful Cryptopunk traders? Successful could either mean the wallet has accumulated a large balance from sales or has accumulated a large number of Punks. Explain your methodology and findings.
Stablecoins on Kashi
Jul 14, 2022 - Q102. Analyze the behavior of stablecoins on Kashi markets. Which ones are being deposited for lending? Which ones as collateral? Do this for both polygon and Ethereum. You can use the cross-chain sushi ez_lending and ez_borrowing.
2. [Easy] Active Weekly Users
Dec 8, 2021 - My dashboard will show the number of unique users (wallets) per week that transacted with Orbs over the past year.
Privacy Coins + Politics
Jun 12, 2022 - Q10. Do major news events result in more people swapping to SCRT? Look at the volume of swaps to SCRT over the past three months. Do periods of high volume swaps into SCRT line up with major international news events? Or is there a pattern in SCRT swap volume?
Quixotic NFT Dashboard
Aug 3, 2022 - Q7. Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism! Include any data you think is relevant in our Optimism tables and tell us the most interesting trends you can find with the secondary NFT market.
Bridge Volume (Optimism Bridge
Jun 17, 2022 - Q2. Compare user bridge volume on the Optimism Native Token Bridge vs. another Mainnet <-> Optimism Bridge of your choosing (e.g. Hop). Can we conclude if there are differences in the types of users or transactions using the native bridge vs. the non-native bridge?