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

End-of-day fungible token balances for every address and token across the supported EVM chains in one table.

### Table Details

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

### Chain Coverage

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

### Use Cases

* Track the portfolio balance of a wallet over time
* Track the number of holders of an asset over time
* Identify the distribution of assets across wallets over time

### Sample Query: USDC holders and holders of more than 100 USDC, daily

```sql theme={null}
select
  date,
  count(distinct case when balance > 0 then address end) as total_holders_count,
  count(distinct case when balance > 100 then address end) as holder_100_usdc_count
from crosschain.assets.fungible_balances_daily_evm
where chain = 'ethereum'
  and token_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' -- USDC
group by all
```

### Sample Query: Portfolio balance of a wallet over time

```sql theme={null}
select
  date,
  count(token_address) as tokens,
  sum(case when token_address = '0x0000000000000000000000000000000000000000' then usd_balance end) as native_balance_usd,
  sum(usd_balance) as total_balance_usd
from crosschain.assets.fungible_balances_daily_evm
where chain = 'ethereum'
  and 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. |
| 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\_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"). |
| token\_decimals | NUMBER(38,0) | Number of decimal places used to represent the token's smallest unit. Used to convert raw amounts: normalized\_amount = raw\_amount / 10^decimals. For example, USDC has 6 decimals, so 2500000 raw units = 2.5 USDC. |
| 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\_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. |
| usd\_balance | FLOAT | USD value of the token balance, computed using the exchange rate at the time of the balance snapshot. |
| 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. |
| \_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). |
