> ## 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   | `filecoin.assets.fungible_balances` |
| Table Status | Beta 🌱                             |

### Table Columns

| Column Name         | Data Type         | Description                                                                                                                                                               |
| ------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| address             | VARCHAR(16777216) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies.                    |
| token\_type         | VARCHAR(16777216) | Token standard for the asset. One of: `erc20` (fungible), `erc721` (non-fungible), `erc1155` (semi-fungible), or the native currency symbol (e.g. `eth`, `matic`, `bnb`). |
| raw\_balance\_str   | VARCHAR(16777216) | Token balance in the smallest unit, stored as a string for full precision. Avoids floating-point truncation for tokens with very large integer balances.                  |
| balance             | FLOAT             | Token balance normalized by the token's decimal precision (raw\_balance / 10^decimals). Human-readable value (e.g. 1.5 USDC rather than 1500000).                         |
| usd\_balance        | FLOAT             | USD value of the token balance, computed using the exchange rate at the time of the balance snapshot.                                                                     |
| usd\_exchange\_rate | FLOAT             | USD price per unit of the token at the time of the event, used to compute `usd_amount`. Sourced from Allium's hourly price feed.                                          |
| tipset\_height      | NUMBER(38,0)      | Filecoin tipset height (block height). A tipset is a set of blocks at the same height that form the canonical chain.                                                      |
| tipset\_timestamp   | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the Filecoin tipset.                                                                                                                                   |