Transfers

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.

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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Token & Classification

Transfer Details

Block & Lineage

Sample Query

​Table Columns

​Token & Classification

​Transfer Details

​Block & Lineage

​Sample Query

Table Columns

Token & Classification

Transfer Details

Block & Lineage

Sample Query