## Documentation Index

Fetch the complete documentation index at: [/llms.txt](https://docs.dune.com/llms.txt)

Use this file to discover all available pages before exploring further.

The `stablecoins_evm.transfers` table contains curated stablecoin transfer records across 37 supported EVM chains. One row represents one ERC20 stablecoin transfer event at log granularity.

This table is useful for:

- stablecoin flow analysis by chain, token, and address
- transfer volume analysis in native units and USD
- cross-chain stablecoin transfer comparisons

## 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 |
| `tx_hash` | `VARBINARY` | Transaction hash |
| `evt_index` | `BIGINT` | Transfer event index |
| `trace_address` | `VARCHAR` | Trace address (nullable) |
| `token_standard` | `VARCHAR` | Token standard (`erc20`) |
| `token_address` | `VARBINARY` | Token contract 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 used for valuation |
| `amount_usd` | `DOUBLE` | USD amount |
| `from` | `VARBINARY` | Sender address |
| `to` | `VARBINARY` | Recipient address |
| `unique_key` | `VARCHAR` | Unique transfer identifier |

## Sample Queries

```
SELECT
    t.block_date
    , t.blockchain
    , t.token_symbol
    , SUM(t.amount_usd) AS volume_usd
    , COUNT(*) AS transfers
FROM stablecoins_evm.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

- For partition pruning, filter by `blockchain` and `block_month`.