Payout redemption events

Description of Each Table/View and Explanation of All Fields

conditional_tokens_payout_redemption

This table contains payout redemption events: after a condition is resolved, a participant redeems a position/positions and receives a payout in collateral.

• redeemer (String) — address of the payout recipient (the entity performing the redemption).

• collateral_token (String) — address of the collateral token in which the payout is made.

• 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 redemption is performed.

• index_sets (String) — set of index sets (which positions/outcome sets are redeemed), stored in serialized form.

• payout (String) — amount of the payout received in the smallest units of the collateral.

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

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