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

# Transfers

Native and fungible token transfers on every chain Allium indexes, in one schema.

It covers:

* native tokens and ERC-20 equivalents (BEP-20, TRC-20) on EVM chains and Tron
* SOL and SPL token transfers on Solana
* coin and fungible asset transfers on Aptos
* fungible asset transfers on Sui

Some columns only apply to some chains: `token_acc_from` and `token_acc_to` are Solana token accounts and are null elsewhere. For one chain, its own table (e.g. `ethereum.assets.fungible_token_transfers`) is faster.

### Table Details

| Property | Value |
| - | - |
| Table Name | `crosschain.assets.transfers` |
| Table Status | Production-Ready |
| Unique Key | `transaction_hash`, `unique_id` |

### Chain Coverage

| Table | Chains |
| - | - |
| `crosschain.assets.transfers` | <details><summary>53 chains</summary>[Solana](https://docs.allium.so/historical-data/supported-blockchains/solana/solana/assets/transfers.md), [Aptos](https://docs.allium.so/historical-data/supported-blockchains/move-ecosystem/aptos/assets/fungible-transfers.md), [Sui](https://docs.allium.so/historical-data/supported-blockchains/move-ecosystem/sui/assets/fungible-transfers.md), [Abstract](https://docs.allium.so/historical-data/supported-blockchains/evm/abstract/assets/fungible-token-transfers.md), [ApeChain](https://docs.allium.so/historical-data/supported-blockchains/evm/apechain/assets/fungible-token-transfers.md), [Arbitrum](https://docs.allium.so/historical-data/supported-blockchains/evm/arbitrum/assets/fungible-token-transfers.md), [Arbitrum Nova](https://docs.allium.so/historical-data/supported-blockchains/evm/arbitrum_nova/assets/fungible-token-transfers.md), [Arc](https://docs.allium.so/historical-data/supported-blockchains/evm/arc/assets/fungible-token-transfers.md), [Avalanche](https://docs.allium.so/historical-data/supported-blockchains/evm/avalanche/assets/fungible-token-transfers.md), [B3 ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/b3/assets/fungible-token-transfers.md), [Base](https://docs.allium.so/historical-data/supported-blockchains/evm/base/assets/fungible-token-transfers.md), [Berachain](https://docs.allium.so/historical-data/supported-blockchains/evm/berachain/assets/fungible-token-transfers.md), [Blast ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/blast/assets/fungible-token-transfers.md), [BNB Smart Chain](https://docs.allium.so/historical-data/supported-blockchains/evm/bsc/assets/fungible-token-transfers.md), [Celo](https://docs.allium.so/historical-data/supported-blockchains/evm/celo/assets/fungible-token-transfers.md), [Codex](https://docs.allium.so/historical-data/supported-blockchains/evm/codex/assets/fungible-token-transfers.md), [Core](https://docs.allium.so/historical-data/supported-blockchains/evm/core/assets/fungible-token-transfers.md), [Ethereum](https://docs.allium.so/historical-data/supported-blockchains/evm/ethereum/assets/fungible-token-transfers.md), [Fantom ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/fantom/assets/fungible-token-transfers.md), [Fraxtal](https://docs.allium.so/historical-data/supported-blockchains/evm/fraxtal/assets/fungible-token-transfers.md), [Gnosis](https://docs.allium.so/historical-data/supported-blockchains/evm/gnosis/assets/fungible-token-transfers.md), [HyperEVM](https://docs.allium.so/historical-data/supported-blockchains/evm/hyperevm/assets/fungible-token-transfers.md), [Immutable zkEVM](https://docs.allium.so/historical-data/supported-blockchains/evm/imx_zkevm.md), [Ink](https://docs.allium.so/historical-data/supported-blockchains/evm/ink/assets/fungible-token-transfers.md), [Katana](https://docs.allium.so/historical-data/supported-blockchains/evm/katana/assets/fungible-token-transfers.md), [Kinto ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/kinto.md), [Linea](https://docs.allium.so/historical-data/supported-blockchains/evm/linea/assets/fungible-token-transfers.md), [Mantle](https://docs.allium.so/historical-data/supported-blockchains/evm/mantle/assets/fungible-token-transfers.md), [MegaETH 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/megaeth/assets/fungible-token-transfers.md), [Mode](https://docs.allium.so/historical-data/supported-blockchains/evm/mode/assets/fungible-token-transfers.md), [Monad](https://docs.allium.so/historical-data/supported-blockchains/evm/monad/assets/fungible-token-transfers.md), [Oasys](https://docs.allium.so/historical-data/supported-blockchains/evm/oasys.md), [Optimism](https://docs.allium.so/historical-data/supported-blockchains/evm/optimism/assets/fungible-token-transfers.md), [Plasma](https://docs.allium.so/historical-data/supported-blockchains/evm/plasma/assets/fungible-token-transfers.md), [Plume](https://docs.allium.so/historical-data/supported-blockchains/evm/plume/assets/fungible-token-transfers.md), [Polygon](https://docs.allium.so/historical-data/supported-blockchains/evm/polygon/assets/fungible-token-transfers.md), [Polygon zkEVM ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/polygon_zkevm/assets/fungible-token-transfers.md), [Robinhood](https://docs.allium.so/historical-data/supported-blockchains/evm/robinhood/assets/fungible-token-transfers.md), [Ronin](https://docs.allium.so/historical-data/supported-blockchains/evm/ronin/assets/fungible-token-transfers.md), [Rootstock](https://docs.allium.so/historical-data/supported-blockchains/evm/rootstock/assets/fungible-token-transfers.md), [Scroll](https://docs.allium.so/historical-data/supported-blockchains/evm/scroll/assets/fungible-token-transfers.md), [Sei](https://docs.allium.so/historical-data/supported-blockchains/evm/sei/assets/fungible-token-transfers.md), [Soneium](https://docs.allium.so/historical-data/supported-blockchains/evm/soneium/assets/fungible-token-transfers.md), [Sonic](https://docs.allium.so/historical-data/supported-blockchains/evm/sonic/assets/fungible-token-transfers.md), [Stable](https://docs.allium.so/historical-data/supported-blockchains/evm/stable/assets/fungible-token-transfers.md), [Tempo](https://docs.allium.so/historical-data/supported-blockchains/evm/tempo/assets/fungible-token-transfers.md), [TRON](https://docs.allium.so/historical-data/supported-blockchains/evm/tron/assets/fungible-token-transfers.md), [Unichain](https://docs.allium.so/historical-data/supported-blockchains/evm/unichain/assets/fungible-token-transfers.md), [Vana](https://docs.allium.so/historical-data/supported-blockchains/evm/vana/assets/fungible-token-transfers.md), [World Chain](https://docs.allium.so/historical-data/supported-blockchains/evm/worldchain/assets/fungible-token-transfers.md), [X Layer](https://docs.allium.so/historical-data/supported-blockchains/evm/x_layer/assets/fungible-token-transfers.md), [ZKsync](https://docs.allium.so/historical-data/supported-blockchains/evm/zksync/assets/fungible-token-transfers.md), [Zora](https://docs.allium.so/historical-data/supported-blockchains/evm/zora/assets/fungible-token-transfers.md)</details> |
| `<chain>.assets.fungible_token_transfers` | <details><summary>77 chains</summary>[Babylon](https://docs.allium.so/historical-data/supported-blockchains/cosmos-ecosystem/babylon/assets/fungible-token-transfers.md), [Cosmos](https://docs.allium.so/historical-data/supported-blockchains/cosmos-ecosystem/cosmos/assets/fungible-token-transfers.md), [dYdX](https://docs.allium.so/historical-data/supported-blockchains/cosmos-ecosystem/dydx/assets/fungible-token-transfers.md), [Injective](https://docs.allium.so/historical-data/supported-blockchains/cosmos-ecosystem/injective/assets/fungible-token-transfers.md), [Osmosis](https://docs.allium.so/historical-data/supported-blockchains/cosmos-ecosystem/osmosis/assets/fungible-token-transfers.md), [Provenance](https://docs.allium.so/historical-data/supported-blockchains/cosmos-ecosystem/provenance/assets/fungible-token-transfers.md), [Abstract](https://docs.allium.so/historical-data/supported-blockchains/evm/abstract/assets/fungible-token-transfers.md), [ApeChain](https://docs.allium.so/historical-data/supported-blockchains/evm/apechain/assets/fungible-token-transfers.md), [Arbitrum](https://docs.allium.so/historical-data/supported-blockchains/evm/arbitrum/assets/fungible-token-transfers.md), [Arbitrum Nova](https://docs.allium.so/historical-data/supported-blockchains/evm/arbitrum_nova/assets/fungible-token-transfers.md), [Arbitrum Sepolia](https://docs.allium.so/historical-data/supported-blockchains/evm/arbitrum_sepolia/assets/fungible-token-transfers.md), [Arc](https://docs.allium.so/historical-data/supported-blockchains/evm/arc/assets/fungible-token-transfers.md), [Avalanche](https://docs.allium.so/historical-data/supported-blockchains/evm/avalanche/assets/fungible-token-transfers.md), [Avalanche Fuji 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/avalanche_fuji/assets/fungible-token-transfers.md), [B3 ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/b3/assets/fungible-token-transfers.md), [Base](https://docs.allium.so/historical-data/supported-blockchains/evm/base/assets/fungible-token-transfers.md), [Base Sepolia 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/base_sepolia/assets/fungible-token-transfers.md), [Berachain](https://docs.allium.so/historical-data/supported-blockchains/evm/berachain/assets/fungible-token-transfers.md), [Blast ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/blast/assets/fungible-token-transfers.md), [BNB Smart Chain](https://docs.allium.so/historical-data/supported-blockchains/evm/bsc/assets/fungible-token-transfers.md), [BNB Smart Chain (BSC) Testnet 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/bsc_testnet/assets/fungible-token-transfers.md), [BOB](https://docs.allium.so/historical-data/supported-blockchains/evm/bob/assets/fungible-token-transfers.md), [Botanix ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/botanix/assets/fungible-token-transfers.md), [Celo](https://docs.allium.so/historical-data/supported-blockchains/evm/celo/assets/fungible-token-transfers.md), [Codex](https://docs.allium.so/historical-data/supported-blockchains/evm/codex/assets/fungible-token-transfers.md), [Core](https://docs.allium.so/historical-data/supported-blockchains/evm/core/assets/fungible-token-transfers.md), [Elysium](https://docs.allium.so/historical-data/supported-blockchains/evm/elysium/assets/fungible-token-transfers.md), [Ethereum](https://docs.allium.so/historical-data/supported-blockchains/evm/ethereum/assets/fungible-token-transfers.md), [Ethereum Sepolia](https://docs.allium.so/historical-data/supported-blockchains/evm/ethereum_sepolia/assets/fungible-token-transfers.md), [Fantom ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/fantom/assets/fungible-token-transfers.md), [Filecoin EVM 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/filecoin_evm/assets/fungible-token-transfers.md), [Flynet 🌱 ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/flynet/assets/fungible-token-transfers.md), [Fraxtal](https://docs.allium.so/historical-data/supported-blockchains/evm/fraxtal/assets/fungible-token-transfers.md), [Gnosis](https://docs.allium.so/historical-data/supported-blockchains/evm/gnosis/assets/fungible-token-transfers.md), [HyperEVM](https://docs.allium.so/historical-data/supported-blockchains/evm/hyperevm/assets/fungible-token-transfers.md), [Ink](https://docs.allium.so/historical-data/supported-blockchains/evm/ink/assets/fungible-token-transfers.md), [Katana](https://docs.allium.so/historical-data/supported-blockchains/evm/katana/assets/fungible-token-transfers.md), [Linea](https://docs.allium.so/historical-data/supported-blockchains/evm/linea/assets/fungible-token-transfers.md), [Mantle](https://docs.allium.so/historical-data/supported-blockchains/evm/mantle/assets/fungible-token-transfers.md), [MegaETH 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/megaeth/assets/fungible-token-transfers.md), [Mode](https://docs.allium.so/historical-data/supported-blockchains/evm/mode/assets/fungible-token-transfers.md), [Monad](https://docs.allium.so/historical-data/supported-blockchains/evm/monad/assets/fungible-token-transfers.md), [Monad Testnet](https://docs.allium.so/historical-data/supported-blockchains/evm/monad_testnet/assets/fungible-token-transfers.md), [Optimism](https://docs.allium.so/historical-data/supported-blockchains/evm/optimism/assets/fungible-token-transfers.md), [Optimism Sepolia 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/optimism_sepolia/assets/fungible-token-transfers.md), [Plasma](https://docs.allium.so/historical-data/supported-blockchains/evm/plasma/assets/fungible-token-transfers.md), [Plasma Testnet 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/plasma_testnet/assets/fungible-token-transfers.md), [Plume](https://docs.allium.so/historical-data/supported-blockchains/evm/plume/assets/fungible-token-transfers.md), [Polygon](https://docs.allium.so/historical-data/supported-blockchains/evm/polygon/assets/fungible-token-transfers.md), [Polygon Amoy 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/polygon_amoy/assets/fungible-token-transfers.md), [Polygon zkEVM ◽](https://docs.allium.so/historical-data/supported-blockchains/evm/polygon_zkevm/assets/fungible-token-transfers.md), [Robinhood](https://docs.allium.so/historical-data/supported-blockchains/evm/robinhood/assets/fungible-token-transfers.md), [Robinhood Testnet](https://docs.allium.so/historical-data/supported-blockchains/evm/robinhood_testnet/assets/fungible-token-transfers.md), [Ronin](https://docs.allium.so/historical-data/supported-blockchains/evm/ronin/assets/fungible-token-transfers.md), [Rootstock](https://docs.allium.so/historical-data/supported-blockchains/evm/rootstock/assets/fungible-token-transfers.md), [Scroll](https://docs.allium.so/historical-data/supported-blockchains/evm/scroll/assets/fungible-token-transfers.md), [Sei](https://docs.allium.so/historical-data/supported-blockchains/evm/sei/assets/fungible-token-transfers.md), [Sei Testnet 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/sei_testnet/assets/fungible-token-transfers.md), [Soneium](https://docs.allium.so/historical-data/supported-blockchains/evm/soneium/assets/fungible-token-transfers.md), [Sonic](https://docs.allium.so/historical-data/supported-blockchains/evm/sonic/assets/fungible-token-transfers.md), [Stable](https://docs.allium.so/historical-data/supported-blockchains/evm/stable/assets/fungible-token-transfers.md), [Tempo](https://docs.allium.so/historical-data/supported-blockchains/evm/tempo/assets/fungible-token-transfers.md), [Tempo Testnet](https://docs.allium.so/historical-data/supported-blockchains/evm/tempo_testnet/assets/fungible-token-transfers.md), [TRON](https://docs.allium.so/historical-data/supported-blockchains/evm/tron/assets/fungible-token-transfers.md), [TRON Nile Testnet 🌱](https://docs.allium.so/historical-data/supported-blockchains/evm/tron_nile/assets/fungible-token-transfers.md), [Unichain](https://docs.allium.so/historical-data/supported-blockchains/evm/unichain/assets/fungible-token-transfers.md), [Vana](https://docs.allium.so/historical-data/supported-blockchains/evm/vana/assets/fungible-token-transfers.md), [World Chain](https://docs.allium.so/historical-data/supported-blockchains/evm/worldchain/assets/fungible-token-transfers.md), [X Layer](https://docs.allium.so/historical-data/supported-blockchains/evm/x_layer/assets/fungible-token-transfers.md), [XDC Network](https://docs.allium.so/historical-data/supported-blockchains/evm/xdc_network/assets/fungible-token-transfers.md), [ZKsync](https://docs.allium.so/historical-data/supported-blockchains/evm/zksync/assets/fungible-token-transfers.md), [Zora](https://docs.allium.so/historical-data/supported-blockchains/evm/zora/assets/fungible-token-transfers.md), [Hyperliquid](https://docs.allium.so/historical-data/supported-blockchains/hyperliquid/assets/fungible-token-transfers.md), [Casper Network](https://docs.allium.so/historical-data/supported-blockchains/other-ecosystems/casper/assets/fungible-token-transfers.md), [Filecoin 🌱](https://docs.allium.so/historical-data/supported-blockchains/other-ecosystems/filecoin/assets/fungible-token-transfers.md), [NEAR](https://docs.allium.so/historical-data/supported-blockchains/other-ecosystems/near/assets/fungible-token-transfers.md), [Stellar](https://docs.allium.so/historical-data/supported-blockchains/other-ecosystems/stellar/assets/fungible-token-transfers.md)</details> |
| `<chain>.assets.transfers` | [Solana](https://docs.allium.so/historical-data/supported-blockchains/solana/solana/assets/transfers.md), [Osmosis](https://docs.allium.so/historical-data/supported-blockchains/cosmos-ecosystem/osmosis/assets/transfers.md), [Hyperliquid](https://docs.allium.so/historical-data/supported-blockchains/hyperliquid/assets/transfers.md), [Kadena ◽](https://docs.allium.so/historical-data/supported-blockchains/other-ecosystems/kadena/assets/transfers.md) |
| `<chain>.assets.fungible_transfers` | [Aptos](https://docs.allium.so/historical-data/supported-blockchains/move-ecosystem/aptos/assets/fungible-transfers.md), [Sui](https://docs.allium.so/historical-data/supported-blockchains/move-ecosystem/sui/assets/fungible-transfers.md) |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| ecosystem | VARCHAR(6) | Blockchain ecosystem. |
| chain | VARCHAR(13) | Slug identifying the blockchain this record belongs to (e.g. `ethereum`, `base`, `avalanche`, `solana`). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. |
| token\_type | VARCHAR(16777216) | Type or standard of the token, as the chain names it. For example `erc20`, `erc721`, `erc1155` or `native` on EVM chains, `TRC20` or `TRX` on Tron, `spl-token`, `system` or `sol` on Solana, and `coin` or `fungible_asset` on Aptos and Sui. The values depend on the table. |
| from\_address | VARCHAR(16777216) | Address that initiated or sent from in this event. For token transfers, the account whose balance decreased. For transactions, the transaction sender (msg.sender). |
| to\_address | VARCHAR(16777216) | Address that received in this event. For token transfers, the account whose balance increased. For transactions, the destination address (may be a smart contract). |
| token\_acc\_from | VARCHAR(16777216) | SPL token account address of the sender. Each SPL token balance is held in a token account (derived from owner + mint), not the wallet address directly. Null for SOL transfers, which use no token account, and in crosschain tables for chains other than Solana. |
| token\_acc\_to | VARCHAR(16777216) | SPL token account address of the recipient. Each SPL token balance is held in a token account (derived from owner + mint), not the wallet address directly. Null for SOL transfers, which use no token account, and in crosschain tables for chains other than Solana. |
| token\_address | VARCHAR(16777216) | Contract address of the token. For EVM chains, native currency (e.g. ETH, MATIC) is represented as the zero address (0x0000000000000000000000000000000000000000). For Solana, this is the mint address. |
| token\_name | VARCHAR(16777216) | Full name of the token (e.g. "USD Coin", "Wrapped Ether"). |
| token\_symbol | VARCHAR(16777216) | Ticker symbol of the token (e.g. "USDC", "WETH"). |
| raw\_amount\_str | VARCHAR(16777216) | Token amount in the smallest unit (not decimal-adjusted), as a string to keep full precision. |
| raw\_amount | FLOAT | Token amount in the smallest indivisible unit (not decimal-adjusted). |
| amount\_str | VARCHAR(16777216) | Normalized token amount stored as a string to preserve full precision. Equivalent to `amount` but avoids floating-point truncation for very large or very small values. |
| amount | FLOAT | Token amount normalized by the token's decimal precision (amount\_raw / 10^decimals). This is the human-readable value (e.g. 1.5 USDC rather than 1500000). |
| usd\_amount | FLOAT | USD value of the token amount at the time of the event, computed using the hourly USD exchange rate. |
| usd\_exchange\_rate | FLOAT | USD price per unit of the token at the row's timestamp, used to compute the row's USD values. Sourced from Allium's hourly price feed. |
| transaction\_from\_address | VARCHAR(16777216) | Address of the externally-owned account (EOA) that signed and submitted the transaction. This is the wallet that paid gas, which may differ from the `from_address` of an individual token transfer if a contract is routing tokens on behalf of a user. |
| transaction\_to\_address | VARCHAR(42) | Address the transaction was sent to (the top-level `to` field of the transaction). May be a router, aggregator, or bridge contract rather than the direct recipient of assets. Null on chains where a transaction has no single `to` address, such as Solana. |
| transaction\_hash | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. Can be null for rows that no transaction creates, such as beacon chain withdrawals or block rewards. |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block in which this event was confirmed. |
| block\_number | NUMBER(38,0) | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block. |
| block\_hash | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| unique\_id | VARCHAR(16777216) | Allium's deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
