Table Details
| Property | Value |
|---|---|
| Table Name | arbitrum.perpetuals.settlement_pools |
| Table Status | Beta 🌱 |
| Unique Key | pool_address |
Sample Query
SELECT *
FROM arbitrum.perpetuals.settlement_pools
LIMIT 100;
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR(16777216) | Business name of the protocol being used (e.g. uniswap, aave, lido, paraswap). Consistent across verticals — every table with a project column uses this field to identify the top-level protocol brand. |
| protocol | VARCHAR(16777216) | Specific version or variant of the protocol (e.g. uniswap_v3, aave_v2, stargate_v2). Qualifies the project field with version information. |
| version | VARCHAR(16777216) | Schema version discriminator. |
| 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. |
| pool_address | VARCHAR(42) | Address of the EIP-1167 SettlementPool clone that holds the user’s USDC collateral. |
| pool_uuid | VARCHAR(16777216) | Off-chain identifier for the pool (uint128, kept as varchar). Joins to the V2 settlement records. |
| creator_address | VARCHAR(42) | Address that created the pool (the OLP vault). |
| rfq_uuid | VARCHAR(16777216) | RFQ identifier (uint128, varchar) tied to the pool creation. |
| parent_quote_uuid | VARCHAR(16777216) | Parent quote identifier (uint128, varchar) for the pool-creating quote. |
| fee_paid_by | VARCHAR(42) | Address that paid the pool-creation fee. |
| creation_fee_raw | VARCHAR(16777216) | Raw pool-creation fee in USDC base units (6 decimals), as a string. |
| creation_fee_usdc | NUMBER(38,6) | Pool-creation fee normalized to USDC. |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| created_block_number | NUMBER(38,0) | Block number of the pool-creation transaction. |
| created_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp (UTC) of the pool creation. |
| unique_key | VARCHAR(42) | Unique record key. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration). |