Skip to main content
The hyperliquid.assets.stablecoin_transfers table contains stablecoin transfers on Hyperliquid derived from misc_events and spot trades. This table is filtered to stablecoins only (USDC, etc.) and includes activity type classification.
Data starts from 2025-05-16. For comprehensive token transfers including non-stablecoins, use fungible_token_transfers.

​
Table Columns

ColumnDescription
from_addressSender address. Null for deposits, rewards, and mints
to_addressRecipient address. Null for withdrawals and burns
token_addressStablecoin token index on Hyperliquid
token_nameFull name of the stablecoin
token_symbolStablecoin symbol (e.g., USDC)
amount_strTransfer amount as string
amountTransfer amount as float
usd_amountApproximate USD value
hashL1 transaction hash
timestampEvent timestamp on Hyperliquid L1
transfer_indexIndex to disambiguate multiple transfers in one transaction
event_typeRaw misc_events event type
unique_idDeterministic unique identifier
trade_detailsJSON with trade pair info for spot_trade events. Null otherwise
activity_typeClassified activity label (bridge_deposit, bridge_withdrawal, mint, burn, swap, transfer)
currencyStablecoin currency (e.g., USD)
base_assetBase asset of the stablecoin
is_bridgeWhether this stablecoin is a bridged asset
_metadata_updated_atWhen the stablecoin metadata was last updated
block_heightHyperliquid L1 block height
block_hashHyperliquid L1 block hash

​
Sample Query

SELECT 
  timestamp,
  from_address,
  to_address,
  token_symbol,
  amount,
  activity_type
FROM hyperliquid.assets.stablecoin_transfers
WHERE timestamp >= CURRENT_DATE - INTERVAL '7 days'
ORDER BY timestamp DESC
LIMIT 100;