Skip to main content
The polymarket_polygon.users_address_lookup table maps each Polymarket wallet to its owner. Polymarket users trade from a wallet Polymarket creates for them: a Safe, a Magic wallet or a deposit wallet. The table also records when each wallet was created and first funded. There is one row per wallet, unique on polymarket_wallet. Deposit wallets record no owner, so owner is NULL on those rows. Use it to find who owns the maker and taker addresses in market_trades or the address in positions.

Table Schema

Table sample

Example query

Previous version

Columns of the previous version, for queries that still use it. The migration guide maps each old column to its new name.