polygon.predictions.wallets table provides a view of wallet creation events for prediction markets, combining data from both MagicLink and Gnosis Safe wallet factories. This table helps understand user onboarding patterns and wallet type distribution.
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
Track wallet creation trends by type over time: