Position merge events

Description of Each Table/View and Explanation of All Fields

conditional_tokens_positions_merge

This table contains position merge events — the reverse operation of a split. In these events, multiple outcome positions are merged back into a base position (collateral or parent position).

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

• collateral_token (String) — address of the collateral token into which the positions are merged.

• 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 positions are merged.

• partition (String) — description of the merged parts/sets of outcomes, stored in serialized form.

• amount (String) — amount being merged (in the smallest units).

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

• block_number (UInt64) — block number in which the merge 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 merge 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.