> ## 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 (EVM)

ERC-20 and native token transfer events across EVM chains, unified schema. One row per transfer event.

### Table Details

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

### Chain Coverage

| Table | Chains |
| - | - |
| `crosschain.assets.fungible_token_transfers_evm` | <details><summary>49 chains</summary>[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), [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> |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| 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(42) | 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(42) | 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\_address | VARCHAR(42) | 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(42) | 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(66) | 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. |
| transaction\_index | NUMBER(38,0) | Zero-based position of the transaction within its block. The first transaction in a block has index 0. |
| log\_index | NUMBER(38,0) | Zero-based position of this event log within its transaction. The first log emitted by a transaction has index 0. |
| call\_type | VARCHAR(16777216) | Sub-type for `call` traces. One of: `call` (standard call), `delegatecall` (preserves caller context), `staticcall` (read-only call). |
| transfer\_type | VARCHAR(16777216) | Category of this token movement. For native currency transfers: `value_transfer` (explicit send), `gas_payment_to_miner` (priority fee to block producer), or `gas_burn` (EIP-1559 base fee destroyed). For token transfers: always `value_transfer`. |
| 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(66) | 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. |
| \_tokens\_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the most recent update to the token metadata (name, symbol, decimals) associated with this row. Advances independently of balance or event data when token metadata is refreshed. |
| \_created\_at | TIMESTAMP\_NTZ(9) | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed. |
| \_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration). |
| \_changed\_since\_full\_refresh | BOOLEAN | Flag indicating whether this row was created or modified after the last full refresh of the model. Useful for identifying recently added or updated records in incremental processing. Same concept as `_change_since_full_refresh` — the column name varies by model generation. |
