> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Ncs Eod

### Table Details

| Property            | Value                                              |
| ------------------- | -------------------------------------------------- |
| Table Name          | `tempo.stablecoins.ncs_eod`                        |
| Table Status        | Production-Ready                                   |
| Unique Key          | `block_date`, `address`, `token_address`           |
| Clustering Key(s)   | `block_date, _short_address, _short_token_address` |
| Search Optimization | `address`, `token_address`                         |

### Table Columns

| Column Name                     | Data Type         | Description                                                           |
| ------------------------------- | ----------------- | --------------------------------------------------------------------- |
| chain                           | VARCHAR(16777216) |                                                                       |
| address                         | VARCHAR(42)       |                                                                       |
| token\_address                  | VARCHAR(42)       |                                                                       |
| token\_name                     | VARCHAR(16777216) |                                                                       |
| token\_symbol                   | VARCHAR(16777216) |                                                                       |
| token\_decimals                 | NUMBER(38,0)      |                                                                       |
| product\_id                     | VARCHAR(16777216) |                                                                       |
| ncs\_address\_type              | VARCHAR(16777216) |                                                                       |
| ncs\_address\_label             | VARCHAR(16777216) |                                                                       |
| ncs\_supply\_layer              | VARCHAR(16777216) |                                                                       |
| raw\_balance\_str               | VARCHAR(16777216) |                                                                       |
| raw\_balance                    | FLOAT             |                                                                       |
| balance\_str                    | VARCHAR(16777216) |                                                                       |
| balance                         | FLOAT             |                                                                       |
| block\_date                     | TIMESTAMP\_NTZ(9) |                                                                       |
| block\_timestamp                | TIMESTAMP\_NTZ(9) |                                                                       |
| block\_number                   | NUMBER(38,0)      |                                                                       |
| block\_hash                     | VARCHAR(16777216) |                                                                       |
| \_has\_error                    | NUMBER(38,0)      |                                                                       |
| \_short\_address                | VARCHAR(4)        |                                                                       |
| \_short\_token\_address         | VARCHAR(4)        |                                                                       |
| \_ncs\_seed\_updated\_at        | TIMESTAMP\_NTZ(9) |                                                                       |
| \_balances\_created\_at         | TIMESTAMP\_NTZ(9) |                                                                       |
| \_created\_at                   | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.              |
| \_updated\_at                   | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.         |
| \_changed\_since\_full\_refresh | BOOLEAN           | Indicates if the record has changed since the last full data refresh. |