block_month | DATE | UTC month of block_time; use it to prune partitions |
block_number | BIGINT | Block number of the fill |
block_time | TIMESTAMP | UTC block time of the fill |
tx_hash | VARBINARY | Transaction hash |
evt_index | INTEGER | Index of the event within the transaction |
trade_id | VARCHAR | Fill identifier, ‘0x’ + tx_hash + ’:’ + evt_index; unique per fill |
action | VARCHAR | Type of trade; always ‘CLOB trade’ (order-book fill) |
contract_address | VARBINARY | Exchange contract that emitted the fill: the V1 or V2 CTF exchange, or their NegRisk variants. See contract_version for the version |
market_id | VARBINARY | Condition id of the market, shared by its Yes and No tokens. Joins market_details.market_id |
event_title | VARCHAR | Title of the event the market is listed under |
question | VARCHAR | Concrete question the traded market resolves |
link | VARCHAR | Page of the market’s event on polymarket.com; null where Polymarket does not list the market |
outcome_name | VARCHAR | Label of the token traded, e.g. ‘Yes’ or ‘No’ (some markets use other labels such as ‘Up’ or team names). Null when the token is unknown to market_details |
is_mutually_exclusive_event | BOOLEAN | TRUE where the market is one outcome of a mutually exclusive event (Polymarket’s neg-risk markets) |
outcome_id | UINT256 | Outcome token id traded; joins market_details.outcome_id |
price | DOUBLE | Price per share of the token traded, 0-1 |
amount | DOUBLE | USD value of the fill (USDC on V1, pUSD on V2, both treated 1:1 as USD) |
shares | DOUBLE | Number of outcome shares transferred |
fee | DOUBLE | Fee charged on this fill in USD, as reported by the exchange. Usually 0 on V1, where fees were not charged in practice; V2 charges a per-market fee that scales with price * (1 - price) |
maker | VARBINARY | Address whose order was filled. On the taker leg (is_taker_side) this is the trader who took liquidity |
taker | VARBINARY | Address filling the order. On the taker leg (is_taker_side) this is the exchange contract itself |
is_taker_side | BOOLEAN | TRUE on the taker leg of a match: the exchange emits one event per maker order plus one for the taker, so unfiltered sums count each share twice. Filter WHERE is_taker_side for single-counted volume that matches Polymarket’s published methodology |
maker_side | VARCHAR | Side of the maker’s order for outcome_id: ‘BUY’ if the maker acquired outcome tokens (paid collateral), ‘SELL’ if the maker released them. Always the inverse of taker_side |
taker_side | VARCHAR | Side of the taker’s leg for outcome_id: ‘BUY’ if the taker acquired outcome tokens, ‘SELL’ if the taker released them. Always the inverse of maker_side, so whichever of maker or taker is your wallet, read its side directly. On the taker leg the taker is the exchange, so the trader’s side is maker_side |
outcome_index | INTEGER | Positional side of outcome_id within its market: 0 for the market’s first token, 1 for the second. Settlement resolves against this position, not the outcome_name label, so use it for Up/Down or team-name markets. NULL when the token is unknown to market_details |
event_id | VARCHAR | Polymarket’s id of the event the market is listed under. Joins market_details.event_id. Null where Polymarket does not list the market |
series_id | VARCHAR | Polymarket’s id of the recurring series the market’s event belongs to; null outside a series |
contract_version | VARCHAR | Version of the exchange contract that settled the fill: ‘v1’ (original CTF and NegRisk exchanges, USDC collateral), ‘v2’ (CTF Exchange V2, pUSD collateral) or ‘v3’ (ExchangeV3, pUSD collateral), which settles the markets Polymarket lists on the contract suite it calls Protocol V2 |
order_hash | VARBINARY | EIP-712 hash of the filled order. The same order_hash recurs across rows when one resting order is filled in several matches |
builder | VARBINARY | Builder attribution field (bytes32) from the signed order on v2 and v3 fills; NULL for v1 rows |
metadata | VARBINARY | Metadata field (bytes32) from the signed order on v2 and v3 fills; NULL for v1 rows |
_updated_at | TIMESTAMP | Time this row was last inserted or updated |