> ## 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 (Solana)

> Stablecoin transfer events on Solana

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_solana.transfers` table contains curated stablecoin transfer records on Solana.

One row represents one transfer instruction call at instruction granularity. Coverage includes both SPL and SPL2022 stablecoin transfers.

<PrepackagedEnrichedCtaCard href="/data-catalog/curated/stablecoins/activity-enriched/stablecoins-solana-activity-enriched" />

## Table schema

| Column                    | Type        | Description                                        |
| ------------------------- | ----------- | -------------------------------------------------- |
| `blockchain`              | `VARCHAR`   | Chain name (`solana`)                              |
| `block_month`             | `DATE`      | First day of month (partition column)              |
| `block_date`              | `DATE`      | Transaction date                                   |
| `block_time`              | `TIMESTAMP` | Transaction timestamp                              |
| `block_slot`              | `BIGINT`    | Solana slot number                                 |
| `tx_id`                   | `VARCHAR`   | Transaction signature                              |
| `tx_index`                | `BIGINT`    | Transaction index in slot                          |
| `outer_instruction_index` | `BIGINT`    | Outer instruction index                            |
| `inner_instruction_index` | `BIGINT`    | Inner instruction index                            |
| `token_version`           | `VARCHAR`   | Token standard version (`spl_token` / `token2022`) |
| `token_mint_address`      | `VARCHAR`   | Token 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 used for valuation                       |
| `amount_usd`              | `DOUBLE`    | USD amount                                         |
| `from_owner`              | `VARCHAR`   | Sender wallet                                      |
| `to_owner`                | `VARCHAR`   | Receiver wallet                                    |
| `from_token_account`      | `VARCHAR`   | Source token account                               |
| `to_token_account`        | `VARCHAR`   | Destination token account                          |
| `tx_signer`               | `VARCHAR`   | Transaction signer                                 |
| `outer_executing_account` | `VARCHAR`   | Program executing outer instruction                |
| `action`                  | `VARCHAR`   | Transfer action label                              |
| `unique_key`              | `VARCHAR`   | Unique transfer identifier                         |

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

## Sample Queries

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

## Notes

* For partition pruning, filter by `block_month`.