Skip to main content
Schema: aptos.core Table: dim_labels Type: View

​
What

​
Description

This table provides comprehensive address labeling and classification for the Aptos blockchain, serving as a centralized repository of address identifiers and names. Labels are organized into hierarchical categories with “type” (e.g., cex, dex, dapp, games) and “subtype” (e.g., contract_deployer, hot_wallet, token_contract) to enable systematic address classification. The labeling system combines automatic algorithmic detection with manual curation, including community contributions through tools like the add-a-label platform. Labels can be dynamically updated and removed based on accuracy assessments and relevance changes.

​
Key Use Cases

  • Address identification and classification for analytics and reporting
  • DeFi protocol analysis by identifying protocol-related addresses
  • Exchange and institutional wallet tracking and monitoring
  • Contract deployment analysis and developer activity tracking
  • Security analysis and suspicious address identification
  • Network mapping and relationship analysis between labeled entities

​
Important Relationships

  • Enriches address information across all core models including core.fact_transfers, core.ez_transfers, and core.fact_transactions
  • Provides context for transaction analysis by identifying participant types
  • Supports DeFi analytics by classifying protocol-related addresses
  • Enables cross-chain analysis through consistent labeling standards
  • Links to community-contributed labels and external labeling systems

​
Commonly-used Fields

  • address: Primary identifier for linking to transaction and transfer data
  • label_type: High-level categorization for broad address classification
  • label_subtype: Detailed classification for specific address roles and functions
  • label: Human-readable name or identifier for the address
  • creator: Source of the label for attribution and quality assessment
  • blockchain: Chain identifier for cross-chain analysis

​
Columns

Column NameData TypeDescription
BLOCKCHAINTEXTThe name of the blockchain where the address or entity is located. Data type: String Example: aptos ethereum solana Business Context: Essential for cross-chain analysis and blockchain identification. Critical for multi-chain data correlation and blockchain-specific analytics. Enables blockchain-based filtering and cross-chain reporting.
CREATORTEXTThe name of the entity that created the label, typically representing the data provider or labeling source. Data type: String Example: Flipside Community Protocol Business Context: Essential for label attribution and data source tracking. Critical for understanding label reliability and source credibility. Enables source-based analytics and label quality assessment.
ADDRESSTEXTThe unique address identifier for an individual wallet, validator, or token on the Aptos blockchain. Data type: String Example: 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef Business Context: Primary identifier for tracking wallet activity and user behavior analysis. Essential for DeFi protocol analysis and address labeling. Enables correlation with address metadata for enhanced analytics and reporting.
LABEL_TYPETEXTA broad category that describes what a label is representing, providing high-level classification of the labeled entity. Data type: String Example: protocol exchange wallet contract Business Context: Essential for label categorization and entity type analysis. Critical for filtering and grouping labeled entities by type. Enables type-based analytics and entity classification reporting.
LABEL_SUBTYPETEXTA more detailed classification that adds specificity to the label type, providing granular categorization of the labeled entity. Data type: String Example: dex cex lending staking Business Context: Essential for detailed entity classification and subtype analysis. Critical for precise filtering and granular entity categorization. Enables subtype-based analytics and detailed entity reporting.
LABELTEXTThe human-readable label or name assigned to the address, providing a meaningful identifier for the entity. Data type: String Example: Uniswap V3 Binance Hot Wallet Aave Protocol Business Context: Essential for human-readable entity identification and address mapping. Critical for user-friendly analytics and address recognition. Enables labeled entity analysis and address categorization reporting.
ADDRESS_NAMETEXTADDRESS_NAME column
DIM_LABELS_IDTEXTThe unique primary key identifier for each row in the table, ensuring data integrity and uniqueness. Data type: String Example: 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef Business Context: Essential for data integrity and unique row identification. Critical for join operations and data relationship management. Enables precise data retrieval and referential integrity maintenance.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp when the row was inserted into the table, representing when the data was first recorded. Data type: Timestamp Example: 2024-01-15 14:30:25.123456 Business Context: Essential for data lineage tracking and insertion timing analysis. Critical for understanding data freshness and processing delays. Enables data quality analysis and processing performance monitoring.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp when the row was last modified, representing when the data was most recently updated. Data type: Timestamp Example: 2024-01-15 14:30:25.123456 Business Context: Essential for data freshness analysis and update tracking. Critical for understanding data modification patterns and change frequency. Enables data quality monitoring and update performance analysis.