ERC20 Credit Debit
The ERC20 credit debit model combines erc20 transfers, allowing you to easily track the inflows and outflows of every ERC20 token belonging to all addresses.
Credit Debit vs Transfers Credit Debit tables contain the amount and direction (credit/debit) of every transfer event of all assets (ETH, ERC20, ERC721 and ERC1155).
This table will include two rows for every event, with one row representing credit and one row representing debit. Asset-specific tables are also available for query.
Example Using an ERC20 token as an example, a token transfer will be represented as follows:
| from_address | to_address | amount | event |
|---|---|---|---|
| X | Y | 1250 | X transfers 1250 tokens to Y |
In credit debit, it will be represented two rows.
| address | counterparty_address | amount | event |
|---|---|---|---|
| X | Y | -1250 | X decrease 1250 tokens to Y |
| Y | X | 1250 | Y increase 1250 tokens from X |
Table Columns
Unique Key: unique_id
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR | Address of the account that was credited or debited amount of ERC20 token |
| counterparty_address | VARCHAR | The address of counter party of this credit or debit transfer. |
| token_address | VARCHAR | Token address of the ERC20 token. |
| token_name | VARCHAR | Name of the ERC20 token. |
| token_symbol | VARCHAR | Token symbol of this token. |
| raw_amount | FLOAT | Amount of tokens moved (unnormalized). |
| raw_amount_str | VARCHAR | Amount of tokens moved (unnormalized) in string. |
| amount | FLOAT | Amount of tokens moved, normalized by the decimal points defined in the ERC20 token contract. For example, USDC has 6 decimals, so this value is the raw_value divided by 10^6. |
| amount_str | VARCHAR | Amount of tokens moved, normalized in string. |
| usd_value | FLOAT | The amount of tokens moved, in $USD. |
| usd_exchange_rate | FLOAT | This is the price of a single token, in USD. |
| 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. |
| log_index | BIGINT | The position of this log within the block. The first log has index 0. |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block that the corresponding transaction of this transfer belongs to. This is also the timestamp when this transfer occurred. |
| 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. Includes transaction hash, log index and credit and debit transaction type. |
ERC20 Credit Debit
The ERC20 credit debit model combines erc20 transfers, allowing you to easily track the inflows and outflows of every ERC20 token belonging to all addresses.
Credit Debit vs Transfers Credit Debit tables contain the amount and direction (credit/debit) of every transfer event of all assets (ETH, ERC20, ERC721 and ERC1155).
This table will include two rows for every event, with one row representing credit and one row representing debit. Asset-specific tables are also available for query.
Example Using an ERC20 token as an example, a token transfer will be represented as follows:
| from_address | to_address | amount | event |
|---|---|---|---|
| X | Y | 1250 | X transfers 1250 tokens to Y |
In credit debit, it will be represented two rows.
| address | counterparty_address | amount | event |
|---|---|---|---|
| X | Y | -1250 | X decrease 1250 tokens to Y |
| Y | X | 1250 | Y increase 1250 tokens from X |
Table Columns
Unique Key: unique_id
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR | Address of the account that was credited or debited amount of ERC20 token |
| counterparty_address | VARCHAR | The address of counter party of this credit or debit transfer. |
| token_address | VARCHAR | Token address of the ERC20 token. |
| token_name | VARCHAR | Name of the ERC20 token. |
| token_symbol | VARCHAR | Token symbol of this token. |
| raw_amount | FLOAT | Amount of tokens moved (unnormalized). |
| raw_amount_str | VARCHAR | Amount of tokens moved (unnormalized) in string. |
| amount | FLOAT | Amount of tokens moved, normalized by the decimal points defined in the ERC20 token contract. For example, USDC has 6 decimals, so this value is the raw_value divided by 10^6. |
| amount_str | VARCHAR | Amount of tokens moved, normalized in string. |
| usd_value | FLOAT | The amount of tokens moved, in $USD. |
| usd_exchange_rate | FLOAT | This is the price of a single token, in USD. |
| 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. |
| log_index | BIGINT | The position of this log within the block. The first log has index 0. |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block that the corresponding transaction of this transfer belongs to. This is also the timestamp when this transfer occurred. |
| 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. Includes transaction hash, log index and credit and debit transaction type. |