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

# Fungible Balances

### Table Details

| Property     | Value                           |
| ------------ | ------------------------------- |
| Table Name   | `dydx.assets.fungible_balances` |
| Table Status | Production-Ready                |
| Unique Key   | `block_timestamp`, `unique_id`  |

### Table Columns

| Column Name             | Data Type         | Description                                                                                                                                                                                            |
| ----------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| address                 | VARCHAR(16777216) | The wallet address holding the balance.                                                                                                                                                                |
| currency                | VARCHAR(16777216) | The currency/token identifier.                                                                                                                                                                         |
| token\_name             | VARCHAR(16777216) | The name of the token.                                                                                                                                                                                 |
| token\_symbol           | VARCHAR(16777216) | The symbol of the token.                                                                                                                                                                               |
| raw\_balance\_str       | VARCHAR(16777216) | The raw balance as a string.                                                                                                                                                                           |
| raw\_balance            | FLOAT             | The raw balance as a float.                                                                                                                                                                            |
| balance\_str            | VARCHAR(16777216) | The normalized balance as a string.                                                                                                                                                                    |
| balance                 | FLOAT             | The normalized balance as a float.                                                                                                                                                                     |
| usd\_balance            | FLOAT             | The USD value of the balance.                                                                                                                                                                          |
| usd\_exchange\_rate     | FLOAT             | The USD exchange rate for the token.                                                                                                                                                                   |
| event\_index            | NUMBER(38,0)      | The index of the event within the transaction.                                                                                                                                                         |
| transaction\_hash       | VARCHAR(66)       | The hash of the transaction.                                                                                                                                                                           |
| transaction\_index      | NUMBER(38,0)      | The index of the transaction within the block.                                                                                                                                                         |
| block\_timestamp        | TIMESTAMP\_NTZ(9) | The timestamp when the block was created.                                                                                                                                                              |
| block\_height           | NUMBER(38,0)      | The sequential number of the block in the blockchain.                                                                                                                                                  |
| block\_hash             | VARCHAR(66)       | The hash of the block.                                                                                                                                                                                 |
| block\_event\_kind      | VARCHAR(16777216) | The phase in which the block event was emitted. Possible values are: begin (before transactions are processed), end (after all transactions are processed), finalize (immediately before block commit) |
| block\_event\_index     | NUMBER(38,0)      | The index of the block event.                                                                                                                                                                          |
| block\_event\_type      | VARCHAR(16777216) | The type of the block event.                                                                                                                                                                           |
| unique\_id              | VARCHAR(16777216) | A unique identifier for this record.                                                                                                                                                                   |
| \_address\_short        | VARCHAR(16777216) | A shortened version of the address for indexing.                                                                                                                                                       |
| \_currency\_short       | VARCHAR(16777216) | A shortened version of the currency for indexing.                                                                                                                                                      |
| \_pseudo\_global\_order | NUMBER(38,0)      | A pseudo-global ordering field for consistent sorting.                                                                                                                                                 |
| \_created\_at           | TIMESTAMP\_NTZ(9) | The timestamp when the entry was created.                                                                                                                                                              |
| \_updated\_at           | TIMESTAMP\_NTZ(9) | The timestamp when the entry was updated.                                                                                                                                                              |

### Related Docs

* [COSMOS Assets Fungible Balances](/historical-data/supported-blockchains/cosmos-ecosystem/core-schemas/assets/fungible-balances)