| 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_current | FLOAT | USD value of the token balance using the most recent available price, updated independently of balance changes. |
| usd_balance_at_block_timestamp | FLOAT | USD value of the token balance using the price at the timestamp of the last balance-changing event. |
| usd_exchange_rate_current | FLOAT | Most recent USD price per unit of the token, used to compute usd_balance_current. |
| usd_exchange_rate_at_block_timestamp | FLOAT | USD price per unit of the token at the timestamp of the last balance-changing event. |
| 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. |
| _updated_at__usd_exchange_rate_current | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to the current USD exchange rate for this token. Updated independently when prices are refreshed, separate from balance data. |
| _updated_at__historical | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to the historical (at-block-timestamp) data for this row. |
| _created_at__onchain_lake | TIMESTAMP_NTZ(9) | Timestamp (UTC) when this row was first written to the onchain lake (the raw data layer before mart transformation). |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
