> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Wallets

> Polymarket wallet creation events.

The `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.                                                                                                                                              |
| owner             | VARCHAR           | Owner EOA of a Gnosis Safe proxy wallet, recovered from the ProxyCreation event (1:1 proxy-to-owner). Null for MagicLink wallets, which have no on-chain owner event. |
| transaction\_hash | VARCHAR           | Transaction hash where the wallet was created.                                                                                                                        |
| block\_timestamp  | TIMESTAMP\_NTZ(9) | Block timestamp of the wallet creation.                                                                                                                               |
| 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

<Tabs>
  <Tab title="Wallet Creation Trends">
    Track wallet creation trends by type over time:

    ```sql theme={null}
    select
      date(created_at) as creation_date,
      creation_type,
      wallet_type,
      count(*) as wallets_created
    from polygon.predictions.wallets
    group by creation_date, creation_type, wallet_type
    ```
  </Tab>
</Tabs>