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