0xHaM-d
Arbitrum Network Health Check
Mar 30, 2023 - The Arbitrum token is officially in the hands of the broader crypto economy. Over 900M $ARB tokens have been claimed thus far, representing a vast majority of the total airdrop supply. Let's check in how the network is behaving and see what's going on in the Arbitrum economy. What are users doing with $ARB? Selling, bridging, holding? How's bridging activity? Are airdrop claimers bridging out? Are there non-airdrop allocated users entering the ecosystem - if yes, what are they mostly doing? What is the general network activity? Are certain platforms experiencing more or less volume? What is trading activity looking like? Are certain tokens being trading most? Are token prices depressed?
Bridge Volume (Hop Protocol)
Jun 21, 2022 - Q2. How much volume has Hop bridged to Polygon, Optimism, and Arbitrum compared to those protocols’ native bridges? What is Hop’s total TVL? Create an analysis on the Hop’s TVL and how it’s changed over a time period of your choosing.
Daily Active Users
Apr 9, 2023 - Based on the findings, we can draw some key insights: The Flow blockchain has experienced an increase in the number of new users since 2022. On March 31st, there was an uncommon spike in the number of daily active users primarily driven by transfer activity. The most popular contracts on March 31st were related to NFTs and Dapper Labs' offerings, with three Joyride contracts accounting for nearly one-third of all transactions. Even for the most popular contracts, the total number of users and transactions was significantly lower than on March 31st, indicating that this was a unique event. By analyzing user behavior and interactions with smart contracts, we can gain valuable insights into user engagement and experience, which can help optimize the network and improve user satisfaction.
Chain Swaps
Apr 26, 2023 - Squid Protocol has seen an increase in user activity since its announcement on February 23rd. Osmosis is the most popular destination chain for transfers, with Polygon being the primary source chain. USDC is the most popular asset transferred through Squid Protocol, and stablecoins make up the majority of transferred volume.
Sushiswap - 4. Sushi Stablecoin Activity
Mar 17, 2023 - What are the most actively traded stables on Sushi on Ethereum, Optimism, Arbitrum, and others? Chart monthly volume and inflow/outflow of stablecoins through Sushi on various chains. Which chain has seen the most stablecoin activity pick up in the last 3 months?
Squid DEX Usage
Apr 10, 2023 - Key insights from the Squid dashboard include the popularity of Quickswap and Curve.fi as DEXs for asset swapping, the growth of Squid since March with a peak in metrics, and the ability to monitor specific routes of interest. The dashboard also includes bridge platforms, real-time data, and provides valuable insights for users to make better-informed trading decisions.
Secondary Sales Activity
Jun 18, 2022 - Q2. How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings.
Joepegs, the top Avalanche's NFT Marketplace
Mar 19, 2023 - Use Flipside’s new fact_decoded_event_logs and ez_decoded_event_logs tables and build a dashboard covering either: one of the top 15 Avalanche projects by TVL featured on Defi Llama (https://defillama.com/chain/Avalanche), a bridge into Avalanche, or a popular NFT marketplace. Show the activity and usage of the protocol through the events. Some of the things to consider are the number of unique wallets, asset volumes, swaps, LP actions, or fees. Build a dashboard you think the protocol and the ecosystem would find useful to use and monitor the usage of the protocol.
Pooly NFTs
Jun 21, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
HODL or Sell?
Jun 15, 2022 - Q11. Identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. Have they held or sold their stETH?
wETH Deposit Rate
Jun 11, 2022 - Q11. Calculate the deposit rate of wETH over time on Osmosis.
Bridge Users (Hop Protocol)
Jun 18, 2022 - Q1. 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.