> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Transfers

> Hyperliquid stablecoin transfer events, including mints, burns, and wallet-to-wallet transfers.

The `hyperliquid.stablecoins.transfers` table contains stablecoin transfer events on Hyperliquid, including mints, burns, and wallet-to-wallet transfers for all tracked stablecoin tokens, with USD-denominated amounts and token metadata.

<Note>This table is clustered by `timestamp::date` and `token_address`. Always include a `timestamp` filter in your `WHERE` clause to avoid scanning the full table.</Note>

## Table Columns

### Token & Classification

| Column Name      | Description                                                      |
| ---------------- | ---------------------------------------------------------------- |
| product\_id      | Stablecoin product identifier (e.g. 'usdc\_hyperliquid').        |
| is\_native       | Whether the token is the chain's native asset.                   |
| stablecoin\_type | The stablecoin type classification.                              |
| currency         | The fiat currency the stablecoin is denominated in (e.g. 'usd'). |
| token\_address   | Hyperliquid numeric token index.                                 |
| token\_name      | Full stablecoin name.                                            |
| token\_symbol    | Stablecoin symbol.                                               |

### Transfer Details

| Column Name         | Description                                                            |
| ------------------- | ---------------------------------------------------------------------- |
| from\_address       | The sending address. Mint events originate from the zero/mint address. |
| to\_address         | The receiving address. Burn events are sent to the burn address.       |
| amount\_str         | Transfer amount as VARCHAR (full precision).                           |
| amount              | Transfer amount in decimal units.                                      |
| usd\_amount         | Transfer value in USD.                                                 |
| usd\_exchange\_rate | The USD exchange rate applied to derive `usd_amount`.                  |
| event\_type         | The transfer event type (e.g. transfer, mint, burn).                   |
| activity\_type      | Higher-level activity classification for the transfer.                 |
| trade\_details      | JSON variant with additional transfer context, when available.         |

### Block & Lineage

| Column Name             | Description                                   |
| ----------------------- | --------------------------------------------- |
| hash                    | Transaction hash.                             |
| transfer\_index         | Index of the transfer within its transaction. |
| block\_height           | The height of the block.                      |
| block\_hash             | The block hash.                               |
| timestamp               | The UTC timestamp of the transfer.            |
| unique\_id              | Deterministic unique identifier per row.      |
| \_created\_at           | Row creation timestamp.                       |
| \_updated\_at           | Row last update timestamp.                    |
| \_metadata\_updated\_at | Token-metadata last update timestamp.         |

## Sample Query

```sql theme={null}
SELECT
  timestamp,
  token_symbol,
  event_type,
  from_address,
  to_address,
  usd_amount
FROM hyperliquid.stablecoins.transfers
WHERE timestamp >= CURRENT_DATE - 7
ORDER BY timestamp DESC
LIMIT 100
```