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

Fungible balance changes for native tokens and ERC-20 tokens across every supported EVM chain in one table.

### Table Details

| Property | Value |
| - | - |
| Table Name | `crosschain.assets.fungible_balances_evm` |
| Table Status | Production-Ready |
| Unique Key | `block_timestamp`, `unique_id` |

### Chain Coverage

| Table | Chains |
| - | - |
| `crosschain.assets.fungible_balances_evm` | <details><summary>25 chains</summary>[Arbitrum](https://docs.allium.so/historical-data/supported-blockchains/evm/arbitrum/assets/fungible-balances.md), [Arc](https://docs.allium.so/historical-data/supported-blockchains/evm/arc/assets/fungible-balances.md), [Avalanche](https://docs.allium.so/historical-data/supported-blockchains/evm/avalanche/assets/fungible-balances.md), [B3 ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/b3/assets/fungible-balances.md), [Base](https://docs.allium.so/historical-data/supported-blockchains/evm/base/assets/fungible-balances.md), [Berachain](https://docs.allium.so/historical-data/supported-blockchains/evm/berachain/assets/fungible-balances.md), [Blast ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/blast/assets/fungible-balances.md), [BNB Smart Chain](https://docs.allium.so/historical-data/supported-blockchains/evm/bsc/assets/fungible-balances.md), [Core](https://docs.allium.so/historical-data/supported-blockchains/evm/core/assets/fungible-balances.md), [Ethereum](https://docs.allium.so/historical-data/supported-blockchains/evm/ethereum/assets/fungible-balances.md), [HyperEVM](https://docs.allium.so/historical-data/supported-blockchains/evm/hyperevm/assets/fungible-balances.md), [Ink](https://docs.allium.so/historical-data/supported-blockchains/evm/ink/assets/fungible-balances.md), [Linea](https://docs.allium.so/historical-data/supported-blockchains/evm/linea/assets/fungible-balances.md), [Monad](https://docs.allium.so/historical-data/supported-blockchains/evm/monad/assets/fungible-balances.md), [Optimism](https://docs.allium.so/historical-data/supported-blockchains/evm/optimism/assets/fungible-balances.md), [Plasma](https://docs.allium.so/historical-data/supported-blockchains/evm/plasma/assets/fungible-balances.md), [Polygon](https://docs.allium.so/historical-data/supported-blockchains/evm/polygon/assets/fungible-balances.md), [Robinhood](https://docs.allium.so/historical-data/supported-blockchains/evm/robinhood/assets/fungible-balances.md), [Scroll](https://docs.allium.so/historical-data/supported-blockchains/evm/scroll/assets/fungible-balances.md), [Soneium](https://docs.allium.so/historical-data/supported-blockchains/evm/soneium/assets/fungible-balances.md), [Stable](https://docs.allium.so/historical-data/supported-blockchains/evm/stable/assets/fungible-balances.md), [Unichain](https://docs.allium.so/historical-data/supported-blockchains/evm/unichain/assets/fungible-balances.md), [Vana](https://docs.allium.so/historical-data/supported-blockchains/evm/vana/assets/fungible-balances.md), [World Chain](https://docs.allium.so/historical-data/supported-blockchains/evm/worldchain/assets/fungible-balances.md), [X Layer](https://docs.allium.so/historical-data/supported-blockchains/evm/x_layer/assets/fungible-balances.md)</details> |
| `<chain>.assets.fungible_balances` | <details><summary>64 chains</summary>[Babylon](https://docs.allium.so/historical-data/supported-blockchains/cosmos-ecosystem/babylon/assets/fungible-balances.md), [Cosmos](https://docs.allium.so/historical-data/supported-blockchains/cosmos-ecosystem/cosmos/assets/fungible-balances.md), [dYdX](https://docs.allium.so/historical-data/supported-blockchains/cosmos-ecosystem/dydx/assets/fungible-balances.md), [Injective](https://docs.allium.so/historical-data/supported-blockchains/cosmos-ecosystem/injective/assets/fungible-balances.md), [Osmosis](https://docs.allium.so/historical-data/supported-blockchains/cosmos-ecosystem/osmosis/assets/fungible-balances.md), [Abstract](https://docs.allium.so/historical-data/supported-blockchains/evm/abstract/assets/fungible-balances.md), [ApeChain](https://docs.allium.so/historical-data/supported-blockchains/evm/apechain/assets/fungible-balances.md), [Arbitrum](https://docs.allium.so/historical-data/supported-blockchains/evm/arbitrum/assets/fungible-balances.md), [Arc](https://docs.allium.so/historical-data/supported-blockchains/evm/arc/assets/fungible-balances.md), [Arc Testnet 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/arc_testnet/assets/fungible-balances.md), [Avalanche](https://docs.allium.so/historical-data/supported-blockchains/evm/avalanche/assets/fungible-balances.md), [Avalanche Fuji 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/avalanche_fuji/assets/fungible-balances.md), [B3 ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/b3/assets/fungible-balances.md), [Base](https://docs.allium.so/historical-data/supported-blockchains/evm/base/assets/fungible-balances.md), [Berachain](https://docs.allium.so/historical-data/supported-blockchains/evm/berachain/assets/fungible-balances.md), [Blast ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/blast/assets/fungible-balances.md), [BNB Smart Chain](https://docs.allium.so/historical-data/supported-blockchains/evm/bsc/assets/fungible-balances.md), [BNB Smart Chain (BSC) Testnet 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/bsc_testnet/assets/fungible-balances.md), [BOB](https://docs.allium.so/historical-data/supported-blockchains/evm/bob/assets/fungible-balances.md), [Celo](https://docs.allium.so/historical-data/supported-blockchains/evm/celo/assets/fungible-balances.md), [Celo Sepolia 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/celo_sepolia/assets/fungible-balances.md), [Core](https://docs.allium.so/historical-data/supported-blockchains/evm/core/assets/fungible-balances.md), [Elysium](https://docs.allium.so/historical-data/supported-blockchains/evm/elysium/assets/fungible-balances.md), [Ethereum](https://docs.allium.so/historical-data/supported-blockchains/evm/ethereum/assets/fungible-balances.md), [Flynet 🌱 ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/flynet/assets/fungible-balances.md), [HyperEVM](https://docs.allium.so/historical-data/supported-blockchains/evm/hyperevm/assets/fungible-balances.md), [Ink](https://docs.allium.so/historical-data/supported-blockchains/evm/ink/assets/fungible-balances.md), [Linea](https://docs.allium.so/historical-data/supported-blockchains/evm/linea/assets/fungible-balances.md), [Mantle](https://docs.allium.so/historical-data/supported-blockchains/evm/mantle/assets/fungible-balances.md), [Monad](https://docs.allium.so/historical-data/supported-blockchains/evm/monad/assets/fungible-balances.md), [Monad Testnet](https://docs.allium.so/historical-data/supported-blockchains/evm/monad_testnet/assets/fungible-balances.md), [Mova](https://docs.allium.so/historical-data/supported-blockchains/evm/mova/assets/fungible-balances.md), [Optimism](https://docs.allium.so/historical-data/supported-blockchains/evm/optimism/assets/fungible-balances.md), [Optimism Sepolia 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/optimism_sepolia/assets/fungible-balances.md), [Plasma](https://docs.allium.so/historical-data/supported-blockchains/evm/plasma/assets/fungible-balances.md), [Plasma Testnet 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/plasma_testnet/assets/fungible-balances.md), [Polygon](https://docs.allium.so/historical-data/supported-blockchains/evm/polygon/assets/fungible-balances.md), [Polygon Amoy 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/polygon_amoy/assets/fungible-balances.md), [Robinhood](https://docs.allium.so/historical-data/supported-blockchains/evm/robinhood/assets/fungible-balances.md), [Robinhood Testnet](https://docs.allium.so/historical-data/supported-blockchains/evm/robinhood_testnet/assets/fungible-balances.md), [Ronin](https://docs.allium.so/historical-data/supported-blockchains/evm/ronin/assets/fungible-balances.md), [Scroll](https://docs.allium.so/historical-data/supported-blockchains/evm/scroll/assets/fungible-balances.md), [Sei](https://docs.allium.so/historical-data/supported-blockchains/evm/sei/assets/fungible-balances.md), [Sei Testnet 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/sei_testnet/assets/fungible-balances.md), [Seismic Testnet 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/seismic_testnet/assets/fungible-balances.md), [Soneium](https://docs.allium.so/historical-data/supported-blockchains/evm/soneium/assets/fungible-balances.md), [Sonic](https://docs.allium.so/historical-data/supported-blockchains/evm/sonic/assets/fungible-balances.md), [Stable](https://docs.allium.so/historical-data/supported-blockchains/evm/stable/assets/fungible-balances.md), [Tempo](https://docs.allium.so/historical-data/supported-blockchains/evm/tempo/assets/fungible-balances.md), [TRON](https://docs.allium.so/historical-data/supported-blockchains/evm/tron/assets/fungible-balances.md), [Unichain](https://docs.allium.so/historical-data/supported-blockchains/evm/unichain/assets/fungible-balances.md), [Vana](https://docs.allium.so/historical-data/supported-blockchains/evm/vana/assets/fungible-balances.md), [World Chain](https://docs.allium.so/historical-data/supported-blockchains/evm/worldchain/assets/fungible-balances.md), [X Layer](https://docs.allium.so/historical-data/supported-blockchains/evm/x_layer/assets/fungible-balances.md), [XDC Network](https://docs.allium.so/historical-data/supported-blockchains/evm/xdc_network/assets/fungible-balances.md), [ZKsync](https://docs.allium.so/historical-data/supported-blockchains/evm/zksync/assets/fungible-balances.md), [ZkSync Sepolia 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/zksync_sepolia/assets/fungible-balances.md), [Zora](https://docs.allium.so/historical-data/supported-blockchains/evm/zora/assets/fungible-balances.md), [Cardano](https://docs.allium.so/historical-data/supported-blockchains/other-ecosystems/cardano/assets/fungible-balances.md), [Casper Network](https://docs.allium.so/historical-data/supported-blockchains/other-ecosystems/casper/assets/fungible-balances.md), [Filecoin 🌱](https://docs.allium.so/historical-data/supported-blockchains/other-ecosystems/filecoin/assets/fungible-balances.md), [NEAR](https://docs.allium.so/historical-data/supported-blockchains/other-ecosystems/near/assets/fungible-balances.md), [Stellar](https://docs.allium.so/historical-data/supported-blockchains/other-ecosystems/stellar/assets/fungible-balances.md), [TON](https://docs.allium.so/historical-data/supported-blockchains/other-ecosystems/ton/assets/fungible-balances.md)</details> |

### How Rows Work

* Each row is an event or transaction that changed an address's balance of an asset, at block level.
* **A new row appears only when a transaction changes the balance.**
* For example, a wallet that received 1 ETH in 2015 and had no further changes until yesterday has two rows: the 2015 receipt and yesterday's change.

### Use Cases

* Track block-level changes in the balance of an address and token pair
* For balances at a point in time between daily snapshots, use [Balances at Any Timestamp](https://docs.allium.so/historical-data/balances/at-timestamp.md)

### 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(16777216) | 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(42) | 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 | FLOAT | USD value of the token balance, computed using the exchange rate at the time of the balance snapshot. |
| usd\_exchange\_rate | FLOAT | USD price per unit of the token at the row's timestamp, used to compute the row's USD values. Sourced from Allium's hourly price feed. |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block in which this event was confirmed. |
| block\_number | NUMBER(38,0) | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block. |
| block\_hash | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| unique\_id | VARCHAR(16777216) | 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. |
| \_created\_at | TIMESTAMP\_NTZ(9) | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed. |
| \_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). |
