> ## 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 Latest (EVM)

The current fungible token balance of every address and token across the supported EVM chains in one table.

### Table Details

| Property | Value |
| - | - |
| Table Name | `crosschain.assets.fungible_balances_latest_evm` |
| Table Status | Production-Ready |

### Chain Coverage

| Table | Chains |
| - | - |
| `crosschain.assets.fungible_balances_latest_evm` | <details><summary>25 chains</summary>[Arbitrum](https://docs.allium.so/historical-data/supported-blockchains/evm/arbitrum/assets/fungible-balances-latest.md), [Arc](https://docs.allium.so/historical-data/supported-blockchains/evm/arc/assets/fungible-balances-latest.md), [Avalanche](https://docs.allium.so/historical-data/supported-blockchains/evm/avalanche/assets/fungible-balances-latest.md), [B3 ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/b3/assets/fungible-balances-latest.md), [Base](https://docs.allium.so/historical-data/supported-blockchains/evm/base/assets/fungible-balances-latest.md), [Berachain](https://docs.allium.so/historical-data/supported-blockchains/evm/berachain/assets/fungible-balances-latest.md), [Blast ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/blast/assets/fungible-balances-latest.md), [BNB Smart Chain](https://docs.allium.so/historical-data/supported-blockchains/evm/bsc/assets/fungible-balances-latest.md), [Core](https://docs.allium.so/historical-data/supported-blockchains/evm/core/assets/fungible-balances-latest.md), [Ethereum](https://docs.allium.so/historical-data/supported-blockchains/evm/ethereum/assets/fungible-balances-latest.md), [HyperEVM](https://docs.allium.so/historical-data/supported-blockchains/evm/hyperevm/assets/fungible-balances-latest.md), [Ink](https://docs.allium.so/historical-data/supported-blockchains/evm/ink/assets/fungible-balances-latest.md), [Linea](https://docs.allium.so/historical-data/supported-blockchains/evm/linea/assets/fungible-balances-latest.md), [Monad](https://docs.allium.so/historical-data/supported-blockchains/evm/monad/assets/fungible-balances-latest.md), [Optimism](https://docs.allium.so/historical-data/supported-blockchains/evm/optimism/assets/fungible-balances-latest.md), [Plasma](https://docs.allium.so/historical-data/supported-blockchains/evm/plasma/assets/fungible-balances-latest.md), [Polygon](https://docs.allium.so/historical-data/supported-blockchains/evm/polygon/assets/fungible-balances-latest.md), [Robinhood](https://docs.allium.so/historical-data/supported-blockchains/evm/robinhood/assets/fungible-balances-latest.md), [Scroll](https://docs.allium.so/historical-data/supported-blockchains/evm/scroll/assets/fungible-balances-latest.md), [Soneium](https://docs.allium.so/historical-data/supported-blockchains/evm/soneium/assets/fungible-balances-latest.md), [Stable](https://docs.allium.so/historical-data/supported-blockchains/evm/stable/assets/fungible-balances-latest.md), [Unichain](https://docs.allium.so/historical-data/supported-blockchains/evm/unichain/assets/fungible-balances-latest.md), [Vana](https://docs.allium.so/historical-data/supported-blockchains/evm/vana/assets/fungible-balances-latest.md), [World Chain](https://docs.allium.so/historical-data/supported-blockchains/evm/worldchain/assets/fungible-balances-latest.md), [X Layer](https://docs.allium.so/historical-data/supported-blockchains/evm/x_layer/assets/fungible-balances-latest.md)</details> |
| `<chain>.assets.fungible_balances_latest` | <details><summary>44 chains</summary>[Aptos](https://docs.allium.so/historical-data/supported-blockchains/move-ecosystem/aptos/assets/fungible-balances-latest.md), [Cosmos](https://docs.allium.so/historical-data/supported-blockchains/cosmos-ecosystem/cosmos/assets/fungible-balances-latest.md), [Injective](https://docs.allium.so/historical-data/supported-blockchains/cosmos-ecosystem/injective/assets/fungible-balances-latest.md), [Osmosis](https://docs.allium.so/historical-data/supported-blockchains/cosmos-ecosystem/osmosis/assets/fungible-balances-latest.md), [ApeChain](https://docs.allium.so/historical-data/supported-blockchains/evm/apechain/assets/fungible-balances-latest.md), [Arbitrum](https://docs.allium.so/historical-data/supported-blockchains/evm/arbitrum/assets/fungible-balances-latest.md), [Arc](https://docs.allium.so/historical-data/supported-blockchains/evm/arc/assets/fungible-balances-latest.md), [Avalanche](https://docs.allium.so/historical-data/supported-blockchains/evm/avalanche/assets/fungible-balances-latest.md), [Avalanche Fuji 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/avalanche_fuji/assets/fungible-balances-latest.md), [B3 ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/b3/assets/fungible-balances-latest.md), [Base](https://docs.allium.so/historical-data/supported-blockchains/evm/base/assets/fungible-balances-latest.md), [Berachain](https://docs.allium.so/historical-data/supported-blockchains/evm/berachain/assets/fungible-balances-latest.md), [Blast ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/blast/assets/fungible-balances-latest.md), [BNB Smart Chain](https://docs.allium.so/historical-data/supported-blockchains/evm/bsc/assets/fungible-balances-latest.md), [BOB](https://docs.allium.so/historical-data/supported-blockchains/evm/bob/assets/fungible-balances-latest.md), [Celo](https://docs.allium.so/historical-data/supported-blockchains/evm/celo/assets/fungible-balances-latest.md), [Core](https://docs.allium.so/historical-data/supported-blockchains/evm/core/assets/fungible-balances-latest.md), [Elysium](https://docs.allium.so/historical-data/supported-blockchains/evm/elysium/assets/fungible-balances-latest.md), [Ethereum](https://docs.allium.so/historical-data/supported-blockchains/evm/ethereum/assets/fungible-balances-latest.md), [HyperEVM](https://docs.allium.so/historical-data/supported-blockchains/evm/hyperevm/assets/fungible-balances-latest.md), [Ink](https://docs.allium.so/historical-data/supported-blockchains/evm/ink/assets/fungible-balances-latest.md), [Linea](https://docs.allium.so/historical-data/supported-blockchains/evm/linea/assets/fungible-balances-latest.md), [Mantle](https://docs.allium.so/historical-data/supported-blockchains/evm/mantle/assets/fungible-balances-latest.md), [MegaETH 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/megaeth/assets/fungible-balances-latest.md), [Monad](https://docs.allium.so/historical-data/supported-blockchains/evm/monad/assets/fungible-balances-latest.md), [Optimism](https://docs.allium.so/historical-data/supported-blockchains/evm/optimism/assets/fungible-balances-latest.md), [Plasma](https://docs.allium.so/historical-data/supported-blockchains/evm/plasma/assets/fungible-balances-latest.md), [Polygon](https://docs.allium.so/historical-data/supported-blockchains/evm/polygon/assets/fungible-balances-latest.md), [Robinhood](https://docs.allium.so/historical-data/supported-blockchains/evm/robinhood/assets/fungible-balances-latest.md), [Scroll](https://docs.allium.so/historical-data/supported-blockchains/evm/scroll/assets/fungible-balances-latest.md), [Sei](https://docs.allium.so/historical-data/supported-blockchains/evm/sei/assets/fungible-balances-latest.md), [Soneium](https://docs.allium.so/historical-data/supported-blockchains/evm/soneium/assets/fungible-balances-latest.md), [Sonic](https://docs.allium.so/historical-data/supported-blockchains/evm/sonic/assets/fungible-balances-latest.md), [Stable](https://docs.allium.so/historical-data/supported-blockchains/evm/stable/assets/fungible-balances-latest.md), [Tempo](https://docs.allium.so/historical-data/supported-blockchains/evm/tempo/assets/fungible-balances-latest.md), [TRON](https://docs.allium.so/historical-data/supported-blockchains/evm/tron/assets/fungible-balances-latest.md), [Unichain](https://docs.allium.so/historical-data/supported-blockchains/evm/unichain/assets/fungible-balances-latest.md), [Vana](https://docs.allium.so/historical-data/supported-blockchains/evm/vana/assets/fungible-balances-latest.md), [World Chain](https://docs.allium.so/historical-data/supported-blockchains/evm/worldchain/assets/fungible-balances-latest.md), [X Layer](https://docs.allium.so/historical-data/supported-blockchains/evm/x_layer/assets/fungible-balances-latest.md), [XDC Network](https://docs.allium.so/historical-data/supported-blockchains/evm/xdc_network/assets/fungible-balances-latest.md), [Cardano](https://docs.allium.so/historical-data/supported-blockchains/other-ecosystems/cardano/assets/fungible-balances-latest.md), [Filecoin 🌱](https://docs.allium.so/historical-data/supported-blockchains/other-ecosystems/filecoin/assets/fungible-balances-latest.md), [Stellar](https://docs.allium.so/historical-data/supported-blockchains/other-ecosystems/stellar/assets/fungible-balances-latest.md)</details> |

### Use Cases

* Track the latest balance of a group of addresses across chains
* Track the current distribution of a token

### Sample Query: Current portfolio balance of a wallet, per chain

```sql theme={null}
select
  chain,
  count(token_address) as tokens,
  sum(case when token_address = '0x0000000000000000000000000000000000000000' then usd_balance_current end) as native_balance_usd,
  sum(usd_balance_current) as total_balance_usd
from crosschain.assets.fungible_balances_latest_evm
where address = '0xe649a394fb16b58ee2e59feb2ea571e7733c812a'
group by all
```

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| chain | VARCHAR(10) | Slug identifying the blockchain this record belongs to (e.g. `ethereum`, `base`, `avalanche`, `solana`). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. |
| token\_type | VARCHAR(6) | Type or standard of the token, as the chain names it. For example `erc20`, `erc721`, `erc1155` or `native` on EVM chains, `TRC20` or `TRX` on Tron, `spl-token`, `system` or `sol` on Solana, and `coin` or `fungible_asset` on Aptos and Sui. The values depend on the table. |
| 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\_address | VARCHAR(16777216) | Contract address of the token. For EVM chains, native currency (e.g. ETH, MATIC) is represented as the zero address (0x0000000000000000000000000000000000000000). For Solana, this is the mint address. |
| token\_name | VARCHAR(16777216) | Full name of the token (e.g. "USD Coin", "Wrapped Ether"). |
| token\_symbol | VARCHAR(16777216) | Ticker symbol of the token (e.g. "USDC", "WETH"). |
| 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. |
| raw\_balance | FLOAT | Token balance in the token's smallest unit (not decimal-adjusted). Use `balance` for the human-readable normalized value. |
| balance\_str | VARCHAR(16777216) | Normalized token balance stored as a string for full precision. Equivalent to `balance` but avoids floating-point truncation. |
| 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\_block\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp of the block that last changed this balance. |
| last\_activity\_block\_number | NUMBER(38,0) | Block number of the block that last changed this balance. |
| last\_activity\_block\_hash | VARCHAR(16777216) | Hash of the block that last changed this balance. |
| unique\_id | VARCHAR(107) | Allium's deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| \_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 (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration). |
| \_changed\_since\_full\_refresh | BOOLEAN | Flag indicating whether this row was created or modified after the last full refresh of the model. Useful for identifying recently added or updated records in incremental processing. Same concept as `_change_since_full_refresh` — the column name varies by model generation. |
