> ## 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.

# Fungible Token Transfers

> Comprehensive fungible token transfers on Hyperliquid

The `hyperliquid.assets.fungible_token_transfers` table provides comprehensive fungible token transfers on Hyperliquid combining:

* **Arbitrum bridge data** (on-chain, full history from 2023-12) for deposit/withdraw
* **misc\_events** (from 2025-05) for all other transfer types
* **misc\_events deposit/withdraw** as fallback for bridge incremental lag

This table covers 17 on-chain event types plus synthetic spot\_trade events.

<Info>
  This is the recommended table for all Hyperliquid transfer data. It supersedes `hyperliquid.assets.transfers` which only contained bridge deposits/withdrawals.
</Info>

## Table Columns

| Column             | Description                                                                                                                                                                                        |
| ------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| from\_address      | Sender address. For bridge deposits, this is the Arbitrum sender. For bridge withdrawals, this is the Hyperliquid user. Null for rewards claims, spot genesis, and unstaking events                |
| to\_address        | Recipient address. For bridge deposits, this is the Hyperliquid recipient. For bridge withdrawals, this is the Arbitrum destination. Null for staking deposits, gas fees, and lending supply/repay |
| token\_address     | Token address. Arbitrum ERC-20 address (0x...) for bridge events, integer token index for misc\_events                                                                                             |
| token\_name        | Full name of the token                                                                                                                                                                             |
| token\_symbol      | Symbol of the token being transferred (e.g., USDC, HYPE, PURR)                                                                                                                                     |
| amount\_str        | Transfer amount as a string to preserve precision                                                                                                                                                  |
| amount             | Transfer amount as a float                                                                                                                                                                         |
| usd\_amount        | USD value. Bridge events use hourly price hydration. Non-bridge events use hardcoded \$1 for non-USDC tokens                                                                                       |
| hash               | Transaction hash. Shared between Arbitrum and Hyperliquid L1 for bridge events                                                                                                                     |
| timestamp          | Event timestamp. Arbitrum block\_timestamp for bridge events, Hyperliquid L1 time for misc\_events                                                                                                 |
| transfer\_index    | Index within the same (timestamp, hash) to disambiguate multiple transfers                                                                                                                         |
| event\_type        | The event type (see below)                                                                                                                                                                         |
| transfer\_category | High-level category grouping the event\_type                                                                                                                                                       |
| unique\_id         | Deterministic unique ID. Format differs between bridge rows and misc\_events rows                                                                                                                  |
| trade\_details     | JSON variant with trade pair info for spot\_trade events. Null for all other event types                                                                                                           |
| activity\_type     | Classified activity label                                                                                                                                                                          |
| extra\_fields      | JSON variant with bridge-specific context for deposit/withdraw events sourced from Arbitrum. Null for non-bridge events                                                                            |
| block\_height      | Hyperliquid L1 block height corresponding to the event timestamp                                                                                                                                   |
| block\_hash        | Hyperliquid L1 block hash corresponding to the event timestamp                                                                                                                                     |
| \_created\_at      | Timestamp when this row was first created                                                                                                                                                          |
| \_updated\_at      | Timestamp when this row was last updated                                                                                                                                                           |

## Event Types

The `event_type` column contains one of the following values:

| Event Type            | Description                             |
| --------------------- | --------------------------------------- |
| deposit               | Bridge deposit from Arbitrum            |
| withdraw              | Bridge withdrawal to Arbitrum           |
| spotTransfer          | Spot token transfer                     |
| send                  | Token send                              |
| accountClassTransfer  | Account class transfer                  |
| subAccountTransfer    | Sub-account transfer                    |
| internalTransfer      | Internal transfer                       |
| vaultDeposit          | Vault deposit                           |
| vaultWithdraw         | Vault withdrawal                        |
| vaultCreate           | Vault creation                          |
| vaultDistribution     | Vault distribution                      |
| vaultLeaderCommission | Vault leader commission                 |
| rewardsClaim          | Rewards claim                           |
| spotGenesis           | Spot genesis event                      |
| cStakingTransfer      | HYPE staking transfer                   |
| borrowLend            | Native lending operation                |
| accountActivationGas  | One-time gas fee for account activation |
| spot\_trade           | Synthetic event for spot trades         |

## Transfer Categories

The `transfer_category` column groups event types into high-level categories:

| Category  | Event Types                                                                        |
| --------- | ---------------------------------------------------------------------------------- |
| bridge    | deposit, withdraw                                                                  |
| transfer  | internalTransfer, spotTransfer, send                                               |
| internal  | accountClassTransfer, subAccountTransfer                                           |
| vault     | vaultDeposit, vaultWithdraw, vaultCreate, vaultDistribution, vaultLeaderCommission |
| lifecycle | rewardsClaim, spotGenesis                                                          |
| staking   | cStakingTransfer                                                                   |
| lending   | borrowLend                                                                         |
| gas       | accountActivationGas                                                               |
| trade     | spot\_trade                                                                        |

## Activity Types

The `activity_type` column provides classified activity labels:

* bridge\_deposit
* bridge\_withdrawal
* mint
* burn
* swap
* stake
* unstake
* lend
* gas\_fee
* transfer

## Extra Fields (Bridge Events)

For deposit/withdraw events sourced from Arbitrum, the `extra_fields` JSON contains:

* source\_chain
* destination\_chain
* transaction\_hash
* block\_number
* block\_hash
* log\_index
* transaction\_index
* transaction\_from\_address
* transaction\_to\_address
* usd\_exchange\_rate

## Sample Query

```sql theme={null}
SELECT 
  timestamp,
  from_address,
  to_address,
  token_symbol,
  amount,
  event_type,
  activity_type
FROM hyperliquid.assets.fungible_token_transfers
WHERE timestamp >= CURRENT_DATE - INTERVAL '7 days'
ORDER BY timestamp DESC
LIMIT 100;
```