| chain | VARCHAR(16777216) | Slug identifying the blockchain this record belongs to (e.g. ethereum, base, avalanche, solana). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. |
| facilitator_id | VARCHAR(16777216) | Unique identifier of the x402 facilitator that routed this payment or is registered in the facilitator registry. |
| facilitator_name | VARCHAR(16777216) | Human-readable name of the x402 facilitator (e.g. “Coinbase”, “Stripe”, “Allium”). |
| total_volume_usd | FLOAT | Total trading volume in USD on this day across all markets and trade types. |
| total_transactions | NUMBER(38,0) | Total number of transactions processed in this aggregated time period or entity scope. |
| total_transfers | NUMBER(38,0) | Total number of x402 payment transfers processed through this facilitator across all time. |
| total_unique_senders | NUMBER(38,0) | Total distinct sender addresses across all time for this facilitator. |
| total_unique_receivers | NUMBER(38,0) | Total distinct receiver addresses across all time for this facilitator. |
| first_activity_date | DATE | Date of the first payment activity recorded for this facilitator. |
| last_activity_date | DATE | Date of the most recent payment activity recorded for this facilitator. |
| days_active | NUMBER(38,0) | Number of days between first and last activity |
| last_7d_volume_usd | FLOAT | Total payment volume (USD) processed in the last 7 days. |
| last_7d_transactions | NUMBER(38,0) | Number of payment transactions processed in the last 7 days. |
| last_7d_unique_senders | NUMBER(38,0) | Distinct sender addresses active in the last 7 days. |
| last_7d_unique_receivers | NUMBER(38,0) | Distinct receiver addresses active in the last 7 days. |
| last_30d_volume_usd | FLOAT | Total payment volume (USD) processed in the last 30 days. |
| last_30d_transactions | NUMBER(38,0) | Number of payment transactions processed in the last 30 days. |
| last_30d_unique_senders | NUMBER(38,0) | Distinct sender addresses active in the last 30 days. |
| last_30d_unique_receivers | NUMBER(38,0) | Distinct receiver addresses active in the last 30 days. |
| last_90d_volume_usd | FLOAT | Total payment volume (USD) processed in the last 90 days. |
| last_90d_transactions | NUMBER(38,0) | Number of payment transactions processed in the last 90 days. |
| last_90d_unique_senders | NUMBER(38,0) | Distinct sender addresses active in the last 90 days. |
| last_90d_unique_receivers | NUMBER(38,0) | Distinct receiver addresses active in the last 90 days. |
