janan
Planetwatch Rewards
Jan 28, 2022 - - How many wallets have been rewarded for participating in the PlanetWatch Air monitoring program? - Show us how the number of wallets being rewarded daily changes over time. - Show us how the number of daily rewards has changed over time - What day were the most rewards issued? Was there an event correlated with this? - Who are the top 10 earners of Planets?
ERC20 Tokens (zkSync)
Jun 14, 2022 - Users can also deposit ERC20 tokens into ZkSync. Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days? Visualize and explain both findings.
Untitled Board
Nov 16, 2022 - Earlier this year, Optimism offered an airdrop to users. Let’s examine the airdrop after a few months. How many users claimed optimism airdrop? How much of total airdrop was claimed? How many wallets are still holding tokens from airdrop? How much of users delegated their OPs? Feel free to provide any information that you think is related to token price.
Tokemak Popularity
Mar 2, 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?
Total Rewards Distribution
Oct 27, 2021 - Question: Total block rewards distributed to nodes and LP's by day. Hint: Use BLOCK_REWARDS
More Mints
Apr 16, 2022 - How many NFTs have been minted over the past week? Since the beginning December, how many NFTs have been minted per week? Chart the growth of unique purchasers over time. What percentage of all mints have been via Metaplex's Candy Machine?
MoonBirds Crossovers
May 3, 2022 - Are there any notable cross overs between the Moon Birds community and other communities? How many holders also have BAYC, Doodles, etc
Layer 2 Blocks
Jun 29, 2022 - Q2. How many layer2 StarkNet blocks have been accepted on Ethereum (L1) chain so far? How much fees have been paid(generated) to Ethereum network? Has StarkNet contributed to saving in transaction fees for its users?
THOR Staking Wallets
May 20, 2022 - Q90. 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. How many unique wallets have staked $vTHOR? Chart this number over time.
Luart Trends
Feb 11, 2022 - What projects currently exist on Luart, and what have been their respective volumes? Create a visualization showing Luart trading volumes since its launch. What have been the 10 largest NFT purchases on Luart?
AB2 Gallery NFTs
Feb 3, 2022 - Let's take a look at one of the most popular NFT marketplaces AB2 Gallery get a better understanding of their marketplace performance. -Total Number of Assets Sold from AB2 Gallery? Daily Volume of sales in ALGOs from Assets being sold from AB2 Gallery? Daily Volume of assets being sold in from AB2 Gallery? What was the largest sale on AB2 Gallery?
MIM Use Cases Copy
Feb 9, 2022 - How is MIM used in comparison to USDC / USDT / UST or a stable coin of your choice? Describe user behavior. What protocols or contracts are users interacting with? Compare the count and volume of transactions
7. [Hard] ENS vs Gas
Dec 11, 2021 - ENS registration is cheap, but gas is not. Do more people register domains when gas is lower? Was there a spike in registrations when during recent ETH price dips?
Fuse Pool DAI Allocation
May 21, 2022 - How are the tokens in the DAI Vault being allocated into the various Fuse Pools?
Monthly Swap Volume
Dec 14, 2021 - Show the total monthly swap volume on ParaSwap over the past year. How has the swap volume changed over time? Which DEX’s is most of the swap volume coming from?
Most of swaps occurred last 30 days in Thorchain
Dec 24, 2021 - Which wallet address has performed the most swaps in the last 30 days?
Unique Addresses of AAVE
Oct 27, 2021 - Visualize the daily unique new addresses that use Aave on mainnet.
User Behavior
Jun 20, 2022 - What are users swapping for? What activities are the most common for users on Flow right now? Create a visualization on what’s causing spikes in swapping behavior.
174. The Red Planet
Apr 1, 2022 - "Define and assess two key metrics for the performance of Mars Protocol since launch. How is Mars doing, according to these metrics? Some example key metrics include: - number of depositors and borrowers - net LUNA and UST deposited and borrowed - Leverage farming strategies "
Sushiswap fees
Nov 20, 2021 - Show the total weekly fees collected each week over the past year. How has the total amount changed over time?
IL Protection Overtime
May 16, 2022 - Q88. With highly volatile prices recently, more IL protection has been paid out on THORChain. How do recent days or weeks compare to historical amounts?
2. [Easy] Restore Earth
Dec 23, 2021 - How much UST has been donated to the Restore Earth campaign? Which wallets are the top 10 donors and to whom do you think they belong? Conduct your own on-chain analysis to show your conclusions. To be eligible for the grand prize, add your own analysis of charitable donations to Restore Earth and make recommendations for charitable giving to reduce crypto-tax burdens in a jurisdiction of your choice. HINT: make a small sample transaction and use the transaction to identify the Restore Earth wallet.
Flow vs Other L1s
Jul 16, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum.
LP Size Distribution
May 2, 2022 - What is the current distribution of LP size for each pool? You will have to use both 'add_liquidity' and 'remove_liquidity' to determine which LPs are stil current.
Top Lido Stakers
Apr 27, 2022 - Use the ethereum_core tables to identify the top stakers using Lido. Do research on these addresses, can you identify any of these accounts using a mix of off and on-chain data?
ALGO Transaction Payment Size
Mar 31, 2022 - Let’s look at the quantities of ALGOs being sent in transactions since January 1st 2022 to see if we see any upwards or downwards trends. Group the transactions(algorand.payment_transactions) by size 0-10ALGOs, 10-100ALGOs,100-1000ALGOS, 1,000-10,000ALGOs and 10,000+ ALGOs. Count the number of transaction in each size and chart them by day from January 1st 2022 to current. Do we see any trends of increasing or decreasing payment sizes? What might this indicate for the Algorand network?
Active Users Weekly
Nov 14, 2021 - Show the number of active users (wallets) per week on Uniswap and Sushiswap over the past year. How do these two charts compare? Why might this be?
Active Daily Users
Dec 15, 2021 - Show the unique addresses depositing into Stader each day. How do these numbers compare to other protocols on the Terra blockchain? How much are these addresses depositing?
Algomint Bridge
Jan 28, 2022 - How much goBTC and goETH is currently in circulation? How much goBTC and goETH has been minted by users over time? How many wallets have minted goBTC and goETH? How much goBTC and goETH has been redeemed by users over time? If a user redeems their goBTC and goETH for their original asset do they redeem the whole amount or only a portion? Bonus: What is the average hold time for goBTC and goETH if a user does redeem their original asset?
Highest Sales Volume
Jun 13, 2022 - Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX? These are transactions where someone redeems their NFTX tokens for a specific NFT.
Avalanche BTC.b Bridgooors
Mar 15, 2023 - Let's look at wallets that have used the BTC.b bridge on Avalanche and what they are doing with it. Look at what chains users are bridging the BTC.b to with Layer0. Additionally, some other items to look at: What contracts and protocols are they using on Avalanche? How many transactions have they made on Avalanche? Are they swapping for other assets on Avalanche?
200K ALGO Donated Toward Tree Planting
Mar 8, 2022 - -Show the donations to the wallet over time. Has the donation wallet sent any of the ALGOs anywhere? If so, what addresses have most of the ALGOs been sent to? Have any of the ALGOs been sent to a centralized exchange(CEX)? If so, how much?
Secondary NFT Market Mega Dashboard
Oct 5, 2022 - Quix is Optimism's popular NFT marketplace, let's jump in and see the metrics about this marketplace, find out the most expensive collection of this platform, and illustrate the timing of the sales happening.
Liquidity Activity
Mar 7, 2022 - Question 2: Which liquidity pools and platforms are users using to acquire BANK tokens? Which tokens are being swapped most to acquire BANK tokens?
LoftyAI Tokenized Real Estate
Feb 28, 2022 - Algorand Q27: LoftyAI is a tokenized real estate platform(https://www.lofty.ai/). You can invest in property via tokens distributed by Lofty AI, each being worth $50. Rank the properties listed by LoftyAI based on total token investment price. How many wallets have bought a token for at least one property? What wallet has invested in the most Lofty AI properties? How many properties are they invested in?
Around & Around We Go (Circulating Supply)
Feb 22, 2022 - Question 151: Display the circulating supply of LUNA over the past 3 months. Use on-chain data for your calculation, but you are welcome to reference outside sources to support and validate your answer.
119. [Easy] NFTerra: Continued
Dec 18, 2021 - Using at least one data visualization and one metric of choice, analyze your favorite Terra NFT project over a time period of your choice. Using on-chain data to support your answer, explain why you think this project has strong potential in 2022.