| chain | VARCHAR(16777216) | Slug identifying the blockchain this record belongs to (e.g. ethereum, base, avalanche, solana). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. |
| address | VARCHAR(16777216) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies. |
| snapshot_date | DATE | Date of the orderbook snapshot. |
| balance_tier | VARCHAR(16777216) | Balance tier classification (whale, large, medium, small, micro, dust) |
| wallet_type | VARCHAR(16777216) | wallet type description |
| behavioral_segment | VARCHAR(16777216) | Behavioral segment (new, active, dormant, churned) |
| combined_segment | VARCHAR(16777216) | Combined classification (e.g., “Whale Active”, “Small Dormant”) |
| engagement_score | NUMBER(38,0) | Overall engagement score (0-100) combining recency, frequency, and consistency |
| engagement_tier | VARCHAR(16777216) | Engagement tier (highly_engaged, engaged, moderately_engaged, low_engagement, inactive) |
| recency_score | NUMBER(38,0) | Recency component of engagement (0-40 points) |
| frequency_score | NUMBER(38,0) | Frequency component of engagement (0-40 points) |
| consistency_score | NUMBER(38,0) | Consistency component of engagement (0-20 points) |
| risk_score | NUMBER(38,0) | Overall risk score (0-100) combining volatility and anomaly risks |
| risk_flag | VARCHAR(16777216) | Risk flag (high, medium, low) |
| volatility_risk_score | NUMBER(38,0) | Balance volatility risk component (0-50 points) |
| anomaly_risk_score | NUMBER(38,0) | Balance anomaly risk component (0-50 points) |
| volume_30d_usd | FLOAT | 30-day transaction volume in USD |
| current_balance_usd | FLOAT | Current wallet balance in USD |
| days_since_last_activity | NUMBER(38,0) | Days since most recent stablecoin activity |
| days_active_30d | NUMBER(38,0) | Number of active days in past 30 days |
| days_active_lifetime | NUMBER(38,0) | Total number of active days (lifetime) |
| lifetime_span_days | NUMBER(38,0) | Days between first and last activity |
| tokens_used_count | NUMBER(38,0) | Number of unique stablecoin tokens used |
| chains_used_count | NUMBER(38,0) | Number of chains wallet has been active on |
