Skip to main content
The crosschain.agents.x402_metrics_daily table provides daily aggregated metrics for x402 protocol transfers across all chains, grouped by chain and facilitator.

​
Table Columns

ColumnDescription
activity_dateDate of activity
chainNetwork name
facilitator_idUnique facilitator identifier
facilitator_nameDisplay name of the facilitator
transaction_countCount of distinct transactions for the day
transfer_countTotal number of transfers for the day
total_volume_usdSum of USD transfer amounts for the day
total_amountSum of token transfer amounts for the day
avg_transaction_usdAverage USD value per transfer for the day
unique_sendersCount of distinct sender (buyer) addresses
unique_receiversCount of distinct receiver (seller) addresses

​
Sample Query

SELECT 
  chain,
  activity_date,
  SUM(total_volume_usd) AS total_volume_usd,
  SUM(transfer_count) AS total_transfers
FROM crosschain.agents.x402_metrics_daily
WHERE activity_date >= CURRENT_DATE - INTERVAL '7 days'
GROUP BY chain, activity_date
ORDER BY activity_date DESC;