Credit Debit

The credit-debit model provides a double-entry accounting system for tracking asset movements on the blockchain. This model is particularly useful for analyzing token flows, calculating balances, and understanding asset distribution patterns. Credit Debit vs Transfers Credit-debit tables transform single transfer events into two corresponding entries:

A debit (negative) entry for the sending address
A credit (positive) entry for the receiving address

Example Using an ERC20 token as an example, a token transfer will be represented as follows:

Table Details

Property	Value
Table Name	`bsc.assets.credit_debit`
Table Status	Production-Ready
Unique Key	`transaction_hash`, `unique_id`

Table Columns

Column Name	Data Type	Description
address	VARCHAR(42)	The wallet address holding the tokens
counterparty_address	VARCHAR(42)	Counterparty address of this credit debit row
token_address	VARCHAR(42)	Contract address of the token
token_name	VARCHAR(16777216)	Name of the token
token_symbol	VARCHAR(16777216)	Symbol of the token
token_id	VARCHAR(16777216)	Identifier for non-fungible tokens (ERC-721) or semi-fungible tokens (ERC-1155). Null for fungible tokens. Each unique token_id within a collection represents a distinct asset.
raw_amount	FLOAT	Amount of tokens moved (unnormalized)
raw_amount_str	VARCHAR(16777216)	Amount of tokens moved (unnormalized) in string
amount	FLOAT	Amount of tokens moved, normalized by the decimal points defined in the token contract
amount_str	VARCHAR(16777216)	Amount of tokens moved, normalized in string
usd_amount	FLOAT	The amount of tokens moved, in $USD
usd_exchange_rate	FLOAT	Exchange rate used for USD conversion
transaction_from_address	VARCHAR(42)	The address that initiated the transaction
transaction_to_address	VARCHAR(42)	The address that received the transaction
transaction_hash	VARCHAR(66)	Transaction hash that this transfer belongs to
transaction_index	NUMBER(38,0)	The position of this transaction in the block. The first transaction has index 0
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block
block_number	NUMBER(38,0)	Number of the block
block_hash	VARCHAR(66)	Hash of the block
token_type	VARCHAR(16777216)	Identifies whether the balance record is for a `native` or `erc20` token
unique_id	VARCHAR(16777216)	Unique identifier combining block, address, token address
_tokens_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the token metadata was last updated.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created in the database.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated in the database.
_changed_since_full_refresh	BOOLEAN	Indicates if the record has changed since the last full data refresh.

EVM Assets Credit Debit

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Table Columns

​Table Details

​Table Columns

​Related Docs

Table Details

Table Columns

Related Docs