0xe3EB9D97882111bCE5C1b7B92563BE9Edb247215
Balloonsville Rug Pull
Feb 23, 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.
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?
Getting Your Feet Wet, Part 1
Mar 9, 2022 - Question 160: Make a table containing wallet addresses whose first transaction was 90 days ago or less. Analyze how active they have been since that first transaction, based on either 1) the number of transactions;
Spectrum scavenger hunt
Jan 27, 2022 - Exploring the Spectrum of pools available on Terra network.
Top TOKE Holders
Jun 21, 2022 - Identify the top holders of the TOKE token in January 2022, have they kept their position today?
Katana wLUNA Pool
Feb 20, 2022 - Katana's primary offering is a suite of accessible vaults that execute automated yield strategies in the background. One of such vaults is its Wormhole LUNA covered call vault, which offers appealing yield opportunities on LUNA especially during times of volatility. Shares represent your ownership of a Katana wallet and are needed in the withdrawal process to then remove funds from the vault. Create a chart showing the amount of Katana WLUNA Covered Call Vault Shares claimed since February 4th and the number of unique wallets that have claimed shares. What is the average size claim? Does it seem that the wLUNA vault is mainly used by "whales"?
Pooly NFTs
Jun 21, 2022 - How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
Bridge Users (Hop protocol)
Jun 20, 2022 - 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.
Phantom Wallet Growth
Feb 9, 2022 - This week, Phantom (the most popular wallet in the Solana ecosystem) released its mobile app. There is an expectation that this will gradually increase adoption. Track and visualize at least two metrics to compare growth in Solana activity in the start of February (when Phantom mobile launched) to the month of January.
Terra builders
Mar 1, 2022 - Terra Q156: Imagine you are a Terra Developer. What are your main pain points? What tooling, services, and resources would make you more productive? Describe at least 2 pain points that make building on Terra more difficult (these can be technical but non-technical pain points are also acceptable). Describe at least two (2) services/tools/capabilities that would address these pain points. Provide a concise explanation for each of them and the value they would unlock. For example:
Anchor - bLuna vs bETH daily
Jan 28, 2022 - How much of the collateral provided on Anchor is bLUNA vs. bETH? How has this changed over the past 90 days?
Visor Gamma Liquidity Pool Popularity
Feb 3, 2022 - What are the most popular Gamma liquidity pools by number of wallets and also by TVL? Which pool has seen the most growth this week?
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? Reference: https://app.friktion.fi/analytics/fcLUNA
Terra Altcoin Behavior
Feb 9, 2022 - Select a Terra “altcoin” (i.e. not LUNA/ANC/MIR) and assess their performance over the past 90 days, using a metric of your choice (examples: price, number of transactions, volatility.) What do you think are the prospects for your chosen altcoin?
Largest single swap in every THORchain pool
Jan 28, 2022 - For each pool, what is the largest single swap it has processed? (denominated in USD)
Distinct Wallets (zkSync)
Jun 14, 2022 - zkSync is a trustless, cryptographic secure, and low-cost layer 2 protocol for Ethereum. zkSync's popularity is constantly growing, especially with other layers underperforming. Our job in this task is to identify how many wallets have deposited ETH into zkSync in the last 60 days and how much was deposited daily.
Solana Fees - Jan 2022
Feb 8, 2022 - One of the main advantages for a user of Solana is the extremely low fees relative to other blockchains. Create a visualization showing transaction fees per day accumulated since the beginning of January. Also create a visualization that shows transaction fees per transaction on each day. Do fees ever seem to spike or is it consistent?
ERC20 transfers in zkSync
Jun 15, 2022 - zkSync is a trustless, cryptographic secure, and low-cost layer 2 protocol for Ethereum. zkSync's popularity is constantly growing, especially with other layers underperforming. Our job in this task is to identify which ERC20 tokens have been deposited the most in the last 60 days by $ volume and total count.