Skip to main content
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 NameData TypeDescription
from_addressVARCHARAddress where the token is being transferred from.
to_addressVARCHARAddress where the token is being transferred to.
token_addressVARCHARToken address of the asset transferred.
token_nameVARCHARName of the asset transferred.
token_symbolVARCHARToken symbol of the asset transferred.
raw_amountFLOATAmount of tokens transferred (unnormalized).
raw_amount_strVARCHARAmount of tokens transferred (unnormalized) in string to retain precision.
amountFLOATAmount of token transferred, normalized.
amount_strVARCHARAmount of token transferred, normalized in string to retain precision.
usd_amountFLOATThe amount of tokens moved, in $USD.
usd_exchange_rateFLOATThe exchange rate used to calculate the usd_amount.
transaction_from_addressVARCHARThe address of the sending party of this transaction.
transaction_to_addressVARCHARThe address of the receiving party of this transaction (could be a contract address).
transaction_hashVARCHARTransaction hash that this transfer belongs to.
transaction_indexBIGINTThe position of this transaction in the block. The first transaction of a block has index 0.
log_indexBIGINTThe position of this log within the block. The first log of a block has index 0.
block_timestampTIMESTAMP_NTZ(9)The time when the block that contains this transaction was included on the blockchain.
block_numberBIGINTThe block number that the corresponding transaction of this transfer belongs to.
block_hashVARCHARThe block hash that the corresponding transaction of this transfer belongs to.
unique_idVARCHARUnique ID generated for each transfer. Includes transaction hash and log index.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated.
_changed_since_full_refreshBOOLEANIndicates if the record has changed since the last full refresh.
⌘I