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?
Ambient on Blast || Power vs. Normie Users
May 4, 2024 - This dashboard delves into users on Ambient Finance by tracking their transactions and retention rates. It also distinguishes users using a Pareto approach to identify power and normie users.
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.
The Typical Minter
Jun 9, 2022 - Analyze the Ethereum profile of those who minted during the first hour after launch.
Stable Coins Lent on Kashi
Jun 12, 2022 - Q92. Draw a chart showing the TVL of Stable coins on kashi pairs across all markets.
Osmosis - 4. WAVAX Activity
Feb 5, 2023 - Last week, wrapped AVAX (WAVAX) was listed on Osmosis and seeded with liquidity via Pool 899 (OSMO/WAVAX). Analyze WAVAX activity over its first week of trading on Osmosis. How does WAVAX trading on Osmosis compare to native swaps on Avalanche? Hint: leverage Flipside's Avalanche tables to complement your analysis.
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.
RaceDay NFTs
Feb 25, 2023 - The Addressed issues in this dashboard are include: How does Speedway Motorsports RaceDay NFTs stack up to sports NFT collections in the FLOW ecosystem? What other projects are RaceDay fans buying? The assessed Metrics: Average Sales volume Total Sales Volume Secondary Sales vs. Mint Sales Daily Average Sales Price and 7-day moving average Total Unique Buyers Average Buyers/Day Social Mentions/Shares Cross-Project comparative assessed metrics: Other collections RaceDay fans are buying Purchase frequency, or the distribution of tokens owned per wallet Average Number of NFTs held per wallet Average Purchase Price of NFTs held by RaceDay fans BONUS: Find free redemption buyers to future buyers, i.e., were first time purchasers someone that claimed a free NFT previously, or, was their first experience with RaceDay an actual purchase.
The Footprint of Top 100 Airdrop Hunters
Sep 7, 2023 - Welcome to monitoring airdrop hunting by top hunters. In the current dynamic dashboard, we track the activities of the top 100 airdrop hunters on ZkSync, Base, and LayerZero networks, which are expected to be of interest to nearly all airdrop hunters. The queries are dynamic and are updated every 24 hours, so it may take a few minutes to load all of the visualizations
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.