> ## 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 Transfers (Multichain)

> Unified stablecoin transfer events across EVM, Solana, and Tron in a single cross-chain view.

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>
  </>;

The `stablecoins_multichain.transfers` table unions stablecoin transfer records from all supported ecosystems — EVM (37 chains), Solana, and Tron — into a single cross-chain view with normalized address and hash types (VARCHAR).

One row represents one stablecoin transfer event.

This table is useful for:

* Cross-ecosystem stablecoin flow analysis
* Aggregate transfer volume across all supported chains
* Comparing stablecoin movement patterns across EVM, Solana, and Tron

## Table Schema

| Column           | Type        | Description                                          |
| ---------------- | ----------- | ---------------------------------------------------- |
| `blockchain`     | `VARCHAR`   | Chain name                                           |
| `block_month`    | `DATE`      | First day of month (partition column)                |
| `block_date`     | `DATE`      | Transaction date                                     |
| `block_time`     | `TIMESTAMP` | Transaction timestamp                                |
| `block_number`   | `BIGINT`    | Block number (null for Solana)                       |
| `tx_hash`        | `VARCHAR`   | Transaction hash                                     |
| `evt_index`      | `BIGINT`    | Event index within the transaction (null for Solana) |
| `token_standard` | `VARCHAR`   | Token standard (e.g. `erc20`, `spl_token`)           |
| `token_address`  | `VARCHAR`   | Token contract/mint address                          |
| `token_symbol`   | `VARCHAR`   | Token symbol                                         |
| `currency`       | `VARCHAR`   | ISO 4217 currency code                               |
| `amount_raw`     | `UINT256`   | Raw transfer amount                                  |
| `amount`         | `DOUBLE`    | Decimals-adjusted amount                             |
| `price_usd`      | `DOUBLE`    | USD price per unit                                   |
| `amount_usd`     | `DOUBLE`    | USD value of transfer                                |
| `from`           | `VARCHAR`   | Sender address                                       |
| `to`             | `VARCHAR`   | Recipient address                                    |
| `unique_key`     | `VARCHAR`   | Unique transfer identifier                           |

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

## Sample Queries

```sql theme={null}
SELECT
    t.block_date
    , t.blockchain
    , t.token_symbol
    , SUM(t.amount_usd) AS volume_usd
    , COUNT(*) AS transfers
FROM stablecoins_multichain.transfers AS t
WHERE t.block_date >= CURRENT_DATE - INTERVAL '7' DAY
GROUP BY t.block_date, t.blockchain, t.token_symbol
ORDER BY t.block_date DESC, volume_usd DESC
```

## Notes

* Addresses and hashes are cast to VARCHAR for cross-ecosystem compatibility.
* For partition pruning, filter by `blockchain` and `block_month`.