# Tokens Table

Tokens are curated metadata that identify the key properties of a token and identify the token type.

| Name                       | Type             | Description                                                                                                                                                 |
| -------------------------- | ---------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `MODEL`                    | `TEXT`           | The type of object model used during ingestion of metadata.                                                                                                 |
| `RETRIEVAL_TIMESTAMP`      | `FIXED`          | The raw value of the time in Unix Epoch time (in UTC time zone) in which the token is retrieved.                                                            |
| `RETRIEVAL_DATETIME`       | `TIMESTAMP_NTZ`  | The timestamp in UTC in which the token was retrieved.                                                                                                      |
| `TOKEN_ADDRESS`            | `TEXT`           | The mint address of the token.                                                                                                                              |
| `SYMBOL`                   | `TEXT`           | The symbol of the token being searched.                                                                                                                     |
| `NAME`                     | `TEXT`           | The name of the token.                                                                                                                                      |
| `PUBKEY_ADDRESS`           | `TEXT`           | The Public Key of the token mint address.                                                                                                                   |
| `UPDATE_AUTHORITY_ADDRESS` | `TEXT`           | The update authority address for this token.                                                                                                                |
| `JSON`                     | `VARIANT`        | If JSON metadata is appended to the object model, additional token metadata will be displayed here.                                                         |
| `JSON_LOADED`              | `BOOLEAN`        | Boolean to determine if JSON metadata was added to the model.                                                                                               |
| `URI`                      | `TEXT`           | The URI to the token JSON metadata.                                                                                                                         |
| `IS_MUTABLE`               | `BOOLEAN`        | Boolean to identify if token metadata attributes are mutable.                                                                                               |
| `PRIMARY_SALE_HAPPENED`    | `BOOLEAN`        | Indicates whether the first sale occurred.                                                                                                                  |
| `SELLER_FEE_BASIS_POINTS`  | `FIXED`          | The fee basis points for the seller of the token.                                                                                                           |
| `EDITION_NONCE`            | `FIXED`          | The nonce value for the token edition                                                                                                                       |
| `CREATORS`                 | `VARIANT`        | The creators associated with the token.                                                                                                                     |
| `TOKEN_STANDARD`           | `TEXT`           | The enumerated token standard used, determines whether token is unknown, semi-fungible, non-fungible edition, or programmable non-fungible (in this order). |
| `TOKEN_STANDARD_NAME`      | `TEXT`           | Label for the token standard.                                                                                                                               |
| `COLLECTION`               | `VARIANT`        | The collection associated with the token.                                                                                                                   |
| `COLLECTION_DETAILS`       | `VARIANT`        | The details of the collection associated with the token.                                                                                                    |
| `USES`                     | `VARIANT`        | The uses of the token.                                                                                                                                      |
| `PROGRAMMABLE_CONFIG`      | `VARIANT`        | The programmable configuration of the token.                                                                                                                |
| `LEGACY_EXTENSIONS`        | `VARIANT`        | If legacy object was used, displays user provided extensions associated with this token.                                                                    |
| `LEGACY_LOGO_URI`          | `TEXT`           | If legacy object was used, displays user provided logo URI for this token.                                                                                  |
| `LEGACY_TAGS`              | `VARIANT`        | If legacy object was used, displays user provided tags associated with this token.                                                                          |
| `MINT_AUTHORITY`           | `TEXT`           | n/a                                                                                                                                                         |
| `SUPPLY`                   | `TEXT`           | n/a                                                                                                                                                         |
| `DECIMALS`                 | `FIXED`          | n/a                                                                                                                                                         |
| `FREEZE_AUTHORITY`         | `TEXT`           | n/a                                                                                                                                                         |
| `MINT_DATA`                | `VARIANT`        | n/a                                                                                                                                                         |
| `METADATA_DATA`            | `VARIANT`        | n/a                                                                                                                                                         |
| `EDITION_DATA`             | `VARIANT`        | n/a                                                                                                                                                         |
| `DATE_CREATED`             | `TIMESTAMP_NTZ`  | n/a                                                                                                                                                         |
| `DATE_UPDATED`             | `TIMESTAMP_NTZ`  | n/a                                                                                                                                                         |

🔍 Use these columns to gather comprehensive insights into token properties on the blockchain, such as its mint address, symbol, and any associated metadata. This information can be leveraged to filter or categorize tokens in your analysis (e.g., by name, symbol, or metadata presence) and to gain insights into how tokens are managed or updated on the blockchain, along with other key attributes. You can:

* Identify each token by its mint address, symbol, and name using `TOKEN_ADDRESS`, `SYMBOL`, and `NAME`.
* Access key metadata details via `PUBKEY_ADDRESS` and `UPDATE_AUTHORITY_ADDRESS`.
* Retrieve additional metadata from `JSON`, `JSON_LOADED`, and `URI`.
* Determine if token attributes are mutable using `IS_MUTABLE` and verify primary sale status with `PRIMARY_SALE_HAPPENED`.
* Evaluate fee and edition information through `SELLER_FEE_BASIS_POINTS` and `EDITION_NONCE`.
* Categorize tokens by standards and collections with `TOKEN_STANDARD`, `TOKEN_STANDARD_NAME`, `COLLECTION`, and `COLLECTION_DETAILS`.
* Understand token usage and programmable configurations with `USES` and `PROGRAMMABLE_CONFIG`.
* Review legacy metadata (extensions, logo URI, tags) using `LEGACY_EXTENSIONS`, `LEGACY_LOGO_URI`, and `LEGACY_TAGS`.
* Monitor data recency with `DATE_CREATED` and `DATE_UPDATED`.

💡 For example, you might query `TOKEN_ADDRESS`, `SYMBOL`, and `COLLECTION` to filter tokens based on their collection affiliation, among other parameters.
