The native credit debit model combines native transfers, allowing you to easily track the inflows and outflows of every native token belonging to all addresses.

Table Columns

Unique Key: unique_id

Column NameData TypeDescription
addressVARCHARAddress of the account that was credited or debited value amount of ETH
counterparty_addressVARCHARThe address of counter party of this credit or debit transfer.
raw_amountNUMERICAmount of ETH in wei
raw_amount_strVARCHARAmount of ETH in wei in string format
amountFLOATAmount of ether
amount_strVARCHARAmount of ether in string format
usd_amountFLOATThe amount of ether moved, in $USD
usd_exchange_rateFLOATThe exchange rate used to calculate the usd_value
transfer_typeVARCHARType of transfers. Includes value_transfer, gas_payment_to_mine, gas_burn
transaction_hashVARCHARTransaction hash that this transfer belongs to
transaction_indexBIGINTThe position of this transaction in the block. The first transaction has index 0.
block_timestampTIMESTAMP_NTZ(9)The timestamp of the block that the corresponding transaction of this transfer belongs to
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 to each transfer.

The native credit debit model combines native transfers, allowing you to easily track the inflows and outflows of every native token belonging to all addresses.

Table Columns

Unique Key: unique_id

Column NameData TypeDescription
addressVARCHARAddress of the account that was credited or debited value amount of ETH
counterparty_addressVARCHARThe address of counter party of this credit or debit transfer.
raw_amountNUMERICAmount of ETH in wei
raw_amount_strVARCHARAmount of ETH in wei in string format
amountFLOATAmount of ether
amount_strVARCHARAmount of ether in string format
usd_amountFLOATThe amount of ether moved, in $USD
usd_exchange_rateFLOATThe exchange rate used to calculate the usd_value
transfer_typeVARCHARType of transfers. Includes value_transfer, gas_payment_to_mine, gas_burn
transaction_hashVARCHARTransaction hash that this transfer belongs to
transaction_indexBIGINTThe position of this transaction in the block. The first transaction has index 0.
block_timestampTIMESTAMP_NTZ(9)The timestamp of the block that the corresponding transaction of this transfer belongs to
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 to each transfer.