osmosis.core Table: dim_labels Type: View
The labels table is a store of one-to-one address identifiers, or an address name. Labels are broken
out into a “type” (such as cex, dex, dapp, games, etc.) and a “subtype” (ex: contract_deployer,
hot_wallet, token_contract, etc.) in order to help classify each address name into similar groups.
Our labels are sourced from many different places, but can primarily be grouped into two categories:
automatic and manual. Automatic labels are continuously labeled based on certain criteria, such as a
known contract deploying another contract, behavior based algorithms for finding deposit wallets,
and consistent data pulls of custom protocol APIs. Manual labels are done periodically to find
addresses that cannot be found programmatically such as finding new protocol addresses, centralized
exchange hot wallets, or trending addresses. Labels can also be added by our community by using our
add-a-label tool (https://science.flipsidecrypto.xyz/add-a-label/) or on-chain with near
(https://near.social/lord1.near/widget/Form) and are reviewed by our labels team. A label can be
removed by our labels team if it is found to be incorrect or no longer relevant; this generally will
only happen for mislabeled deposit wallets.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCKCHAIN | TEXT | In this table, always Osmosis. Used to join to cross-chain tables. This column will deprecate in all tables except core.fact_blocks soon. Please modify your queries to join to the blocks table to use this field. |
| ADDRESS | TEXT | Address unique to an individual wallet, validator, or token. |
| CREATOR | TEXT | Name of the label creator - for now, this will always be “Flipside.” |
| LABEL_TYPE | TEXT | A broad category that describes what a label is representing. |
| LABEL_SUBTYPE | TEXT | Adds more detail to the label type. |
| LABEL | TEXT | The label or name of the address. |
| PROJECT_NAME | TEXT | The name of the project the label belongs to. |
| RAW_METADATA | ARRAY | Additional details about the validator or token in json format. |
| DIM_LABELS_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ |