Executed trades

Description of Each Table/View and Explanation of All Fields

polymarket_order_filled_v2

This table contains data about executed trades (fills) on Polymarket markets. Each record captures the fact of an exchange between USDC and an outcome token (CLOB outcome token) within a specific order and transaction.

• event_id (String) — unique identifier of the execution event (internal identifier of the fill record).

• order_hash (String) — hash of the order whose execution is recorded by this event.

• wallet (String) — address of the participant for whom this row is recorded (one side of the execution).

• asset (String) — identifier of the traded outcome token (CLOB token id) for a specific market outcome.

• amount_token (UInt256) — amount of the outcome token executed in this trade (in the token’s smallest units).

• amount_usdc (UInt256) — amount of USDC exchanged in this trade (in the smallest USDC units).

• is_maker (Bool) — role of the wallet address in the trade: true = maker (placed a limit order), false = taker (removed liquidity).

• side (FixedString(1)) — trade side for wallet: B = buy outcome token for USDC, S = sell outcome token for USDC.

• fee (UInt256) — protocol/contract fee attributable to this execution (in smallest units).

• block_number (UInt64) — block number in which the execution event was emitted.

• log_index (UInt32) — log (event) index within the block, allows ordering events within the same transaction/block.

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

• contract_address (String) — address of the contract that generated the execution event.

• block_hash (String) — hash of the block containing the event.

• block_timestamp (DateTime) — block timestamp (UTC) corresponding to the inclusion of the transaction in the block.

• gas_used (UInt64) — gas used (value from the execution context within the block/transaction).

• gas_limit (UInt64) — block gas limit (contextual value, useful for diagnosing network load).

• base_fee_per_gas (UInt256) — base fee in the block according to EIP-1559.

• transaction_hash (String) — hash of the transaction that produced the execution event.

• transaction_from (String) — sender address of the transaction.

• transaction_to (String) — recipient/target contract address of the transaction (may be empty for certain transaction types/storage schemes).

• transaction_value (UInt256) — amount of the network’s native token transferred in the transaction (usually 0 for contract interactions).

• transaction_gas (UInt64) — transaction gas limit (how much gas the sender allocated for execution).

• transaction_nonce (UInt64) — nonce of the transaction sender.

• max_fee_per_gas (UInt256) — maximum gas price (maxFeePerGas) under EIP-1559 for the transaction.

• max_priority_fee_per_gas (UInt256) — priority fee (maxPriorityFeePerGas) under EIP-1559 for the transaction.

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