EVM Latest Balances - Dune Docs

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. For block-level resolution use balances_<chain>.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:

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:

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):

SELECT balance AS eth_wrapped
FROM balances_ethereum.latest
WHERE address = 0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2 -- WETH
  AND token_address = 0x0000000000000000000000000000000000000000 -- native ETH