Token Transfers
Fungible Token Transfers
Track movement of fungible (native and erc20)token transfers across all addresses.
The Fungible Token Transfers model combines transfers from ERC20 tokens and Native Token Transfers (ETH, MATIC, etc.) into a single view.
Table Columns
Unique Key: unique_id
| Column Name | Data Type | Description |
|---|---|---|
| token_type | VARCHAR | Type of the token (e.g., ‘erc20’, ‘native’) |
| address | VARCHAR | Address of the account that was credited or debited amount of token |
| counterparty_address | VARCHAR | The address of counter party of this credit or debit transfer |
| token_address | VARCHAR | Token address of the token |
| token_name | VARCHAR | Name of the token |
| token_symbol | VARCHAR | Token symbol |
| raw_amount_str | VARCHAR | Amount of tokens moved (unnormalized) in string |
| raw_amount | FLOAT | Amount of tokens moved (unnormalized) |
| amount_str | VARCHAR | Amount of tokens moved, normalized in string |
| amount | FLOAT | Amount of tokens moved, normalized by the decimal points defined in the token contract |
| usd_amount | FLOAT | The amount of tokens moved, in $USD |
| usd_exchange_rate | FLOAT | The price of a single token, in USD |
| transaction_from_address | VARCHAR | The address that initiated the transaction |
| transaction_to_address | VARCHAR | The address that received the transaction |
| transaction_hash | VARCHAR | Transaction hash that this transfer belongs to |
| transaction_index | BIGINT | The position of this transaction in the block. The first transaction has index 0 |
| log_index | BIGINT | The position of this log within the block. The first log has index 0 |
| call_type | VARCHAR | Type of the call that generated this transfer |
| transfer_type | VARCHAR | Type of the transfer |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block that contains this transfer |
| block_number | BIGINT | The block number that contains this transfer |
| block_hash | VARCHAR | The block hash that contains this transfer |
| unique_id | VARCHAR | Unique id for each transfer, includes transaction hash, log index and credit/debit type |
| _tokens_updated_at | TIMESTAMP_NTZ(9) | Timestamp when token metadata was last updated |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full refresh |