User Actions

The polygon.predictions.user_actions table tracks all user interactions including deposits, withdrawals, transfers, and USDC/USDC.e conversions. Use this table for user behavior analysis, wallet activity tracking, and understanding fund flows in the prediction market ecosystem.

Table Columns

Unique Key: unique_id

Column Name	Data Type	Description
project	VARCHAR	Project name (ex. polymarket).
protocol	VARCHAR	Protocol name (ex. polymarket).
action	VARCHAR	Type of action (deposit, withdrawal, transfer, convert).
from_wallet_type	VARCHAR	Wallet creation type of sender (MagicLink or GnosisSafe).
from_wallet_description	VARCHAR	Human-readable description of sender wallet type.
to_wallet_type	VARCHAR	Wallet creation type of receiver (MagicLink or GnosisSafe).
to_wallet_description	VARCHAR	Human-readable description of receiver wallet type.
from_address	VARCHAR	Address sending the tokens.
to_address	VARCHAR	Address receiving the tokens.
token_address	VARCHAR	Address of the token being transferred.
token_name	VARCHAR	Name of the token being transferred.
token_symbol	VARCHAR	Symbol of the token being transferred (USDC or USDC.e).
raw_amount_str	VARCHAR	Raw token amount as string (before decimal adjustment).
raw_amount	FLOAT	Raw token amount as float (before decimal adjustment).
amount_str	VARCHAR	Normalized token amount as string.
amount	FLOAT	Normalized token amount as float.
usd_amount	FLOAT	USD value of the token amount.
usd_exchange_rate	FLOAT	USD exchange rate for the token.
transaction_from_address	VARCHAR	Transaction originator address.
transaction_to_address	VARCHAR	Transaction destination address.
transaction_hash	VARCHAR	Transaction hash containing the action.
transaction_index	NUMBER	Index of the transaction in the block.
log_index	NUMBER	Index of the log within the transaction.
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block containing the action.
block_number	NUMBER	Block number containing the action.
block_hash	VARCHAR	Hash of the block containing the action.
unique_id	VARCHAR	Unique identifier for the transfer event.
_created_at	TIMESTAMP_NTZ(9)	Record creation timestamp.
_updated_at	TIMESTAMP_NTZ(9)	Record update timestamp.

Sample Query

User Type Analysis

Analyze user deposits and withdrawals by wallet type:

select
  action,
  CASE
    when action = 'deposit' then to_wallet_type
    when action = 'withdrawal' then from_wallet_type
  END AS wallet_type,
  count(*) as action_count
from polygon.predictions.user_actions
where block_timestamp >= current_timestamp - interval '30 days'
and (action = 'withdrawal' or action = 'deposit')
group by action, 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