Yakuza
Aave - 8. How does BTC funding affect rates?
Aug 9, 2022 - Create a dashboard that shows: Supply and lending rates for at least five tokens in Aave V2, andTotal amount of Wrapped BTC supplied over time.Provide analysis on the volatility of rates. Measure the correlation between USDC borrow rates and total wBTC supplied.
Optimism 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.
Velodrome Health
Aug 14, 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?"
Aave - 9. Historical APY Search Tool
Aug 11, 2022 - Create a tool that shows historical APY earned/paid on loans over a user-specified date range.
Activity of superfluid pools in the sharp increase in the price of OSMO (BTC/OSMO & ATOM/OSMO)
Jan 27, 2023
True Freeze - 5. Metrics on True Freeze
Jul 27, 2022 - Produce a dashboard showing metrics on True Freeze. At a minimum, visualize: the daily volume of ETH frozen, the daily number of transactions to freeze ETH, and daily early redemptions.
Total Metamask Users
Jun 23, 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?
Hacks, Scandals and Scams - 3. Whales On Alert
Jul 24, 2022 - Identify active wallets with a high balance of ETH (whales). Visualize the ETH transaction history of these whales in May and June 2022.
Hacks, Scandals and Scams - 4. CEL token flows.
Jul 28, 2022 - Celsius Network listed a $1.19 billion deficit on its balance sheet in a bankruptcy court filing a day after the cryptocurrency lender filed for Chapter 11. Currently Celsius owns a large portion of the CEL tokens. What are the top addresses swapping and transferring CEL? How have the CEL swap volumes changed over the past 90 days? How are Celsius wallets interacting with the CEL token?
Aave - 7. AAVE and stAAVE movements
Aug 6, 2022 - Create visualizations showing the following: Daily AAVE supplied and withdrawn on Aave protocol. Daily AAVE staked and unstaked.
True Freeze - 1. Early Redemptions
Jul 29, 2022 - True Freeze users can pay a fee to unlock their ETH early. What is the sum of fees paid for early unlocks? So far, what percentage of locked ETH was unlocked early?
True Freeze - 4. My Next Purchase
Jul 28, 2022 - What is the most common transaction (any transaction) users make after minting frETH?
Overtime Markets - Volume
Aug 20, 2022 - Analyze the total volume on Overtime Markets over the past two weeks. Which games received the most activity, both in total users and total $ volume? Which sports are receiving the most bets in total dollar volume on a daily basis? Explain your findings.
Osmosis 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?
NEAR Protocol or Project Dashboard
Apr 12, 2023 - Build a dashboard covering one of the top 10 NEAR projects by TVL featured on Defi Llama (https://defillama.com/chain/Near), a bridge into NEAR or a popular NFT marketplace. Show the activity and usage of the protocol. Some of the things to look at and consider are the number of unique wallets, asset volumes, swaps, LP actions, or fees- build a dashboard you think the protocol and the ecosystem would find useful to use and monitor the usage of the protocol.
NFT Comparison
Sep 13, 2022 - Compare and contrast the NFT market and ecosystem across at least three different chains (you can do more if you wish, but there must be at least three included.) Explain how the various chains differ in terms of metrics such as: Total Sales - Total Unique Buyers - Total Volume - Average Sales/Day - Average Buyers/Day - Average Sales Price/Day
$RUNE Movement from Crypto.com
Jun 20, 2022 - Q104. Show the in + outflow from cryto.com to native wallets over time. Are there any trends?