skills.rest
Thethetrader
ThethetraderCOMMUNITY
Explore all skills by this author →
GitHub

onchain-analytics

Stitch Dune Analytics, Etherscan, and The Graph data into token-flow and wallet-profiling insights.

Updated Jun 20, 2025
Search Tags:#analytics#blockchain#on-chain#dune#etherscan#the-graph#wallet-profiling
One-click install
npx skills add https://github.com/Thethetrader/thethetrader --skill onchain-analytics
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: onchain-analytics
Source: https://github.com/Thethetrader/thethetrader/tree/main/.cursor/skills/onchain-analytics
Command: npx skills add https://github.com/Thethetrader/thethetrader --skill onchain-analytics

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Analyzes and correlates on-chain data from multiple sources (Dune Analytics, Etherscan APIs, The Graph) to deliver actionable insights on token flows, wallet profiling, and protocol metrics.

Core Features & Use Cases

  • Stitch multi-source data to produce token-holder distributions, liquidity trends, and protocol health dashboards.
  • Build repeatable analytics pipelines using Dune SQL queries, Etherscan API calls, and The Graph subgraphs for custom tokens and protocols.
  • Use cases include investor research, risk monitoring, and product analytics for DeFi teams.

Quick Start

Query on-chain data sources and generate an analytics dashboard for a chosen token.

Frequently Asked Questions about onchain-analytics

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze on-chain data from multiple sources for token flow insights?▼

To analyze on-chain data, you stitch multi-source information from Dune Analytics, Etherscan, and The Graph to generate token-flow and wallet-profiling insights with clear source provenance and reproducible results.

Can I build repeatable analytics pipelines using Dune SQL and The Graph subgraphs?▼

Yes, you can build repeatable analytics pipelines by writing Dune SQL queries, calling Etherscan APIs, and using The Graph subgraphs to extract custom token and protocol metrics for dashboarding.

What is wallet profiling and how does it support DeFi risk assessment?▼

Wallet profiling tracks token-holder distributions and liquidity trends across protocols. It supports DeFi risk assessment by correlating multi-source on-chain data to evaluate protocol health and monitor investor behavior.

Do I need to know SQL and GraphQL to extract protocol metrics from blockchain data?▼

Yes, extracting protocol metrics requires SQL-like queries for Dune Analytics, API integrations for Etherscan, and GraphQL subscriptions for The Graph to successfully stitch cross-source on-chain data.

What's the best way to correlate token holder distributions across Dune Analytics and Etherscan?▼

The best way to correlate token holder distributions is cross-source data extraction, querying Dune Analytics SQL alongside Etherscan API calls to produce correlated liquidity trends and protocol health dashboards.

Why are my on-chain data queries returning inconsistent token flow results?▼

Inconsistent token flow results occur when on-chain data queries lack clear source provenance. Ensure reproducible results by properly stitching Dune Analytics, Etherscan, and The Graph data through structured API integrations.

Related Skills

Explore More Data & Analytics Skills→
LennyDevXLennyDevX

subgraph-query

Query blockchain subgraphs with GraphQL and Apollo Client to fetch on-chain data.

Community
Intermediate
ltdrewltdrew
1

data-research

Gather sources and extract fields into canonical tracker pages.

Community
Advanced
okxokx
318

okx-dex-token

Discover token metadata, market metrics, and holder distributions across EVM and non-EVM chains.

Official
Intermediate
fastnearfastnear
28

fastnear-api

Query NEAR Protocol blockchain metrics, account balances, and assets via RESTful endpoints.

Official
Basic