Hacks, Scandals and Scams - 3. Whales On Alert
Jul 24, 2022 - Question : 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 Hacks, Scandals and Scams - 4. CEL token flows](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Hacks, Scandals and Scams - 4. CEL token flows
Jul 29, 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?
![curve curve](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/project-icons/curve.png)
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?
$MATIC Staking
Sep 22, 2022 - How many $MATIC have been staked since July 1, 2022? What is the staking ratio of $MATIC (amount of $MATIC staked vs circulating $MATIC) during the same time frame?
Aave User Dashboard
Aug 10, 2022 - Create a dashboard that allows a viewer to input a user address and explore their borrowing and lending activity. Include metrics like total origination, loan revenue, outstanding debt, etc.
![AAVE and stAAVE movements AAVE and stAAVE movements](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
AAVE and stAAVE movements
Aug 11, 2022 - Create visualizations showing the following: Daily AAVE supplied and withdrawn on Aave protocol. Daily AAVE staked and unstaked.
Mitosis Expedition Mainnet
May 14, 2024 - This dashboard only contains Ethereum, Optimism, Arbitrum, Blast and Linea vaults data because flipside doesnt have Mode and Manta data.
Optimism Bridge Analysis
Oct 21, 2022 - Where are assets coming from, where are they going, and how are they used? How does activity on custom bridges compare to the standard Optimism bridge?
ETH Removed
Sep 14, 2022 - Examine user behavior in recent weeks leading up to the merge on at least 3 major protocols.
Liquidity Providers Stats
Aug 24, 2022 - Q109. Liquidity providers stats 1. Evaluate the distribution of various target segments who provide liquidity (LP): - What’s the total no. of unique LP providers? - What’s the ratio between Yield farmers vs. LP Providers? - What’s the average no. of LP positions opened by each unique wallet address - What’s the ratio of liquidity (Based on TVL) owned by the Protocol vs. Retail LP in both LP Pool and yield farms - The percentage (%) increase/decrease of LP Providers in Sushi over the last 1 year 2. Evaluate the profitability of an LP Provider & Yield Farmer - Evaluate if there’s a correlation between profitability vs. length of time? - Evaluate if there is a correlation between profit vs. time of withdrawal - Correlation between profitability vs type of pool? EX: stable pool
![curve curve](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/project-icons/curve.png)
True Freeze - 4. My Next Purchase
Jul 28, 2022 - What is the most common transaction (any transaction) users make after minting frETH?
NFT Comparison
Sep 16, 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