Native Transfers
Track movement of native token across users.
The Native Token Transfers table contains successful transfers of native tokens of the blockchain.
Broadly, movement of gas token can occur at 2 levels:
- Trace transfers of native tokens:
- Trace calls that deduct native token for movement of native tokens from an address. Only transfers of gas tokens from successful transactions are included.
- Transaction fees:
- Transaction fees payment from initiating a transactions. Both failed and successful transactions are included, as failed transactions still consume gas fees that’s deducted from the transaction sender.
- For transaction fees, we compute the priority and base fees (if applicable) and assign the transaction sender as the
from_addressand the recipient to the respective destination (block miner, sequencer, burn address, etc).
Native gas tokens are represented as
0x0000000000000000000000000000000000000000 in the token_address in our
assets schemas. This may be different for blockchains that do not have the
typical hexadecimal address format. (e.g. Tron)
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 USD amount of the tokens at the time of the transfer. |
| usd_exchange_rate | FLOAT | The exchange rate used to calculate the usd_amount. |
| call_type | VARCHAR | Call type of the transaction. Non-call type will be indicated by NULL. |
| transfer_type | VARCHAR | The type of transfers, depending on the blockchain. Typically include: value_transfer, gas_burn, gas_payment_to_miner. |
| 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 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. |
| _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. |