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

​
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. | | CREATOR | TEXT | The 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. | | ADDRESS | TEXT | The 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_TYPE | TEXT | A 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_SUBTYPE | TEXT | A 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. | | LABEL | TEXT | The 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_NAME | TEXT | | | DIM_LABELS_ID | TEXT | The 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_TIMESTAMP | TIMESTAMP_NTZ | The 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_TIMESTAMP | TIMESTAMP_NTZ | The 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. |