crosschain.agents.x402_overview table provides lifetime and rolling window (7d/30d/90d) metrics for x402 protocol facilitators across all chains.
Table Columns
| Column | Description |
|---|---|
| chain | Network name |
| facilitator_id | Unique facilitator identifier |
| facilitator_name | Display name of the facilitator |
| total_volume_usd | All-time total USD volume |
| total_transactions | All-time distinct transaction count |
| total_transfers | All-time total transfer count |
| total_unique_senders | All-time distinct sender (buyer) count |
| total_unique_receivers | All-time distinct receiver (seller) count |
| first_activity_date | Date of first transfer |
| last_activity_date | Date of most recent transfer |
| days_active | Number of days between first and last activity |
| last_7d_volume_usd | USD volume in the last 7 days |
| last_7d_transactions | Transaction count in the last 7 days |
| last_7d_unique_senders | Distinct senders in the last 7 days |
| last_7d_unique_receivers | Distinct receivers in the last 7 days |
| last_30d_volume_usd | USD volume in the last 30 days |
| last_30d_transactions | Transaction count in the last 30 days |
| last_30d_unique_senders | Distinct senders in the last 30 days |
| last_30d_unique_receivers | Distinct receivers in the last 30 days |
| last_90d_volume_usd | USD volume in the last 90 days |
| last_90d_transactions | Transaction count in the last 90 days |
| last_90d_unique_senders | Distinct senders in the last 90 days |
| last_90d_unique_receivers | Distinct receivers in the last 90 days |
Sample Query
SELECT
chain,
facilitator_name,
total_volume_usd,
total_transactions,
last_30d_volume_usd
FROM crosschain.agents.x402_overview
ORDER BY total_volume_usd DESC;