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

# Stablecoin Balances (Multichain)

> Normalized daily stablecoin balances across EVM, Solana, and Tron

export const StablecoinBalancesSupplyNote = ({filterHint, includeCoverageGap = false, includeAddressCategoryBridge = false}) => <>
    <h2>Interpreting balances vs circulating supply</h2>
    <ul>
      <li>This table represents onchain balances, which is different from circulating supply.</li>
      <li>Bridge-locked funds are intentionally included in balances. For example, more than $4B USDT can appear in the Tether <code>USDT0Adapter</code> contract on Ethereum while representing circulating <code>USDT0</code> on other chains.</li>
      <li>We are not subtracting bridge balances at this stage because exclusions are not objective across bridge designs, and some bridge-held balances represent liquidity for chains not covered elsewhere.</li>
      {includeCoverageGap && <li>Excluding only selected bridges would also be incomplete in practice: some bridge-held balances represent liquidity for chains not covered elsewhere (for example Lighter and Hyperliquid bridge balances).</li>}
      {includeAddressCategoryBridge && <li>Bridge exposure is directly analyzable with <code>address_category = 'bridge'</code>.</li>}
      <li>{filterHint}</li>
      <li>We will continue to work toward a more reliable total supply measure.</li>
    </ul>
  </>;

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

export const PrepackagedEnrichedCtaCard = ({href, title = "Upgrade to the enriched dataset"}) => <Card title={title} icon="info" href={href}>
    Skip manual reconstruction. The enriched version packages attribution and methodology so you can move from raw data to insights faster.
  </Card>;

The `stablecoins_multichain.balances` table is a normalized multichain balance view across:

<PrepackagedEnrichedCtaCard href="/data-catalog/curated/stablecoins/overview" title="Use the prepackaged enriched versions" />

* EVM stablecoin balances
* Solana stablecoin balances
* Tron stablecoin balances

It standardizes `address` and `token_address` fields as `VARCHAR` for cross-chain analysis.

One row represents one address-token balance snapshot for a specific day after cross-chain normalization.

## Table schema

| Column           | Type        | Description                              |
| ---------------- | ----------- | ---------------------------------------- |
| `blockchain`     | `VARCHAR`   | Chain name                               |
| `day`            | `DATE`      | Balance date                             |
| `address`        | `VARCHAR`   | Holder address (normalized)              |
| `token_symbol`   | `VARCHAR`   | Token symbol                             |
| `token_address`  | `VARCHAR`   | Token contract/mint address (normalized) |
| `token_standard` | `VARCHAR`   | Token standard                           |
| `token_id`       | `VARCHAR`   | Token id (typically NULL)                |
| `balance_raw`    | `UINT256`   | Raw balance                              |
| `balance`        | `DOUBLE`    | Decimals-adjusted balance                |
| `balance_usd`    | `DOUBLE`    | USD value                                |
| `currency`       | `VARCHAR`   | ISO 4217 currency code                   |
| `last_updated`   | `TIMESTAMP` | Last balance update time                 |

<TableSample tableSchema="stablecoins_multichain" tableName="balances" />

## Sample Queries

```sql theme={null}
SELECT
    b.blockchain
    , SUM(b.balance_usd) AS total_supply_usd
FROM stablecoins_multichain.balances AS b
WHERE b.day = CURRENT_DATE
    AND b.balance > 0
GROUP BY b.blockchain
ORDER BY total_supply_usd DESC
```

## Notes

* This is currently the stablecoin multichain aggregate table.
* For chain-specific analysis, use `stablecoins_evm.balances`, `stablecoins_solana.balances`, and `stablecoins_tron.balances`.

<StablecoinBalancesSupplyNote includeCoverageGap={true} filterHint={<>If you want a circulating-supply-style view, filter out bridge-linked addresses with the enriched balance tables.</>} />