crosschain.core Table: dim_labels Type: View
What
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 programatically 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 |
|---|---|---|
| SYSTEM_CREATED_AT | TIMESTAMP_LTZ | SYSTEM_CREATED_AT column |
| INSERT_DATE | TIMESTAMP_LTZ | The date the label was inserted in the table |
| BLOCKCHAIN | TEXT | The name of the blockchain |
| ADDRESS | TEXT | Address that the label is for. This is the field that should be used to join other tables with labels. |
| CREATOR | TEXT | The name of the creator of the label |
| LABEL_TYPE | TEXT | A high-level category describing the addresses main function or ownership |
| LABEL_SUBTYPE | TEXT | A sub-category nested within label type providing further detail |
| ADDRESS_NAME | TEXT | Name of the address |
| PROJECT_NAME | TEXT | Name of the controlling entity of the address |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |
| DIM_LABELS_ID | TEXT | The unique identifier for each row in the table. |