Skip to main content

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.

Deprecation Notice: This table will be deprecated. Please use fungible_token_transfers instead, which includes all transfer types with full bridge history from 2023-12.
The hyperliquid.assets.transfers table contains bridge deposits and withdrawals between Arbitrum and Hyperliquid. This table only covers USDC bridging through the Arbitrum bridge contract.

​
Table Columns

ColumnDescription
transfer_typeEither ‘deposit’ (Arbitrum → Hyperliquid) or ‘withdrawal’ (Hyperliquid → Arbitrum)
sender_addressAddress that initiated the transfer on Arbitrum
recipient_addressAddress receiving the transfer on Arbitrum
token_addressERC-20 token address on Arbitrum (USDC)
raw_amount_strRaw token amount before decimal normalization
amount_strDecimal-normalized amount as string
amountDecimal-normalized amount as float
usd_amountUSD value of the transfer using hourly prices
usd_exchange_rateUSD price of the token at time of transfer
transaction_from_addressArbitrum transaction sender
transaction_to_addressArbitrum transaction recipient
transaction_hashArbitrum transaction hash
transaction_indexTransaction index within the Arbitrum block
log_indexLog index within the Arbitrum transaction
block_numberArbitrum block number
block_timestampArbitrum block timestamp
block_hashArbitrum block hash
unique_idDeterministic unique identifier
_created_atRow creation timestamp
_updated_atRow last update timestamp

​
Sample Query

SELECT 
  transfer_type,
  sender_address,
  recipient_address,
  amount,
  usd_amount,
  block_timestamp
FROM hyperliquid.assets.transfers
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '7 days'
ORDER BY block_timestamp DESC
LIMIT 100;