Skip to content
cccskills
FreePublished on GitHub

analyzing-on-chain-data

Explore DeFi and blockchain activity with data on protocol and chain TVL, fees, DEX volumes, yields, and stablecoin market caps. Filter results by chain or category, track TVL changes, and export reports as JSON or CSV for further analysis.

OriginalShow the original description

Process perform on-chain analysis including whale tracking, token flows, and network activity. Use when performing crypto analysis. Trigger with phrases like "analyze crypto", "check blockchain", or "monitor market".

Works withCoinGecko

Run score Not tested

See how to install

Good for

  • Comparing DeFi protocols by TVL or category
  • Reviewing chain-level locked value rankings
  • Checking protocol fees and DEX trading volumes
  • Finding yield pools above a TVL threshold
  • Exporting on-chain metrics to CSV or JSON

Files included (11)

  • SKILL.md5.7 KB
  • ARD.md7.1 KB
  • config/settings.yaml1.1 KB
  • PRD.md2.2 KB
  • references/errors.md2.0 KB
  • references/examples.md3.3 KB
  • references/implementation.md1.5 KB
  • scripts/data_fetcher.py7.6 KB
  • scripts/formatters.py6.1 KB
  • scripts/metrics_calculator.py7.6 KB
  • scripts/onchain_analytics.py10.2 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Analyzing On-Chain Data

Overview

Analyze DeFi protocol metrics, chain-level TVL, fee revenue, DEX volumes, yield opportunities, and stablecoin market caps using DeFiLlama as the primary data source. Designed for DeFi researchers, protocol analysts, and yield farmers who need programmatic access to on-chain analytics without writing custom subgraph queries.

Prerequisites

  • Python 3.8+ with requests library installed
  • DeFiLlama API access (free, no key required for most endpoints)
  • Optional: CoinGecko API key for supplementary token price data
  • onchain_analytics.py CLI script available in the plugin directory
  • data_fetcher.py and metrics_calculator.py modules for programmatic usage

Instructions

  1. Run python onchain_analytics.py protocols to retrieve the top DeFi protocols ranked by total value locked (TVL).
  2. Filter protocol results by category using --category lending, --category dex, or --category "liquid staking" to narrow the scope.
  3. Filter by chain with --chain ethereum or --chain arbitrum to isolate chain-specific protocol data.
  4. Sort results by alternative metrics using --sort market_share or --sort tvl_to_mcap to surface undervalued protocols.
  5. Run python onchain_analytics.py chains to retrieve chain-level TVL rankings across all tracked networks.
  6. Run python onchain_analytics.py fees --protocol aave to pull fee and revenue data for a specific protocol.
  7. Run python onchain_analytics.py dex --chain ethereum to analyze DEX trading volumes filtered by chain.
  8. Run python onchain_analytics.py yields --min-tvl 5000000 --chain ethereum to identify yield opportunities above a minimum TVL threshold.
  9. Run python onchain_analytics.py trends --threshold 5 to detect protocols with significant TVL changes (threshold is percentage).
  10. Export results in JSON or CSV format using --format json or --format csv and redirect to file for downstream analysis.

See references/implementation.md for the full four-step implementation workflow.

Output

  • Protocol rankings table with name, TVL, market share percentage, and TVL-to-market-cap ratio
  • Chain TVL rankings showing aggregate locked value per network
  • Fee and revenue reports per protocol with daily/weekly/monthly breakdowns
  • DEX volume tables with per-chain and per-DEX breakdowns
  • Yield opportunity listings filtered by minimum TVL and chain, including APY and pool details
  • Trending protocol alerts showing TVL percentage changes above the configured threshold
  • Stablecoin market cap summaries
  • JSON (output.json) or CSV (output.csv) export files for programmatic consumption

Error Handling

ErrorCauseSolution
Request timeoutDeFiLlama API slow or unreachableWait and retry; check for outages; use cached data if available
Protocol not found: invalid-nameProtocol slug does not match DeFiLlama databaseRun python onchain_analytics.py protocols to find the exact slug; slugs are case-sensitive
No data returned for queryFilter too restrictive or data unavailableRemove filters and retry; verify the category or chain exists; try a broader time range
TVL data unavailable for some protocolsNew protocols or data collection gapsCheck DeFiLlama directly; data typically appears within 24 hours of listing
Data may be stale (last updated: X hours ago)Local cache not refreshedClear cache with rm ~/.onchain_analytics_cache.json; use --verbose to check cache status
Showing top 50 of 1000+ protocolsOutput truncated for readabilityUse --limit to increase count or --format json for full untruncated data
UnicodeEncodeErrorTerminal encoding mismatchUse --format json for safe output or set LANG=en_US.UTF-8

Examples

Daily DeFi Overview

python onchain_analytics.py protocols --limit 20
python onchain_analytics.py chains
python onchain_analytics.py trends

Produces a snapshot of the top 20 protocols by TVL, all chain rankings, and any protocols trending above the default threshold.

Research a Lending Protocol

python onchain_analytics.py protocols --category lending --sort tvl_to_mcap
python onchain_analytics.py fees --protocol aave

Ranks all lending protocols by TVL-to-market-cap ratio (identifying potentially undervalued protocols), then pulls detailed fee and revenue data for Aave.

Find High-TVL Yield Opportunities on Ethereum

python onchain_analytics.py yields --min-tvl 10000000 --chain ethereum --limit 50  # 10000000 = 10M limit

Returns up to 50 yield pools on Ethereum with at least $10M in TVL, sorted by APY. Export with --format csv > yields.csv for spreadsheet analysis.

Resources

  • DeFiLlama API Documentation -- primary data source for TVL, fees, yields, and DEX volumes
  • DeFiLlama Status Page -- check API availability and outage reports
  • CoinGecko API -- supplementary token price and market cap data
  • Dune Analytics -- custom SQL queries against on-chain data for deeper analysis
  • The Graph -- decentralized indexing protocol for querying blockchain data via GraphQL

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Add a synthetic-data CI gate for customer-owned Abridge integration code. Test consent handling, note-review handoffs, redaction, and rollback behavior with mocked vendor boundaries, without connecting CI to a live Abridge or EHR tenant.

  • Adding regression checks to an Abridge integration repository
  • Testing consent and note-release handling
  • Checking logs for sensitive data exposure
jeremylongshore/tons-of-skills-marketplace2.9KUpdated Oct 25, 2026

Triage Abridge recording, note review, Epic handoff, and access problems using observed symptoms and approved guidance. Identify the affected workflow stage, organize a minimal timeline, and prepare a redacted escalation record for the responsible team.

  • Separate recording problems from upload failures
  • Investigate note creation delays and editor issues
  • Identify the responsible team for Epic handoff failures
jeremylongshore/tons-of-skills-marketplace2.9KUpdated Oct 25, 2026

Map and review an Abridge clinical documentation workflow from consent and recording through draft review, evidence checks, edits, and final disposition. Keep clinician approval explicit, identify failure exits, and separate verified facts from tenant-specific details and pending approvals.

  • Map a clinical note workflow for a care setting
  • Check where consent and patient identity are verified
  • Review draft notes against linked evidence before sign-off
jeremylongshore/tons-of-skills-marketplace2.9KUpdated Oct 25, 2026

Audit how clinician-reviewed Abridge note sections map into Epic templates and downstream workflows. Use approved test records to document destinations, exceptions, evidence, rollback steps, and a go or no-go decision for a specific environment.

  • Checking Abridge note section mappings to Epic templates
  • Auditing a department’s approved documentation handoff
  • Preparing test evidence and a go or no-go decision
jeremylongshore/tons-of-skills-marketplace2.9KUpdated Oct 25, 2026

Review Abridge adoption and workflow value using local usage records, clinician feedback, and verified contract costs. Build an evidence based decision table covering adoption, quality, support burden, and options to expand, hold, or improve the rollout.

  • Reviewing adoption after an Abridge rollout
  • Preparing evidence for a renewal decision
  • Comparing workflow outcomes across care settings
jeremylongshore/tons-of-skills-marketplace2.9KUpdated Oct 25, 2026

Prepare a bounded support bundle for an Abridge issue using allowlisted operational details such as versions, coarse timestamps, and correlation references. Exclude recordings, transcripts, patient identifiers, credentials, and unrestricted logs, then document redactions and review details.

  • Preparing reviewed evidence for an Abridge support case
  • Documenting redactions and excluded data
  • Collecting approved operational details for an incident
jeremylongshore/tons-of-skills-marketplace2.9KUpdated Oct 25, 2026

See all skills by jeremylongshore

Report a problem with this skill