Table Details
| Property | Value |
|---|---|
| Table Name | hyperliquid.assets.transfers |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, unique_id |
| Clustering Key(s) | block_timestamp::date |
| Search Optimization | transaction_hash, sender_address, recipient_address |
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 Name | Data Type | Description |
|---|---|---|
| transfer_type | VARCHAR(10) | Either ‘deposit’ (Arbitrum → Hyperliquid) or ‘withdrawal’ (Hyperliquid → Arbitrum) |
| sender_address | VARCHAR(16777216) | Address that initiated the transfer on Arbitrum |
| recipient_address | VARCHAR(16777216) | Address receiving the transfer on Arbitrum |
| token_address | VARCHAR(16777216) | ERC-20 token address on Arbitrum (USDC) |
| raw_amount_str | VARCHAR(16777216) | Raw token amount before decimal normalization |
| amount_str | VARCHAR(16777216) | Decimal-normalized amount as string |
| amount | FLOAT | Decimal-normalized amount as float |
| usd_amount | FLOAT | USD value of the transfer using hourly prices |
| usd_exchange_rate | VARCHAR(16777216) | USD price of the token at time of transfer |
| transaction_from_address | VARCHAR(16777216) | Arbitrum transaction sender |
| transaction_to_address | VARCHAR(16777216) | Arbitrum transaction recipient |
| transaction_hash | VARCHAR(16777216) | Arbitrum transaction hash |
| transaction_index | NUMBER(38,0) | Transaction index within the Arbitrum block |
| log_index | NUMBER(38,0) | Log index within the Arbitrum transaction |
| block_number | NUMBER(38,0) | Arbitrum block number |
| block_timestamp | TIMESTAMP_NTZ(9) | Arbitrum block timestamp |
| block_hash | VARCHAR(16777216) | Arbitrum block hash |
| unique_id | VARCHAR(16777216) | Deterministic unique identifier |
| bridge_chain | VARCHAR(16777216) | The external chain involved in a bridge deposit or withdrawal (e.g. arbitrum). The direction determines whether this is the source or destination chain. |
| _created_at | TIMESTAMP_NTZ(9) | Row creation timestamp |
| _updated_at | TIMESTAMP_NTZ(9) | 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;