polymarket_polygon.users_address_lookup table maps Polymarket proxy wallets (both Safe and Magic wallet types) to their owner addresses, including creation and first funding metadata.
Table Schema
| Column | Type | Description |
|---|---|---|
created_time | TIMESTAMP | Timestamp when the Polymarket wallet was created |
block_number | BIGINT | Block number when the Polymarket wallet was created |
wallet_type | VARCHAR | Type of wallet (safe or magic) |
owner | VARBINARY | Owner address of the Polymarket wallet |
polymarket_wallet | VARBINARY | Polymarket proxy wallet address |
created_tx_hash | VARBINARY | Transaction hash of the wallet creation |
first_funded_time | TIMESTAMP | Timestamp of first funding received by the wallet |
first_funded_by | VARBINARY | Address that first funded the wallet |
first_funded_tx_hash | VARBINARY | Transaction hash of first funding |
has_been_funded | BOOLEAN | Whether the wallet has ever received funds |