> ## 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.

# ERC721 Balances

### Table Details

| Property            | Value                                  |
| ------------------- | -------------------------------------- |
| Table Name          | `oasys.assets.erc721_balances`         |
| Table Status        | Production-Ready                       |
| Unique Key          | `unique_id`                            |
| Clustering Key(s)   | `block_timestamp::date, token_address` |
| Search Optimization | `address`, `block_number`, `token_id`  |

### Table Columns

| Column Name       | Data Type         | Description                                                                                  |
| ----------------- | ----------------- | -------------------------------------------------------------------------------------------- |
| address           | VARCHAR(42)       | The wallet address holding the tokens                                                        |
| token\_address    | VARCHAR(42)       | Contract address of the token                                                                |
| token\_name       | VARCHAR(16777216) | Name of the token                                                                            |
| token\_symbol     | VARCHAR(16777216) | Symbol of the token                                                                          |
| token\_id         | VARCHAR(16777216) | Unique identifier for the specific token within the collection (e.g., for ERC721 or ERC1155) |
| raw\_balance      | FLOAT             | Token balance, unnormalized                                                                  |
| raw\_balance\_str | VARCHAR(16777216) | Token balance as string to retain precision                                                  |
| balance           | FLOAT             | Token balance, normalized                                                                    |
| balance\_str      | VARCHAR(16777216) | Token balance as string to retain precision                                                  |
| transaction\_hash | VARCHAR(66)       | Hash of the transaction that last modified the balance                                       |
| block\_timestamp  | TIMESTAMP\_NTZ(9) | Timestamp of the block                                                                       |
| block\_number     | NUMBER(38,0)      | Number of the block                                                                          |
| block\_hash       | VARCHAR(66)       | Hash of the block                                                                            |
| unique\_id        | VARCHAR(16777216) | Unique identifier of the balances entry                                                      |
| \_updated\_at     | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated                                                 |
| \_created\_at     | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created                                                      |

### Related Docs

* [EVM Assets ERC721 Balances](/historical-data/supported-blockchains/evm/core-schemas/assets/balances/erc721-balances)