The ERC20 Token Transfers table records all transfers made with fungible tokens from the Transfer() event logs.

Table Columns

Unique Key: unique_id

Column NameDescription
from_addressAddress where the token is being transferred from.
to_addressAddress where the token is being transferred to.
token_addressToken address of the asset transferred.
token_nameName of the asset transferred.
token_symbolToken symbol of the asset transferred.
raw_amountAmount of tokens moved (unnormalized).
raw_amount_strAmount of tokens moved (unnormalized) in string to retain precision.
amountAmount of token moved, normalized.
amount_strAmount of token moved, normalized in string to retain precision.
usd_amountThe amount of tokens moved, in $USD.
usd_exchange_rateThe exchange rate used to calculate the usd_value.
transaction_from_addressThe address of the sending party of this transaction.
transaction_to_addressThe address of the receiving party of this transaction (could be a contract address).
transaction_hashTransaction hash that this transfer belongs to.
transaction_indexThe position of this transaction in the block. The first transaction has index 0.
log_indexThe position of this log within the block.
block_timestampThe time when the block that contains this transaction was included on the blockchain.
block_numberThe block number that the corresponding transaction of this transfer belongs to.
block_hashThe block hash that the corresponding transaction of this transfer belongs to.
unique_idUnique id generated to each transfer. Includes transaction hash and log index.

The ERC20 Token Transfers table records all transfers made with fungible tokens from the Transfer() event logs.

Table Columns

Unique Key: unique_id

Column NameDescription
from_addressAddress where the token is being transferred from.
to_addressAddress where the token is being transferred to.
token_addressToken address of the asset transferred.
token_nameName of the asset transferred.
token_symbolToken symbol of the asset transferred.
raw_amountAmount of tokens moved (unnormalized).
raw_amount_strAmount of tokens moved (unnormalized) in string to retain precision.
amountAmount of token moved, normalized.
amount_strAmount of token moved, normalized in string to retain precision.
usd_amountThe amount of tokens moved, in $USD.
usd_exchange_rateThe exchange rate used to calculate the usd_value.
transaction_from_addressThe address of the sending party of this transaction.
transaction_to_addressThe address of the receiving party of this transaction (could be a contract address).
transaction_hashTransaction hash that this transfer belongs to.
transaction_indexThe position of this transaction in the block. The first transaction has index 0.
log_indexThe position of this log within the block.
block_timestampThe time when the block that contains this transaction was included on the blockchain.
block_numberThe block number that the corresponding transaction of this transfer belongs to.
block_hashThe block hash that the corresponding transaction of this transfer belongs to.
unique_idUnique id generated to each transfer. Includes transaction hash and log index.