Native Transfers

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 hex address (e.g. Tron)

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 to each transfer.

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 to each transfer.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns