Position split events

Description of Each Table/View and Explanation of All Fields

conditional_tokens_position_split

This table contains position split events. These are operations in which a base position (usually collateral) is transformed into a set of outcome positions for a specified condition.

• stakeholder (String) — address of the participant performing the position split.

• collateral_token (String) — address of the collateral token (e.g., USDC) from which the positions are formed.

• parent_collection_id (String) — identifier of the parent collection (for nested/composite positions; a zero value indicates the base level).

• condition_id (String) — condition for which the outcome positions are created.

• partition (String) — description of the partitioning into parts (which sets of outcomes are formed), stored in serialized form.

• amount (String) — amount being split (in the smallest units of the collateral/position, depending on the contract).

• event_id (String) — unique event identifier (internal record identifier).

• block_number (UInt64) — block number in which the split event occurred.

• log_index (UInt32) — index of the event log within the block.

• transaction_index (UInt32) — transaction index within the block.

• contract_address (String) — address of the Conditional Tokens contract that emitted the event.

• block_hash (String) — block hash.

• block_timestamp (DateTime) — block timestamp (UTC).

• gas_used (UInt64) — gas used (execution context).

• gas_limit (UInt64) — block gas limit (contextual value).

• base_fee_per_gas (UInt256) — block base fee under EIP-1559.

• transaction_hash (String) — hash of the transaction in which the split was performed.

• transaction_from (String) — transaction sender.

• transaction_to (String) — transaction recipient/target address.

• transaction_value (UInt256) — transaction value (native network token).

• transaction_gas (UInt64) — transaction gas limit.

• transaction_nonce (UInt64) — sender nonce.

• max_fee_per_gas (UInt256) — transaction maxFeePerGas (EIP-1559).

• max_priority_fee_per_gas (UInt256) — transaction maxPriorityFeePerGas (EIP-1559).

• inserted_at (DateTime) — time when the record was inserted into ClickHouse.