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.
Table Details
| Property | Value |
|---|---|
| Table Name | hyperliquid.stablecoins.transfers |
| Table Status | Production-Ready |
| Unique Key | timestamp::date, unique_id |
| Clustering Key(s) | timestamp::date, token_address |
| Search Optimization | token_address, token_symbol |
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 | Data Type | Description |
|---|---|---|
| product_id | VARCHAR(16777216) | Allium stablecoin product identifier (e.g. usdc, usdt) |
| is_native | BOOLEAN | Whether the transfer was of a chain-native stablecoin issuance (vs. a bridged/wrapped representation) |
| stablecoin_type | VARCHAR(16777216) | Backing model of the stablecoin (e.g. fiat-backed, crypto-collateralized, algorithmic) |
| currency | VARCHAR(16777216) | The reference currency the stablecoin is pegged to (e.g. USD, EUR) |
| from_address | VARCHAR(16777216) | The sending address. Mint events originate from the zero/mint address. |
| to_address | VARCHAR(16777216) | The receiving address. Burn events are sent to the burn address. |
| token_address | VARCHAR(16777216) | Contract address of the stablecoin token |
| token_name | VARCHAR(16777216) | Name of the stablecoin |
| token_symbol | VARCHAR(16777216) | Symbol of the stablecoin |
| amount_str | VARCHAR(16777216) | Transfer amount as VARCHAR (full precision). |
| amount | FLOAT | Transfer amount in decimal units. |
| usd_amount | FLOAT | Transfer value in USD. |
| hash | VARCHAR(16777216) | Transaction hash. |
| timestamp | TIMESTAMP_NTZ(9) | The UTC timestamp of the transfer. |
| transfer_index | NUMBER(38,0) | Index of the transfer within its transaction. |
| event_type | VARCHAR(16777216) | The transfer event type (e.g. transfer, mint, burn). |
| unique_id | VARCHAR(16777216) | Deterministic unique identifier per row. |
| trade_details | VARIANT | JSON variant with additional transfer context, when available. |
| activity_type | VARCHAR(16777216) | Higher-level activity classification for the transfer. |
| _created_at | TIMESTAMP_NTZ(9) | Row creation timestamp. |
| _updated_at | TIMESTAMP_NTZ(9) | Row last update timestamp. |
| _metadata_updated_at | TIMESTAMP_NTZ(9) | Token-metadata last update timestamp. |
| block_height | NUMBER(38,0) | The height of the block. |
| block_hash | VARCHAR(16777216) | The block hash. |
| usd_exchange_rate | FLOAT | The USD exchange rate applied to derive usd_amount. |
Transfer Details
| Column Name | Description | |
|---|---|---|
| from_address | The sending address. Mint events originate from the zero/mint address. | Address that initiated or sent from in this event. For token transfers, the account whose balance decreased. For transactions, the transaction sender (msg.sender). |
| to_address | The receiving address. Burn events are sent to the burn address. | Address that received in this event. For token transfers, the account whose balance increased. For transactions, the destination address (may be a smart contract). |
| amount_str | Transfer amount as VARCHAR (full precision). | Normalized token amount stored as a string to preserve full precision. Equivalent to amount but avoids floating-point truncation for very large or very small values. |
| amount | Transfer amount in decimal units. | Token amount normalized by the token’s decimal precision (amount_raw / 10^decimals). This is the human-readable value (e.g. 1.5 USDC rather than 1500000). |
| usd_amount | Transfer value in USD. | USD value of the token amount at the time of the event, computed using the hourly USD exchange rate. |
| usd_exchange_rate | The USD exchange rate applied to derive usd_amount. | USD price per unit of the token at the time of the event, used to compute usd_amount. Sourced from Allium’s hourly price feed. |
| event_type | The transfer event type (e.g. transfer, mint, burn). | Type or category of the onchain event that produced this record. The specific values depend on the model (e.g. transfer_single / batch_transfer for ERC-1155, deposit / withdraw for bridges). |
| activity_type | Higher-level activity classification for the transfer. | Classified activity label (bridge_deposit, bridge_withdrawal, mint, burn, swap, transfer). |
| trade_details | JSON variant with additional transfer context, when available. | JSON variant with trade pair info for spot_trade events. Null for all other event types. |
Block & Lineage
| Column Name | Description | |
|---|---|---|
| hash | Transaction hash. | Hash of this record’s transaction. Alias for transaction_hash used in raw tables that preserve the original blockchain field name. |
| transfer_index | Index of the transfer within its transaction. | Index to disambiguate multiple transfers in one transaction. |
| block_height | The height of the block. | Number of confirmed blocks between this block and the genesis block (inclusive). Unlike block_slot, this only increments for slots that produced a block. |
| block_hash | The block hash. | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| timestamp | The UTC timestamp of the transfer. | Timestamp (UTC) of this record. Alias for block_timestamp used in tables where the column is named timestamp rather than block_timestamp. |
| unique_id | Deterministic unique identifier per row. | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| _created_at | Row creation timestamp. | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed. |
| _updated_at | Row last update timestamp. | Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration). |
| _metadata_updated_at | Token-metadata last update timestamp. | When the stablecoin metadata was last updated. |
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