| origin | VARCHAR(16777216) | The frontend or entry point of the transaction, from integrator metadata or Allium’s label of the transaction to_address. |
| integrators | VARIANT | Normalized frontend/wallet identifiers (e.g. ledger, exodus, jumper_exchange) extracted from aggregator event metadata. |
| meta_aggregator | VARCHAR(16777216) | Project name of the highest-priority meta-aggregator or intent protocol (e.g. lifi, cow_protocol). |
| aggregator | VARCHAR(16777216) | Project name of the standard aggregator (e.g. paraswap_v5, 1inch). Null if a meta-aggregator exists. |
| pmm_address | VARCHAR(16777216) | Private market maker address from maker/executor/signerWallet fields (RFQ and limit-order protocols). |
| solver_address | VARCHAR(16777216) | Solver/filler address for intent-based protocols. |
| swapper_address | VARCHAR(16777216) | The end user of the swap: sender_address for intent-based swaps, otherwise the transaction sender. |
| from_address | VARCHAR(16777216) | Transaction sender (transaction_from_address). |
| to_address | VARCHAR(16777216) | Transaction recipient (transaction_to_address). |
| usd_volume | FLOAT | Largest single swap leg in the transaction; approximates the user’s trade size. |
| total_usd_volume | FLOAT | Sum of all swap volumes in the transaction including intermediate hops. |
| user_token_input | VARCHAR(16777216) | First token sold in chronological order. |
| user_token_output | VARCHAR(16777216) | Last token bought in chronological order. |
| liquidity_details | VARIANT | Array of pool objects (project, protocol, liquidity_pool_address, pair, usd_amount, log_index, id) for all AMM swaps. Excludes RFQ fills. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| transaction_index | NUMBER(38,0) | Zero-based position of the transaction within its block. |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this record. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
