ERC20 Transfers
Track movement of ERC20 token transfers across all addresses.
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 theWETHequivalent contract for the blockchain. - For unwrapping native tokens, we use the
Withdraw()event logs of theWETHequivalent 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. |