janan
PLEASURE TO BURN LUNA
Feb 28, 2022 - Terra Q154: How much LUNA has been burned over the past 30 days? How has the supply of UST changed over the same time period? Display both of these, using visualizations.
Forefront Holders Distribution
Mar 30, 2022 - Create a histogram of token ownership amounts to understand the percentage of holders that buy tokens to provide access to these tiers. Where are token amounts most commonly distributed?
Aave Delegates
Mar 21, 2023 - How much gas was used by delegates voting in Aave in the past 90 days? In the past 180? How much gas on average is spent by voters in a single vote?
Magic Eden's Volume Trend
Mar 17, 2022 - Create a visualization of Magic Eden total sales volume per day since January 1st. How has sales volume trended over time? Are there any trends to when sales volume seems to go up or down on certain days of the week or during certain times of the day? Are users more likely to trade a NFT during the week or the weekend?
Merge Staking Providers
Sep 2, 2022 - How much ETH was staked? How many unique depositors are there? What is the avg/median/max/min/distribution of ETH deposits?
PEOPLE on the Secondary Market
Jan 26, 2022 - Has anyone bought PEOPLE tokens on the secondary market and then redeemed them instead of selling them or holding them? In cases where this happened, did they make or lose money?
Solana TPS
Feb 20, 2022 - One of Solana's main features is its speed compared to other blockchains. Blockchain performance is usually measured in Transactions per Second (TPS). Measure the TPS of Solana in February (non votes) and 'Successful TPS' per day and create a chart showing how TPS has fluctuated during that time period.
Transaction Fees
May 22, 2022 - How many transaction fees are being paid out each day for the past 30 days? Does a certain type of transaction result in a greater amount of fees being collected?
Fuse Pools USDC Allocation
Mar 24, 2022 - How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
Phantom Wallet Growth
Feb 9, 2022 - Question 5: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.
Unique Programs
Feb 12, 2022 - One way to track developer growth in an ecosystem is through the number of unique contracts used. Create a visualization of the number of unique programs used per day since the beginning of January. What are the 5 most commonly used programs over that timeframe? What do those programs do and why do you think they are so popular?
1. Most Popular ASAs
Jan 10, 2022 - - What are the most popular ASAs on Algorand? - How many wallets are holding each ASA? - How many transactions happen with these ASAs? - How have these stats changed over time?
Transactions on Wormhole
Jan 8, 2022 - Assess transaction size & volume of transactions on Wormhole. Define a number of buckets, e.g. Minnow, Fish, Whale, and group the transactions into them. How many transactions are in each bucket?
MIM Use Cases
Feb 7, 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
Pool Depth
Nov 8, 2021 - What is the current depth of each pool based on the number of LP-ers currently providing liquidity? Hint: use liquidity_actions
Anchor Emissions
Feb 22, 2022 - Question 152: Create a table of all addresses that have made at least one Anchor borrow in the last 3 months. Do some basic analysis and produce at least one interesting insight about Anchor borrowers.
3. Active Wallet Growth
Jan 29, 2022 - What is the number of unique active wallets (signers) over the past 7 days? Create a visualization showing the number of active wallets per day since the start of 2022. What trends do you see?
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.
Thorchain Most Fees
Dec 24, 2021 - Which wallet address has paid the most in fees over the last 30 days?
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.
Defly Token Launch
Feb 24, 2022 - Defly is a mobile wallet and swapping platform that is currently being developed on the network. They recently had there token presale and liquidity pools have been provided for swaps on Tinyman.
14. Transaction Fees
Jan 30, 2022 - All transactions on Algorand have a transaction fee of .001 but let's dive a little deeper into fees generated on Algorand. What is the total amount of fees generated on Algorand since the first block? Plot fees generated over time by day on Algorand since the beginning of 2021. Create a table of the top 10 wallets that have generated the most amount fees in 2022. List both numbers of transactions and fees of the wallets. Using the asset transfers table, what are the top 10 assets besides Algos that have generated the most fees?
Calculate Earnings
Mar 19, 2023 - Find out how much an address earned from MetricsDAO & Flipside(coming soon!) bounty program.
xMETRIC
Oct 7, 2022 - MetricsDAO provides organized on-demand analytics for protocols, L1s, and scaling solutions.
Most Common Transactions
Jun 25, 2022 - What are the most common transactions for Metamask users? Create an analysis that shows the most common wallet activities and the most common platforms for those activities.
L1 Unique Users
Mar 17, 2022 - Question 37: Compare the number of unique wallets that have sent a transaction since February 1st on Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Solana compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?
Untitled Board
Sep 5, 2022 - Show the most common actions taken by users on NEAR (new users using NEAR for the first time) over the past 3 months.
Uniswap - 17. Fastest Growing Pool
Mar 31, 2022 - What is the fastest growing pool in the last 30 days? Define any metrics that you use to determine what the “fastest growing pool” means.
Token Activity
May 12, 2022 - Q3. What do people do with their PSP tokens? Once people acquire PSP tokens what do they do with them? Do they stake them? How long do they hold them for? Show the journey of PSP tokens.
Stargate User Growth
Apr 27, 2022 - How many unique users are staking capital on Stargate on Ethereum each day since its inception? What might this suggest about the protocol's growth?
Current Wallet Rewards
Jan 31, 2022 - Let's check out the rewards wallets have received. Show the distribution of rewards among wallets. (Look at the total rewards column in the account column for the current rewards total distributed to each wallet) Do we see wallets that are more engaged in the ecosystem receive more rewards? (Look at the total number of transactions by wallet and plot that against total_rewards in a scatter plot) We should see a correlation between a wallet size and total rewards received. Is this true? (Plot the wallets' current balance against total rewards received with a scatter plot)
Tracer Distribution Daily
Mar 2, 2022 - Tracer Q1: Out of the initial allocation of funds in the treasuryDAO, how much (in TCR) has been distributed per day to the users?
IL Protection by Pool
May 15, 2022 - Q89. Which pools have paid out the most IL protection in the last week? Month?
Algorand Unique Users(Addresses) Growth
Feb 6, 2022 - Question 18: Let's look at the growth of Chart how many unique wallets are added each day(Tip: Use the Account Table) Do we see an increase in wallets created during the governance commitment periods compared to non governance commitment times? Governance Commitment Period 2: September 20th 2021 - October 14th 2021 Governance Commitment Period 2: Dec 24th 2021 - January 1st 2022
Polygon Block Performance
Jul 24, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two locks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
End of Year CEX Transfers
Jan 18, 2022 - Did the volume of transfers to centralized exchanges increase towards the end of December compared to the volume of transfers at the beginning of December? (Hint: you will need to use the "Labels" table). Create a visual to show the trend of these transfers in the month of December. Based on the trends you discover, give some reasoning to why this occurred.