UTC month of the event block time used for partitioning

block_month

Block number in which the transaction was executed

block_number

block_time

tx_hash

Index of the event within the transaction

evt_index

action

Exchange contract that emitted the trade. V1: CTFExchange or NegRiskCTFExchange. V2: 0xe111…996b (standard) or 0xe222…0f59 (NegRisk) — both decode into polymarket_v2_polygon.ctfexchange_evt_orderfilled.

contract_address

condition_id

Overarching question for negRisk markets (e.g., Presidential election 2024)

event_market_name

Concrete outcome being bet on (e.g., Trump wins 2024 election?)

question

Link to the Polymarket site (may be broken for archived markets)

polymarket_link

token_outcome

Boolean indicating whether this is a neg_risk market

neg_risk

asset_id

price

Amount in USD (V2: pUSD treated 1:1 as USD)

amount

shares

Per-trade fee in USD. V1: sourced from CTFExchange/NegRiskCtfExchange OrderFilled.fee (usually 0 — fees were not charged in practice on V1). V2: sourced from the V2 OrderFilled.fee field, calculated per-market as fee = C × r × p × (1 − p).

maker

Trader who is filling the order (often a contract from Polymarket)

taker

TRUE on the taker leg of a CLOB match (one of the two OrderFilled events the exchange emits per match). Filter `WHERE is_taker_side` to get one-sided volume that matches Polymarket's published methodology and avoids 2x double-counting. Predicate: `taker IN (V1 CTF 0x4bfb…82e, V1 NegRisk 0xc5d5…80a, V2 CTF 0xe111…996b, V2 NegRisk 0xe222…0f59)`.

is_taker_side

Side of the maker's order w.r.t. asset_id: 'BUY' if the maker is acquiring outcome tokens (paying USDC on V1 / pUSD on V2), 'SELL' if releasing them. Always the inverse of taker_side. Derived from makerAssetId on V1 (0 = USDC, so maker is buying tokens) and from the explicit side enum on V2 (0 = BUY, 1 = SELL).

maker_side

Side of the taker's leg w.r.t. asset_id: 'BUY' if the taker is acquiring outcome tokens, 'SELL' if releasing them. Always the inverse of maker_side. Lets consumers read the right side directly from whichever address (maker or taker) matches their wallet, without an inversion CASE.

taker_side

Exchange contract version that executed the trade: 'v1' (original CTFExchange/NegRiskCTFExchange) or 'v2' (launched Apr 2026, unified CTFExchange V2, pUSD collateral).

contract_version

V2 only: builder attribution field (bytes32) embedded in signed orders, replacing V1's HMAC header authentication. NULL for V1 rows.

builder

V2 only: arbitrary metadata field (bytes32) in signed orders. NULL for V1 rows.

metadata

unique_key

Combination of token outcome and question

token_outcome_name

Timestamp of when this row was last inserted or updated by the dbt pipeline

_updated_at

Trades on Polymarket prediction markets on Polygon, including outcome token, price, shares, fees, and maker/taker addresses.