> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# EVM Latest Balances

> Most recent balance per address and token on EVM networks.

`balances_<chain>.latest` returns the most recent non-zero balance for every `(address, token_address)` pair. USD value is joined from `prices.latest`. Refreshed hourly.

For historical balances use [`balances_<chain>.daily_updates`](/data-catalog/curated/balances/evm-daily-updates). For block-level resolution use [`balances_<chain>.updates`](/data-catalog/curated/balances/evm-updates).

## Table Schema

Examples are illustrative values for USDC on Ethereum, assuming a USD price of 1.00. They are not a live balance snapshot.

| Column | Type | Description | Example |
| - | - | - | - |
| `blockchain` | `varchar` | Chain identifier (e.g. `ethereum`) | `ethereum` |
| `address` | `varbinary` | Account address | `0xd8da6bf26964af9d7eed9e03e53415d37aa96045` |
| `token_address` | `varbinary` | Token contract address. Native tokens use the standardized address from `dune.blockchains` (zero address on most EVMs, `0x0000…1010` on Polygon). | `0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48` |
| `token_standard` | `varchar` | `native` or `erc20` | `erc20` |
| `token_symbol` | `varchar` | Token symbol from `tokens_<chain>.erc20` (nullable) | `USDC` |
| `balance_raw` | `uint256` | Current balance in raw units (always `> 0`) | `1000000000` |
| `balance` | `double` | Current balance in display units (`balance_raw / 10^decimals`, falls back to 18 decimals when unknown) | `1000.0` |
| `balance_usd` | `double` | `balance * prices.latest.price`. `NULL` when no price is available for that token; `coalesce(balance_usd, 0)` if you need to sum across mixed-coverage tokens. | `1000.0` |
| `block_number` | `bigint` | Block of the most recent balance update | `21000000` |
| `updated_at` | `timestamp` | Block time of the most recent balance update | `2024-10-20 12:00:00` |

## Example Queries

**Current portfolio for a wallet, USD-sorted:**

```sql theme={null}
SELECT token_symbol, token_address, balance, balance_usd
FROM balances_ethereum.latest
WHERE address = 0xd8da6bf26964af9d7eed9e03e53415d37aa96045
ORDER BY balance_usd DESC NULLS LAST
```

**Top 50 holders of a token:**

```sql theme={null}
SELECT address, balance, balance_usd
FROM balances_ethereum.latest
WHERE token_address = 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 -- USDC
ORDER BY balance DESC
LIMIT 50
```

**Native ETH locked in the WETH contract (equals current wrapped ETH supply):**

```sql theme={null}
SELECT balance AS eth_wrapped
FROM balances_ethereum.latest
WHERE address = 0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2 -- WETH
  AND token_address = 0x0000000000000000000000000000000000000000 -- native ETH
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.