> ## 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.

# Balances

> Token and asset balance data across EVM and Solana networks

<Warning>
  **Open Beta**: The balances tables are currently in open beta and may experience performance limitations. We are actively working on revamping and improving these tables. For optimal performance, please follow the query patterns documented on the individual balance pages.
</Warning>

Dune provides token balance data that enables tracking of asset holdings across blockchain addresses. Balance data is essential for portfolio analysis, wallet tracking, and understanding asset distribution across networks.

<Info>
  **Maintained by:** Dune · **Refresh:** \~1.5 hours · **Chains:** EVM networks, Solana
</Info>

<Card title="Get This Data" icon="database" href="https://dune.com/enterprise?dataset=balances">
  Access balance data via API, Datashare, or the Dune App.
</Card>

## Available Datasets

<CardGroup cols={2}>
  <Card title="EVM Token & NFT Balances" icon="scale-balanced" href="/data-catalog/curated/balances/evm-balances">
    Token balances for addresses on EVM-compatible networks including native currencies, ERC20, ERC721, and ERC1155 tokens
  </Card>

  <Card title="Solana Latest Balances" icon="bolt" href="/data-catalog/curated/balances/solana-latest-balances">
    Current SOL and SPL token balances for every address on Solana
  </Card>

  <Card title="Solana Daily Balances" icon="calendar-day" href="/data-catalog/curated/balances/solana-daily-balances">
    Historical daily SOL and SPL token balance snapshots for every address on Solana
  </Card>
</CardGroup>

## Key Features

* **Multi-Asset Coverage**: Native currencies, ERC20 tokens, NFTs (ERC721/ERC1155), SOL, and SPL tokens
* **Daily Snapshots**: End-of-day balance snapshots for historical analysis
* **Granular Changes**: Block-level balance change tracking
* **Cross-Chain Support**: Balance data across multiple EVM networks and Solana

## When to Use These Tables

* Track wallet portfolio holdings and historical balances
* Analyze token holder distribution and concentration metrics
* Monitor treasury balances for DAOs and protocols
* Build wallet scoring and risk profiling systems
* Power portfolio dashboards and balance alerts

## Query Performance

Balance tables come in two variants: `_latest` (current snapshot) and `_daily` (historical). Use `_latest` for current balances and `_daily` for historical analysis.

**Partition keys:** `blockchain`, `token_address` (varies by table)

```sql theme={null}
-- ✅ Good: latest balances with chain filter
SELECT * FROM balances.erc20_latest
WHERE blockchain = 'ethereum'
  AND address = 0x...

-- ✅ Good: historical with date filter
SELECT * FROM balances.erc20_daily
WHERE blockchain = 'ethereum'
  AND block_date >= DATE '2025-01-01'
  AND address = 0x...
```

## Methodology

Balance tables are maintained by Dune ([source code](https://github.com/duneanalytics/spellbook)). They compute cumulative balances from token transfer events — summing all incoming and outgoing transfers per address per token. The `_latest` tables provide the most recent balance snapshot, while `_daily` tables store end-of-day balances for historical analysis.

## Example Queries

**Top ETH holders on Ethereum:**

```sql theme={null}
SELECT
  address,
  balance,
  balance_usd
FROM balances.erc20_latest
WHERE blockchain = 'ethereum'
  AND token_address = 0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2 -- WETH
ORDER BY balance DESC
LIMIT 20
```

**Daily USDC balance for a specific wallet:**

```sql theme={null}
SELECT
  block_date,
  balance,
  balance_usd
FROM balances.erc20_daily
WHERE blockchain = 'ethereum'
  AND address = 0x...
  AND token_address = 0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48
  AND block_date >= DATE '2025-01-01'
ORDER BY block_date
```

## Related Tables

* `tokens.transfers` — Raw transfer events underlying balance calculations
* `prices.day` / `prices.latest` — Token pricing for USD balance values
* `tokens.erc20` — Token metadata (symbols, decimals)
* `tokens_solana.fungible` — Solana SPL token metadata
* `labels.addresses` — Address identification for known entities

<CardGroup cols={2}>
  <Card title="Enterprise Data Solutions" icon="building" href="https://dune.com/enterprise">
    Need custom balance datasets or dedicated support? Talk to our enterprise team.
  </Card>

  <Card title="Build Custom Models" icon="code" href="/api-reference/connectors/overview">
    Build private balance tracking pipelines with the dbt Connector.
  </Card>
</CardGroup>