Wallets

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

Wallet Creation Trends

Track wallet creation trends by type over time:

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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query