Skip to main content
Schema: monad.core Table: dim_labels Type: Dimension Table

What

The labels table is a critical dimension for blockchain analysis, providing one-to-one address identifiers that transform opaque addresses into recognizable entities. Labels are categorized into types (cex, dex, defi, etc.) and subtypes (hot_wallet, treasury, etc.) to enable sophisticated f

Columns

Column NameData TypeDescription
ADDRESSTEXTThe blockchain address (0x format) that this label descri…
ADDRESS_NAMETEXTThe most specific, granular label for this address. Provi…
BLOCKCHAINTEXTThe blockchain network for this label. Required for multi…
CREATORTEXTThe source or creator of this label entry. Labels from ve…
DIM_LABELS_IDTEXTPrimary key - unique identifier for each row ensuring dat…
INSERTED_TIMESTAMPTIMESTAMP_NTZUTC timestamp when the record was first added to the Flip…
LABELTEXTHigh-level label identifying the general entity or wallet…
LABEL_SUBTYPETEXTSpecific categorization within the label type. Used for d…
LABEL_TYPETEXTHigh-level category describing the address’s primary func…
MODIFIED_TIMESTAMPTIMESTAMP_NTZUTC timestamp of the most recent update to this record.
… |