PRD: On-Chain Analytics
Summary
One-liner: Analyze blockchain metrics including TVL, protocol revenues, user activity, and network health across DeFi protocols.
Domain: Cryptocurrency / On-Chain Intelligence
Users: Analysts, Researchers, Traders, Protocol Teams
Problem Statement
On-chain data is scattered across multiple sources (DeFiLlama, Dune, Flipside) with different formats and query methods. Users need unified analytics to understand protocol health, compare DeFi metrics, and identify trends without writing complex SQL queries.
User Stories
As a DeFi analyst, I want to compare TVL across protocols, so that I can identify market leaders and growth trends.
As a researcher, I want to analyze protocol revenue and fees, so that I can evaluate sustainability and tokenomics.
As a trader, I want to track user activity and growth metrics, so that I can identify emerging protocols early.
As a protocol team, I want to monitor our on-chain metrics vs competitors, so that we can track market position.
Functional Requirements
- REQ-1: Fetch and compare TVL across protocols and chains
- REQ-2: Analyze protocol revenues, fees, and P/E ratios
- REQ-3: Track active users (DAU/MAU/WAU) and growth rates
- REQ-4: Monitor transaction volumes and gas consumption
- REQ-5: Calculate protocol dominance and market share
- REQ-6: Generate time-series charts and comparisons
- REQ-7: Support filtering by chain, category, and time range
API Integrations
| API |
Purpose |
Rate Limit |
| DeFiLlama |
TVL, revenues, fees, chains |
No limit |
| Token Terminal |
Protocol metrics, P/E ratios |
100/day (free) |
| Dune Analytics |
Custom queries, user counts |
10 queries (free) |
| CoinGecko |
Token prices, market caps |
10-30/min |
Success Metrics
- TVL queries return data for top 100 protocols
- Revenue data available for 50+ protocols
- Historical data spans at least 1 year
- Output formats: table, JSON, CSV, charts
Non-Goals
- Real-time transaction monitoring (use whale-alert-monitor)
- Individual wallet tracking (use blockchain-explorer)
- Trading recommendations or signals
- Smart contract auditing
1---2name: prd-on-chain-analytics3description: On-chain data is scattered across multiple sources (DeFiLlama, Dune, Flipside) with different formats and query methods.4---5# PRD: On-Chain Analytics67## Summary8**One-liner**: Analyze blockchain metrics including TVL, protocol revenues, user activity, and network health across DeFi protocols.9**Domain**: Cryptocurrency / On-Chain Intelligence10**Users**: Analysts, Researchers, Traders, Protocol Teams1112## Problem Statement13On-chain data is scattered across multiple sources (DeFiLlama, Dune, Flipside) with different formats and query methods. Users need unified analytics to understand protocol health, compare DeFi metrics, and identify trends without writing complex SQL queries.1415## User Stories16171. **As a DeFi analyst**, I want to compare TVL across protocols, so that I can identify market leaders and growth trends.18192. **As a researcher**, I want to analyze protocol revenue and fees, so that I can evaluate sustainability and tokenomics.20213. **As a trader**, I want to track user activity and growth metrics, so that I can identify emerging protocols early.22234. **As a protocol team**, I want to monitor our on-chain metrics vs competitors, so that we can track market position.2425## Functional Requirements2627- REQ-1: Fetch and compare TVL across protocols and chains28- REQ-2: Analyze protocol revenues, fees, and P/E ratios29- REQ-3: Track active users (DAU/MAU/WAU) and growth rates30- REQ-4: Monitor transaction volumes and gas consumption31- REQ-5: Calculate protocol dominance and market share32- REQ-6: Generate time-series charts and comparisons33- REQ-7: Support filtering by chain, category, and time range3435## API Integrations3637| API | Purpose | Rate Limit |38|-----|---------|------------|39| DeFiLlama | TVL, revenues, fees, chains | No limit |40| Token Terminal | Protocol metrics, P/E ratios | 100/day (free) |41| Dune Analytics | Custom queries, user counts | 10 queries (free) |42| CoinGecko | Token prices, market caps | 10-30/min |4344## Success Metrics4546- TVL queries return data for top 100 protocols47- Revenue data available for 50+ protocols48- Historical data spans at least 1 year49- Output formats: table, JSON, CSV, charts5051## Non-Goals5253- Real-time transaction monitoring (use whale-alert-monitor)54- Individual wallet tracking (use blockchain-explorer)55- Trading recommendations or signals56- Smart contract auditing
tools-only