Ramahar
Phantom Wallet Growth
Feb 10, 2022 - On 31st of January 2022, Phantom (the most popular wallet in the Solana ecosystem) released its mobile app. There is an expectation that this will gradually increase adoption.
Metamask vs. Other Platforms
Jun 25, 2022 - Q3. How many users are swapping via MetaMask vs other platforms? How much volume have these users done? Chart a comparison between the two, and show the following metrics over a time period of your choosing: transaction volume, average amount swapped, and a comparison of fees.
118. [Easy] Terrarbitage, Part 2
Dec 15, 2021 - This dashboard showing wallets that have taken advantage of the LUNA-bLUNA pool, using i to multiply their LUNA holdings, risk-free.
Top LDO Holders
Jun 1, 2022 - Who are the top LDO holders on ethereum and where have their LDO come from? Did they buy it or was it an airdrop?
Flash Bounty: Miners Moving?
Sep 17, 2022 - How have miners reacted to the fast-approaching merge?
Where’s The Pot of Gold?
Mar 20, 2022 - What % of the bAsset market cap for bLUNA and bETH is locked as collateral on Anchor? Show where else bLUNA/bETH is being held, and explain why you think this is.
33. [Hard] THORChain Wallet Address Growth by Time Segment
Dec 18, 2021 - This dashboard is showing the creation of new RUNE address wallet in daily basis and find the relation of it with the THORChain growth rate. Using number of new RUNE address created per day as a metric to analyzed the event happened for 1. Pre-hack (before July 16, 2021) 2. Pre-Network Halt (Sep 24 - Nov 11) 3. Post-Network Halt (Nov 18 - present)
Algorand Scavenger Hunt
Jan 25, 2022 - This dashboard is showing the transaction I did for Algorand scavenger Hunt provided by flipside!
MonkeDAO Vote
Apr 3, 2022 - A month ago, the MonkeDAO pressed the Solana Monkey Business team for various changes to be made to the royalty and NFT structure to foster growth for the collection. Ultimately this resulted in the first NFT on-chain vote on Solana to accept or reject the SMB team's proposal, with a 'no' likely resulting in a separation of the two groups. In the end, the MonkeDAO voted to unify with the SMB team and to grow their relationship together. Track the wallets that voted yes and no for the SMB proposal. What were people's voting preferences based on the number of SMBs that they owned? What have these wallets done with their SMBs since the voting? Was the nearly unanimous voting a bullish event? Have wallets that voted yes bought more monkes? Were those who voted no more likely to sell after the fact and on which marketplace? What percentage of all monke sales involved a selling wallet that voted at all?
$OP Airdrop (Redux)
Nov 13, 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.
Untitled Board
Nov 6, 2022 - Observe Trading volume. Has one platform absorbed more volume than the other? How impactful is GNS volume to polygon? GMX volume to Arbitrum? Are there any insights that can reveal why Gains Network wants to move into the Arbitrum ecosystem?
Free Square
Jun 13, 2022 - How's native L1 Integration helps Thorchain to grow stronger as a Decentralized Exchange.
Staking SOL on Marinade
Mar 7, 2022 - Marinade Finance is the first non-custodial liquid staking protocol built on Solana. By staking SOL with Marinade, users receive mSOL tokens in return that can be used to explore other DeFi protocols and earn additional yield. mSOL can also be swapped for other tokens on decentralized exchanges like Jupiter and Orca. Create a visualization showing the amount of SOL staked on Marinade since the beginning of February. What is the average amount of SOL staked on Marinade per transaction, and what were the 10 largest transactions? Create a histogram showing the distribution of SOL staked per transaction. What are the most popular tokens that mSOL is swapped for on Jupiter?
HODLers vs LPers vs Stakers
Jul 11, 2022 - Q21. How are users in incentivized pools behaving vs. non-LP OSMO token holders? What about versus stakers? Create an analysis that shows activity for the various types of OSMO holders and chart out some additional activities they’re undertaking. Are users LPing or staking more likely to increase their amount staked? What group is receiving the most IBC transfers into Osmosis?
Gain or Lose
Jun 11, 2022 - Q10. Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap? Repeat the same analysis for stakers who have swapped stETH to ETH; how much ETH did they gain or lose?
THOR-versary!
Apr 16, 2022 - THORChain Chaosnet just hit its 1-year anniversary. Calculate the following metrics, comparing THORChain in its first 30 days vs the last 30 days: total number of swaps, volume of swaps (in USD), TVL, # of pools, # of chains. Feel free to add any other metrics you feel would be interesting / relevant.
Terra Grant Dashboard
Feb 11, 2023 - Examine grants funding since the launch of Terra 2. If possible, identify the grants transactions (feel free to supplement this with off-chain research to identify who’s been funded and in what amounts). Based on your investigation, produce a simple, clean dashboard that tracks grant funding thus far on Terra 2.
$NEKO is NEAR (first NEAR memecoin)
Feb 4, 2023 - The NEAR Foundation is running an "Insight of the Week" series. Keeping your analysis short and focused on excellent-quality visualization - provide the most fascinating or illuminating fact or insight that you can about the NEAR ecosystem, or any of the projects building on NEAR, over the past 7 to 14 days.
Have staking rewards impacted the amount of $RUNE bonded or in LPs?
May 28, 2022 - Before Staking 2.0, users participated in single-sided staking that rewarded LP-ers via emissions. Now, $THOR stakers receive a liquid token of their staked allocation, in addition to a percentage of fees from swaps. Chart an analysis on Staking 2.0’s effect on the pendulum incentive. What’s been the impact on the flow of funds into staking from LPs or bonded $RUNE, (have users been swapping from $RUNE to $THOR and staking?), and how that might be affecting the ratio of capital in LPs vs in bonds.
Daily stETH Metrics
Jun 7, 2022 - Q3. Find the following stETH metrics: -Daily volume of stETH? -Average stake size? -Number of stakers over time? -Average time staked? -Staking/unstaking per day?
Ethereum USDC-WETH pools on Uniswap-v3
Apr 26, 2023 - This dashboard showcases the generic analysis of USDC-WETH pools in Uniswap-v3. It includes several important metrics: such as users, transactions, and $USD volume. It provides the flexibility to view other USDC-WETH pools using similar metrics. The reader is able to grab the relationship between the $ETH token price and activity on USDC-WETH pools.
115. [Easy] NFTerra, Part 1
Dec 14, 2021 - This dashboard is showing the total volume of sales per day in Random Earth and Knowhere.
Daily Transactions and Unique Addresses
Jul 9, 2022 - Q1. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022. In your estimation, discuss whether Polygon is still growing, has reached a plateau, etc.
New NFT Mints
May 18, 2022 - How many total new NFT projects have appeared on Magic Eden per day since the start of the new year (as in new projects that have minted that day)? Compare that to the total number of new NFT projects that were minted/created on Ethereum?
29. [Hard] $RUNE Price after Cap Raises
Dec 14, 2021 - This dashboard illustrating the relative effect of #RAISETHECAPS event to $RUNE price which are currently happening in THORChads.
Squid DEX Usage
Apr 10, 2023 - The dashboard focusing on the DEX usage in EVM chains for Squid Router that perform General Message Passing (GMP).
Flash Bounty: Merge Staking Providers
Sep 5, 2022 - Choose 1 liquid staking provider (Ankr / Lido / rocketpool, etc) and answer the following question:
Stablecoin Popularity
Jan 30, 2022 - This dashboard is showing a visualization comparing USDC, USDT, and UST (wormhole) usage in transactions throughout the month of January. Analysis on UST to determine whether there is more adoption in the Solana ecosystem this month
Net Synth Amounts
Apr 30, 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.
Block Rewards vs Swap Fees
Apr 23, 2022 - Breakdown the yield from block rewards vs swap fees, both total and by pool. Show how the proportions have changed over time since the network started.
Node Operators Over Time
Jan 15, 2022 - This dashboard is showing the number of unique node operators have ever bonded $RUNE and how has that number progressed over time
41. Active LP-ers
Jan 8, 2022 - This dashboard will be showing the top 50 wallets for having the most transactions for adding and removing liquidity in THORChain pools. It served as the metrics to measure the RUNE wallet which actively updating their LP positions. In here, it also shows the pool selection for the top 50 wallets to add or remove their liquidity.