ERC20 Transfers

The ERC20 token transfers table records all transfers made with erc20 compatible tokens from the Transfer() event logs. For wrapped native token assets such as Wrapped Ether, we create a transfer event to the recipient/sender of the wrapped asset during a wrapping/unwrapping transaction.

For wrapping native tokens, we use the Deposit() event logs of the WETH equivalent contract for the blockchain.
For unwrapping native tokens, we use the Withdraw() event logs of the WETH equivalent contract for the blockchain.

Table Columns

Unique Key: unique_id

Column Name	Data Type	Description
from_address	VARCHAR	Address where the token is being transferred from.
to_address	VARCHAR	Address where the token is being transferred to.
token_address	VARCHAR	Token address of the asset transferred.
token_name	VARCHAR	Name of the asset transferred.
token_symbol	VARCHAR	Token symbol of the asset transferred.
raw_amount	FLOAT	Amount of tokens transferred (unnormalized).
raw_amount_str	VARCHAR	Amount of tokens transferred (unnormalized) in string to retain precision.
amount	FLOAT	Amount of token transferred, normalized.
amount_str	VARCHAR	Amount of token transferred, normalized in string to retain precision.
usd_amount	FLOAT	The amount of tokens moved, in $USD.
usd_exchange_rate	FLOAT	The exchange rate used to calculate the `usd_amount`.
transaction_from_address	VARCHAR	The address of the sending party of this transaction.
transaction_to_address	VARCHAR	The address of the receiving party of this transaction (could be a contract address).
transaction_hash	VARCHAR	Transaction hash that this transfer belongs to.
transaction_index	BIGINT	The position of this transaction in the block. The first transaction of a block has index 0.
log_index	BIGINT	The position of this log within the block. The first log of a block has index 0.
block_timestamp	TIMESTAMP_NTZ(9)	The time when the block that contains this transaction was included on the blockchain.
block_number	BIGINT	The block number that the corresponding transaction of this transfer belongs to.
block_hash	VARCHAR	The block hash that the corresponding transaction of this transfer belongs to.
unique_id	VARCHAR	Unique ID generated for each transfer. Includes transaction hash and log index.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated.
_changed_since_full_refresh	BOOLEAN	Indicates if the record has changed since the last full refresh.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns