| origin | VARCHAR(16777216) | The frontend or entry point of the transaction, from integrator metadata or Allium’s label of the transaction to_address. |
| origin_type | VARCHAR(9) | Type of the origin entity (e.g. wallet, dapp, bot contract, interface). |
| origin_category | VARCHAR(16777216) | Category of the origin entity per Allium’s entity labels. |
| 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. |
| solver | VARCHAR(16777216) | Label of the solver/filler for intent-based protocols. |
| solver_address | VARCHAR(16777216) | Solver/filler address for intent-based protocols (CoW = transaction sender, Uniswap X = filler, 0x Settler = contract address). |
| pmm | VARCHAR(16777216) | Label of the private market maker for RFQ and limit-order fills. |
| pmm_address | VARCHAR(16777216) | Private market maker address from maker/executor/signerWallet fields (1inch LOP/AR, Paraswap RFQ, Tokenlon, AirSwap). |
| liquidity | VARCHAR(16777216) | Normalized liquidity source name (e.g. Uniswap V3, Curve). |
| liquidity_index | NUMBER(38,0) | Sequential order in which this liquidity source was accessed within the transaction (0 = first). |
| liquidity_pool_address | VARCHAR(16777216) | Pool contract address for AMM trades. |
| pair | VARCHAR(16777216) | Trading pair identifier (e.g. WETH-USDC). |
| project | VARCHAR(16777216) | Raw project name of the liquidity source (e.g. uniswap, curve_v1). |
| protocol | VARCHAR(16777216) | Protocol version of the liquidity source (e.g. uniswap_v3, uniswap_v4). |
| usd_amount | FLOAT | USD volume routed through this specific liquidity source. |
| v4_id | VARCHAR(16777216) | Uniswap V4 / Eulerswap V1 hook identifier (pool ID with hooks). |
| swap_max_usd_amount | FLOAT | Largest single swap leg in the transaction; approximates the user’s trade size. |
| swap_total_usd_amount | FLOAT | Sum of all swap volumes in the transaction including intermediate hops. |
| 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. |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this record. |
| transaction_index | NUMBER(38,0) | Zero-based position of the transaction within its block. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. |
| 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). |
| _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. |
