Table Details
| Property | Value |
|---|---|
| Table Name | codex.wallet_features.wallet_classification |
| Table Status | Production-Ready |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR(16777216) | Name of the blockchain network this record belongs to. |
| address | VARCHAR(16777216) | Blockchain account address this record pertains to. |
| snapshot_date | DATE | Calendar date (UTC) at which this snapshot was taken. |
| balance_tier | VARCHAR(16777216) | Tier bucket of the wallet’s current USD balance. |
| wallet_type | VARCHAR(16777216) | Classified type of the wallet (e.g. retail, whale, contract). |
| behavioral_segment | VARCHAR(16777216) | Behavioral segment assigned to the wallet from its activity patterns. |
| combined_segment | VARCHAR(16777216) | Combined segment label derived from behavioral and value signals. |
| engagement_score | NUMBER(38,0) | Composite score measuring how actively the wallet engages with the chain. |
| engagement_tier | VARCHAR(16777216) | Tier bucket derived from the engagement score. |
| recency_score | NUMBER(38,0) | Score measuring how recently the wallet was active. |
| frequency_score | NUMBER(38,0) | Score measuring how frequently the wallet transacts. |
| consistency_score | NUMBER(38,0) | Score measuring how consistently the wallet is active over time. |
| risk_score | NUMBER(38,0) | Composite risk score for the wallet. |
| risk_flag | VARCHAR(16777216) | Flag indicating whether the wallet is considered risky. |
| volatility_risk_score | NUMBER(38,0) | Risk score derived from volatility in the wallet’s activity. |
| anomaly_risk_score | NUMBER(38,0) | Risk score derived from anomalous activity detected for the wallet. |
| volume_30d_usd | FLOAT | Total USD transaction volume for the wallet over the trailing 30 days. |
| current_balance_usd | FLOAT | Current USD balance held by the wallet. |
| days_since_last_activity | NUMBER(38,0) | Number of days since the wallet’s most recent activity. |
| days_active_30d | NUMBER(38,0) | Number of active days for the wallet over the trailing 30 days. |
| days_active_lifetime | NUMBER(38,0) | Total number of active days for the wallet over its lifetime. |
| lifetime_span_days | NUMBER(38,0) | Number of days between the wallet’s first and most recent activity. |
| tokens_used_count | NUMBER(38,0) | Number of distinct tokens the wallet has interacted with. |
| chains_used_count | NUMBER(38,0) | Number of distinct chains the wallet has been active on. |