| chain | VARCHAR(16777216) | Slug identifying the blockchain this record belongs to (e.g. near, stellar, ton). In per-chain tables this is always the same value. |
| address | VARCHAR(16777216) | Wallet or contract address of the account, in the chain’s native address format. |
| snapshot_date | DATE | Date of the wallet’s most recent day of stablecoin transfer activity. The balance, volume and activity metrics on the row are computed as of this date. |
| balance_tier | VARCHAR(16777216) | Tier of the wallet’s peak stablecoin balance in USD over its history: whale (at least 1M),‘large‘(atleast100K), medium (at least 10K),‘small‘(atleast1K), micro (at least 25)or‘dust‘(below25). |
| wallet_type | VARCHAR(16777216) | Rule-based wallet type: Consumer, Business, Institutional, Excluded or Unclassified. Address labels take priority (exchanges, contracts, infrastructure, DeFi, bridges and similar categories are Excluded), followed by balance, volume and activity heuristics. Dust wallets with little volume and bot-like wallets are also Excluded. Unclassified when no rule matched. |
| behavioral_segment | VARCHAR(16777216) | Behavioral segment: new (first stablecoin activity within the last 30 days), active (active within the last 30 days), dormant (inactive for over 30 days but active within the last 90) or churned (inactive for over 90 days). |
| combined_segment | VARCHAR(16777216) | Combined label of balance_tier and behavioral_segment in title case (e.g. Whale Active, Small Dormant). |
| engagement_score | NUMBER(38,0) | Overall engagement score (0-100), the sum of recency_score, frequency_score and consistency_score. |
| engagement_tier | VARCHAR(16777216) | Engagement tier from engagement_score: highly_engaged (80 or more), engaged (60 or more), moderately_engaged (40 or more), low_engagement (20 or more) or inactive. |
| recency_score | NUMBER(38,0) | Recency component of engagement (0-40 points): 40 if active in the last 7 days, 30 within 14 days, 20 within 30 days, then decaying with days since last activity. |
| frequency_score | NUMBER(38,0) | Frequency component of engagement (0-40 points), scaled from days_active_30d. |
| consistency_score | NUMBER(38,0) | Consistency component of engagement (0-20 points): the share of days in the wallet’s lifetime span on which it was active, multiplied by 20. |
| risk_score | NUMBER(38,0) | Overall risk score (0-100), the sum of volatility_risk_score and anomaly_risk_score. |
| risk_flag | VARCHAR(16777216) | Risk flag from risk_score: high (70 or more), medium (40 or more) or low. |
| volatility_risk_score | NUMBER(38,0) | Balance volatility risk component (0-50 points), from the coefficient of variation of the wallet’s balance over its 30-day window. |
| anomaly_risk_score | NUMBER(38,0) | Balance anomaly risk component (0-50 points), from the size of the wallet’s 30-day balance change. Scores 40 when the balance is zero but 30-day volume exceeds $1,000. |
| volume_30d_usd | FLOAT | USD value of top-stablecoin transfers sent and received by the wallet, summed over its most recent 30 days of activity up to snapshot_date. |
| current_balance_usd | FLOAT | Wallet’s stablecoin balance in USD on snapshot_date, summed across top stablecoins. Reconstructed from the cumulative net USD flow of the wallet’s stablecoin transfers rather than read from on-chain balances, so it can differ from the actual balance. |
| days_since_last_activity | NUMBER(38,0) | Days between the wallet’s most recent stablecoin activity and the date the table was built. |
| days_active_30d | NUMBER(38,0) | Number of active days in the rolling window used for the 30-day metrics. The window covers the wallet’s most recent 30 days with activity rather than 30 calendar days, so the value is capped at 30. |
| days_active_lifetime | NUMBER(38,0) | Total number of days with stablecoin activity over the wallet’s full history. |
| lifetime_span_days | NUMBER(38,0) | Days between the wallet’s first and last stablecoin activity. |
| tokens_used_count | NUMBER(38,0) | Number of distinct top stablecoins (by symbol) the wallet has transferred over its history. |
| chains_used_count | NUMBER(38,0) | Number of chains the wallet has been active on. Always 1 in per-chain tables. |
