Jabi
AAVE and stAAVE movements
Aug 9, 2022 - Create visualizations showing the following: Daily AAVE supplied and withdrawn on Aave protocol. Daily AAVE staked and unstaked.
Bored Phish
Jul 28, 2022 - This spring the Bored Ape Yacht Club Discord and Instagram accounts were hacked. The hackers sent a phishing link to the community. As a result of this phishing scam, users lost some Bored Apes, Mutant Apes, and other assets. How many NFTs were stolen? What is the total value of all NFTs stolen? Show the percentage of compromised wallets that bought back more NFTs from the same collection that was stolen.
AAVE Flash Loan Users
Jul 28, 2022 - Flash Loans allow users to borrow any available assets without putting up any collateral, as long as the liquidity is returned to the protocol within one block transaction. Show the frequency and volume of AAVE Flashloan use in 2022. Create a profile for a typical Flashloan user in 2022. Some of the metrics to look at could be wallet balance, transaction frequency, and dapps usage.
DOT DOT, Who's There?
Dec 12, 2022 - Like most assets in the last two years, DOT saw a meteoric rise in 2021 followed by a crater in 2022. However, DOT there still remains a little bit of DOT liquidity and volume flowing through Osmosis. Is the trading activity of DOT on Osmosis real user activity, or is this just arbitrageurs? How many users are active in Pool 773 every day, week, month?
Metrics on True Freeze
Jul 28, 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.
Uniswap Airdrop Phishing Attack
Jul 28, 2022 - In mid-July, there was phishing attack that used fake Uniswap tokens. Briefly explain the phishing attack. How many wallets were impacted by the attack? Calculate the aggregate token balance of the compromised wallets before and after the scam. What LP tokens constituted the largest share of stolen funds?
Not Your Keys
Nov 18, 2022 - In wake of the issues surrounding FTX, the old adage "not your keys, not your crypto" reinforces itself. Let's see how this played out during the fallout. Did bridge activity spike over the last 7 days? If so, to what ecosystems? At a more granular level, track net outflows from FTX onto Ethereum. Did any of these outflows flow across Satellite to another destination chain?
Tornado Cash Addresses
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online. (Hint: we also have them in our crosschain address labels table as well). Using those addresses: Which of the Tornado Cash addresses received the most # of transactions in the last month, quarter, year Which addresses received the most transaction volume (worth) in the last month, quarter, year Over all the addresses, group the transactions into buckets by value. How many tx in the 0.01-0.1 ETH range went to Tornado? How many in the 0.1-1ETH range? How many in the 1-10ETH range? How many in the 10-100 ETH range? How many above 100 ETH? (split further if better)
CEL token flows.
Jul 28, 2022 - 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?
Liquid Staking ETH Platforms Analysis
Sep 2, 2022 - Consider all possible liquid staking ETH platforms. Then, find out the following: How much ETH was staked over time? How many unique depositors are there? How likely are depositors to use multiple platforms vs using a single platform? Are depositors Dollar cost averaging their ETH into the platforms? What is the avg/median/max/min/distribution of ETH deposits? Compare all the metrics above between the various ETH staking methods/platforms
$MATIC Staking
Sep 18, 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?
Inflows and Outflows
Sep 14, 2022 - What is the volume of ETH and a stablecoin of your choice that's moved between the Optimism network and the Ethereum network across the bridge? How has that changed over time?
Cryptopunk Sales and Traders
Aug 29, 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.