User Actions 🌱 - Allium Documentation Hub

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 Details

Property	Value
Table Name	`polygon.predictions.user_actions`
Table Status	Beta 🌱
Unique Key	`unique_id`
Clustering Key(s)	`block_timestamp::date`
Search Optimization	`from_address`, `to_address`, `transaction_hash`, `action`

Table Columns

Column Name	Data Type	Description
project	VARCHAR(16777216)	Project name (ex. polymarket).
protocol	VARCHAR(16777216)	Protocol name (ex. polymarket).
action	VARCHAR(16777216)	Type of action (deposit, withdrawal, transfer, convert).
from_wallet_type	VARCHAR(16777216)	Wallet creation type of sender (MagicLink or GnosisSafe).
from_wallet_description	VARCHAR(16777216)	Human-readable description of sender wallet type.
to_wallet_type	VARCHAR(16777216)	Wallet creation type of receiver (MagicLink or GnosisSafe).
to_wallet_description	VARCHAR(16777216)	Human-readable description of receiver wallet type.
from_address	VARCHAR(42)	Address sending the tokens.
to_address	VARCHAR(42)	Address receiving the tokens.
token_address	VARCHAR(42)	Address of the token being transferred.
token_name	VARCHAR(16777216)	Name of the token being transferred.
token_symbol	VARCHAR(16777216)	Symbol of the token being transferred (USDC or USDC.e).
raw_amount_str	VARCHAR(16777216)	Raw token amount as string (before decimal adjustment).
raw_amount	FLOAT	Raw token amount as float (before decimal adjustment).
amount_str	VARCHAR(16777216)	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(42)	Transaction originator address.
transaction_to_address	VARCHAR(42)	Transaction destination address.
transaction_hash	VARCHAR(66)	Transaction hash containing the action.
transaction_index	NUMBER(38,0)	Index of the transaction in the block.
log_index	NUMBER(38,0)	Index of the log within the transaction.
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block containing the action.
block_number	NUMBER(38,0)	Block number containing the action.
block_hash	VARCHAR(66)	Hash of the block containing the action.
unique_id	VARCHAR(16777216)	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