> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Wallet Classification

Behavioural classification of wallets, snapshotted per date: balance tiers, wallet types, engagement, recency and frequency scores, risk flags, and activity statistics. On other-ecosystem chains every metric is derived from the wallet's transfers of top stablecoins, and USD balances are reconstructed from net transfer flow.

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| 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` (at least $100K), `medium` (at least $10K), `small` (at least $1K), `micro` (at least $25) or `dust` (below $25). |
| 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. |