blockchain | varchar | Chain name |
transfer_unique_key | varchar | Unique transfer identifier; join key back to upstream stablecoin transfer tables |
block_month | date | Block month (partition key) |
block_date | date | Block date |
block_time | timestamp | Block timestamp |
tx_hash | varchar | Transaction hash |
transfer_evt_index | bigint | Event index of the underlying token transfer |
activity_evt_index | bigint | Event index of the protocol activity event; NULL where not applicable |
token_address | varchar | Token contract address |
token_symbol | varchar | Token symbol, e.g. USDC, USDT |
sender | varchar | Raw transfer sender address |
sender_label | varchar | Role label for the sender: payer or escrow_contract |
receiver | varchar | Raw transfer receiver address |
receiver_label | varchar | Role label for the receiver: recipient |
amount | double | Normalized token amount |
amount_usd | double | USD value at block time |
amount_raw | uint256 | Raw token amount |
tx_type | varchar | Transaction type: agentic_payment (direct payment) or agentic_fee (protocol fee leg) |
payment_protocol | varchar | Protocol name: x402 or mpp |
payer | varchar | Semantic payer address (may differ from sender for facilitated flows) |
recipient | varchar | Semantic recipient / service provider address |
facilitator_address | varchar | Facilitator contract or infrastructure address (where applicable) |
facilitator_name | varchar | Name of the facilitator (e.g. Coinbase, payAI) |
settlement_pattern | varchar | MPP settlement subtype: charge (per-request) or session (escrow-based); NULL for x402 |
escrow_contract | varchar | Escrow or channel contract address for MPP session payments; NULL otherwise |
protocol_infra_address | varchar | Protocol infrastructure contract address |