> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# x402 Metrics Daily

> Daily aggregated metrics for x402 protocol on Base

The `base.agents.x402_metrics_daily` table provides daily aggregated metrics for x402 protocol transfers, grouped by facilitator.

## Table Columns

| Column                | Description                                   |
| --------------------- | --------------------------------------------- |
| activity\_date        | Date of activity                              |
| chain                 | Network name                                  |
| facilitator\_id       | Unique facilitator identifier                 |
| facilitator\_name     | Display name of the facilitator               |
| transaction\_count    | Count of distinct transactions for the day    |
| transfer\_count       | Total number of transfers for the day         |
| total\_volume\_usd    | Sum of USD transfer amounts for the day       |
| total\_amount         | Sum of token transfer amounts for the day     |
| avg\_transaction\_usd | Average USD value per transfer for the day    |
| unique\_senders       | Count of distinct sender (buyer) addresses    |
| unique\_receivers     | Count of distinct receiver (seller) addresses |

## Sample Query

```sql theme={null}
SELECT 
  activity_date,
  facilitator_name,
  total_volume_usd,
  transfer_count,
  unique_senders
FROM base.agents.x402_metrics_daily
WHERE activity_date >= CURRENT_DATE - INTERVAL '7 days'
ORDER BY activity_date DESC;
```
