polygon.predictions.wallets table provides wallet creation events for Polymarket prediction markets.
Use this table for user onboarding analysis, user type distribution, and understanding the growth of the prediction market user base.
Table Columns
Unique Key:wallet_address
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR | Project name (ex. polymarket). |
| protocol | VARCHAR | Protocol name (ex. polymarket). |
| wallet_address | VARCHAR | Address of the created wallet. |
| factory_address | VARCHAR | Address of the factory contract that created the wallet. |
| creation_type | VARCHAR | Type of wallet creation (MagicLink or GnosisSafe). |
| wallet_type | VARCHAR | Wallet type description. |
| transaction_hash | VARCHAR | Transaction hash where the wallet was created. |
| created_at | TIMESTAMP_NTZ(9) | Timestamp when the wallet was created. |
| block_number | NUMBER | Block number where the wallet was created. |
| _created_at | TIMESTAMP_NTZ(9) | Record creation timestamp. |
| _updated_at | TIMESTAMP_NTZ(9) | Record update timestamp. |
Sample Query
- Wallet Creation Trends
Track wallet creation trends by type over time: