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