Сondition resolution events

Description of Each Table/View and Explanation of All Fields

conditional_tokens_condition_resolution

This table contains condition resolution events in the Conditional Tokens protocol. A resolution defines which outcomes “won” and how payouts are distributed across outcome slots.

• condition_id (String) — identifier of the condition that was resolved.

• oracle (String) — address of the oracle that performed/published the resolution.

• question_id (String) — identifier of the question associated with this condition.

• outcome_slot_count (UInt32) — number of outcomes (slots) for the condition.

• payout_numerators (String) — list of payout numerators for each slot, stored as a serialized structure (usually an array of stringified numbers).

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

• block_number (UInt64) — block number in which the resolution was recorded.

• 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 resolution occurred.

• 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.