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