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.
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
| Column | Description |
|---|---|
| transfer_type | Either ‘deposit’ (Arbitrum → Hyperliquid) or ‘withdrawal’ (Hyperliquid → Arbitrum) |
| sender_address | Address that initiated the transfer on Arbitrum |
| recipient_address | Address receiving the transfer on Arbitrum |
| token_address | ERC-20 token address on Arbitrum (USDC) |
| raw_amount_str | Raw token amount before decimal normalization |
| amount_str | Decimal-normalized amount as string |
| amount | Decimal-normalized amount as float |
| usd_amount | USD value of the transfer using hourly prices |
| usd_exchange_rate | USD price of the token at time of transfer |
| transaction_from_address | Arbitrum transaction sender |
| transaction_to_address | Arbitrum transaction recipient |
| transaction_hash | Arbitrum transaction hash |
| transaction_index | Transaction index within the Arbitrum block |
| log_index | Log index within the Arbitrum transaction |
| block_number | Arbitrum block number |
| block_timestamp | Arbitrum block timestamp |
| block_hash | Arbitrum block hash |
| unique_id | Deterministic unique identifier |
| _created_at | Row creation timestamp |
| _updated_at | Row 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;