agentleFS
SperaxSperax/sperax-skills/skills/onchain-analytics-guide/SKILL.md

onchain-analytics-guide

Skill8 starsChanged 9 months agoMITView on GitHub

Guide to on-chain analytics — wallet tracking, whale watching, TVL analysis, DEX volume, token flow analysis, and governance activity. Use when helping users analyze on-chain data, track wallets, evaluate protocols, or identify trends.

The file

Files
SKILL.md

On-Chain Analytics Guide

On-chain data is transparent and immutable. This guide teaches AI agents how to leverage it for better DeFi decisions.

Key On-Chain Metrics

Protocol Health

MetricWhat It Tells YouWhere to Find
TVL (Total Value Locked)Protocol adoption and trustDeFi Llama
TVL Trend (30d)Growing or shrinking?DeFi Llama
Unique Users (DAU)Real adoption vs bot activityDune Analytics
RevenueSustainable or dependent on emissions?Token Terminal
Protocol-owned LiquidityResilience to mercenary capitalOn-chain

Token Metrics

MetricWhat It Tells YouSource
Holder CountDistribution breadthEtherscan/Arbiscan
Top Holders %Concentration riskEtherscan
Transfer VolumeReal usage activityBlock explorer
Exchange Inflow/OutflowSell pressure vs accumulationGlassnode, Nansen

DeFi-Specific

MetricWhat It Tells You
Utilization RateLending demand (Aave/Compound)
Borrow APY vs Supply APYMarket's cost of leverage
Liquidation VolumeMarket stress indicator
DEX VolumeTrading activity and fee generation

Wallet Tracking

Why Track Wallets

  • Whale watching: Large holders' moves signal confidence/concern
  • Smart money: Track known profitable addresses
  • Protocol treasuries: Monitor how teams spend funds
  • Governance: Track voting power concentration

How to Track

ToolFeaturesCost
Etherscan/ArbiscanBasic transaction history, token holdingsFree
Arkham IntelligenceWallet labeling, entity identificationFree tier + paid
NansenSmart money tracking, portfolio analysisPaid
DeBankMulti-chain portfolio viewFree
ZapperDeFi position trackingFree

What to Look For

Bullish Signals:

  • Whales accumulating (moving tokens off exchanges)
  • Increasing staking/locking (e.g., SPA → veSPA in Sperax)
  • Protocol treasury diversifying into productive assets
  • Growing number of unique holders

Bearish Signals:

  • Large exchange inflows (potential sell pressure)
  • Insider wallets unlocking and transferring
  • Decreasing TVL despite stable token price
  • Team wallet selling

Dune Analytics Queries

Dune lets you write SQL queries against on-chain data. Useful queries:

Protocol TVL Over Time

SELECT date_trunc('day', block_time) as day,
       SUM(amount_usd) as tvl
FROM protocol_deposits
WHERE protocol = 'sperax'
GROUP BY 1
ORDER BY 1

Daily Active Users

SELECT date_trunc('day', block_time) as day,
       COUNT(DISTINCT sender) as unique_users
FROM transactions
WHERE to = '0x...' -- protocol contract
GROUP BY 1
ORDER BY 1

Top Token Holders

SELECT address,
       balance,
       balance * 100.0 / total_supply as pct_supply
FROM token_balances
WHERE token = '0x...'
ORDER BY balance DESC
LIMIT 20

DeFi Llama

DeFi Llama is the standard for TVL and yield data:

Key Pages

PageURLUse For
TVL Rankingsdefillama.comCompare protocol adoption
Chain TVLdefillama.com/chainsCompare L1/L2 ecosystems
Yieldsdefillama.com/yieldsFind best yield opportunities
Stablecoinsdefillama.com/stablecoinsTrack stablecoin market

API Examples

# Top protocols by TVL
GET https://api.llama.fi/protocols

# Historical TVL for a protocol
GET https://api.llama.fi/protocol/{slug}

# Yield pools
GET https://yields.llama.fi/pools

Analysis Frameworks

Protocol Evaluation

  1. TVL: Is it growing? (Healthy = steady growth)
  2. Revenue: Does the protocol earn real fees?
  3. Users: DAU trend (bots vs real users)
  4. Token price vs TVL: P/TVL ratio (similar to P/E in tradfi)
  5. Governance activity: Are holders engaged?

Token Evaluation

  1. Supply schedule: Inflation rate, unlock events
  2. Distribution: Top 10 holders % (concentrated?)
  3. Staking ratio: What % is locked/staked?
  4. Exchange balance: Decreasing = bullish
  5. Value accrual: Does the protocol direct value to token holders?

Example — SPA (Sperax):

  • Value accrual: 30% of USDs yield + 100% fees → buyback-and-burn
  • Staking: Lock SPA → veSPA for governance + weekly rewards
  • Burns: Continuous supply reduction via buyback-and-burn

Agent Tips

  1. Always cross-reference — use 2+ data sources for important decisions
  2. Context matters — TVL dropping 10% during a market crash is normal, during a bull run is concerning
  3. Check time frames — 24h data is noisy, 30d/90d trends are more reliable
  4. Whale tracking is reactive — by the time you see a whale move, the market may have priced it in
  5. DeFi Llama is your best friend — free, reliable, comprehensive

Links

Download now (ZIP)

Does it work?

Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.

No reviews yet

People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.

  • It worked
  • Partly
  • It didn't
What did you use it for? e.g. Reviewing pull requests in a Rails app

Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.

Your trail

Files you open will collect here, so you can find them again.

Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.

Now do this for your own.

Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.