> ## 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 Daily 🌱

### Table Details

| Property     | Value                                     |
| ------------ | ----------------------------------------- |
| Table Name   | `filecoin.assets.fungible_balances_daily` |
| Table Status | Beta 🌱                                   |

### Table Columns

| Column Name                       | Data Type         | Description                                                                                                                                                               |
| --------------------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| date                              | TIMESTAMP\_NTZ(9) | Calendar date (UTC) this record represents. Used in daily aggregate tables.                                                                                               |
| 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\_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.                                          |
| usd\_balance                      | FLOAT             | USD value of the token balance, computed using the exchange rate at the time of the balance snapshot.                                                                     |
| last\_activity\_tipset\_height    | NUMBER(38,0)      | The tipset height of the last balance update used for forward fill.                                                                                                       |
| last\_activity\_tipset\_timestamp | TIMESTAMP\_NTZ(9) | The timestamp of the last balance update used for forward fill.                                                                                                           |