Table Details
| Property | Value |
|---|---|
| Table Name | near.assets.fungible_balances_daily |
| Table Status | Production-Ready |
| Unique Key | date, address, token_address, account_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| date | TIMESTAMP_NTZ(9) | End-of-day date (UTC) of the balance snapshot. |
| address | VARCHAR(16777216) | NEAR account that holds the token balance. |
| token_address | VARCHAR(16777216) | Contract account of the fungible token, or the native NEAR sentinel for unwrapped NEAR. |
| account_id | VARCHAR(16777216) | NEAR account ID associated with this balance (same as address for most wallets). |
| token_type | VARCHAR(16777216) | Token category (native or ft). |
| token_name | VARCHAR(16777216) | Full name of the token. |
| token_symbol | VARCHAR(16777216) | Ticker symbol of the token. |
| token_decimals | NUMBER(38,0) | Number of decimal places used to normalize the token’s raw amounts. |
| raw_balance_str | VARCHAR(16777216) | Token balance in the smallest unit, stored as a string for full precision. |
| raw_balance | FLOAT | Token balance in the smallest unit (not decimal-adjusted). |
| balance_str | VARCHAR(16777216) | Normalized token balance stored as a string for full precision. |
| balance | FLOAT | Token balance normalized by the token’s decimal precision. |
| usd_exchange_rate | FLOAT | USD price per token unit used to compute usd_balance. |
| usd_balance | FLOAT | USD value of the token balance at this daily snapshot. |
| last_activity_block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the most recent balance-changing activity. |
| last_activity_block_height | NUMBER(38,0) | Block height of the most recent balance-changing activity. |
| last_activity_block_hash | VARCHAR(16777216) | Block hash of the most recent balance-changing activity. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |