> ## 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

### Table Details

| Property     | Value                                           |
| ------------ | ----------------------------------------------- |
| Table Name   | `stellar.wallet_features.wallet_classification` |
| Table Status | Production-Ready                                |

### Table Columns

| Column Name                 | Data Type         | Description                                                       |
| --------------------------- | ----------------- | ----------------------------------------------------------------- |
| chain                       | VARCHAR(16777216) | Blockchain this record belongs to; always `stellar`.              |
| address                     | VARCHAR(16777216) | Stellar wallet (G...) address being classified.                   |
| snapshot\_date              | DATE              | Date for which this wallet classification was computed.           |
| balance\_tier               | VARCHAR(16777216) | Categorical tier of the wallet's balance size.                    |
| wallet\_type                | VARCHAR(16777216) | Categorical wallet-type label assigned to the wallet.             |
| behavioral\_segment         | VARCHAR(16777216) | Categorical behavioral segment assigned to the wallet.            |
| combined\_segment           | VARCHAR(16777216) | Composite segment combining balance, type, and behavioral labels. |
| engagement\_score           | NUMBER(38,0)      | Computed score measuring the wallet's overall engagement.         |
| engagement\_tier            | VARCHAR(16777216) | Categorical tier derived from the engagement score.               |
| recency\_score              | NUMBER(38,0)      | Computed score measuring how recently the wallet was active.      |
| frequency\_score            | NUMBER(38,0)      | Computed score measuring how frequently the wallet transacts.     |
| consistency\_score          | NUMBER(38,0)      | Computed score measuring how consistent the wallet's activity is. |
| risk\_score                 | NUMBER(38,0)      | Computed overall risk score for the wallet.                       |
| risk\_flag                  | VARCHAR(16777216) | Flag indicating whether the wallet is considered risky.           |
| volatility\_risk\_score     | NUMBER(38,0)      | Computed risk score based on the wallet's activity volatility.    |
| anomaly\_risk\_score        | NUMBER(38,0)      | Computed risk score based on anomalous wallet behavior.           |
| volume\_30d\_usd            | FLOAT             | USD transaction volume over the trailing 30 days.                 |
| current\_balance\_usd       | FLOAT             | Current USD value of the wallet's balance.                        |
| days\_since\_last\_activity | NUMBER(38,0)      | Number of days since the wallet was last active.                  |
| days\_active\_30d           | NUMBER(38,0)      | Number of active days in the trailing 30 days.                    |
| days\_active\_lifetime      | NUMBER(38,0)      | Total number of active days over the wallet's lifetime.           |
| lifetime\_span\_days        | NUMBER(38,0)      | Number of days between the wallet's first and last activity.      |
| tokens\_used\_count         | NUMBER(38,0)      | Distinct number of tokens the wallet has transacted in.           |
| chains\_used\_count         | NUMBER(38,0)      | Distinct number of chains the wallet has been active on.          |