Goals
- Track onchain activity (TVL, transactions, gas, liquidity) across chains in a consistent schema.
- Benchmark venue depth, pricing, and volatility against centralized exchanges for investment memos.
- Provide analysts with lineage-backed metrics they can cite in external reports.
Core Datasets
| Need | Dataset | Notes |
|---|---|---|
| Ledger coverage | blocks & transactions | Use _tracing_id to reconcile any metric with its source block. |
| Token & liquidity intel | erc20 tokens, liquidity pools, reserves | Model TVL, flow of assets, fee tiers, and AMM composition. |
| Pricing context | token-to-token prices & pricing analytics | Normalize spot data and compute rolling VWAP/LWAP. |
Delivery Recommendation
- Archive backfill through S3 buckets or Snowflake share to hydrate historical dashboards.
- Incremental refresh via Managed Bucket Slices or Snowflake CDC streams for daily/hourly updates.
- BI tooling: publish curated marts to Tableau or Power BI, exposing
_tracing_idfor drill-through to verification endpoints.
Metrics Blueprint
- Chain health: block counts, failure rates, gas cost quartiles, derived from ledger tables.
- Liquidity depth: aggregate pool reserves grouped by asset class (
asset_classenumeration) and venue (DEX type). - Price spreads: compare BlockDB synthetic prices with centralized exchange feeds; highlight divergence > threshold.
Verification & Governance
- Wire
_tracing_idinto dashboards so analysts can click through to Lineage endpoints. - Subscribe to Schema Governance updates and bake checks into BI refresh pipelines.