ERC1155 Credit Debit

Credit and debit entries of all addresses for every ERC1155 token transfer.

ERC1155 credit debit table allows you to easily track the inflows and outflows of every ERC1155 token belonging to all addresses.

Sample Query

Getting the ERC1155 Credit Debit history of an address.

select * from ethereum.assets.erc721_credit_debit
where address = '0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459' -- Pranksy
order by block_number desc

Table Columns

Column Name
Description
Example

event_type

Transfer event type specific to ERC1155 tokens. Either transfer_single or batch_transfer.

transfer_single

address

Address of the account that was credited or debited value amount of ERC1155 token.

0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459

counterparty_address

The address of counter party of this credit or debit transfer.

0x92acc22c7e154d8164decb901f9cdf0cad93ac6a

token_address

Token address of the ERC1155 token.

0xd07dc4262bcdbf85190c01c996b4c06a461d2430

token_name

Name of the ERC1155 token.

Rarible

token_symbol

Token symbol of this token.

RARI

token_id

Unique ID of the ERC1155 token.

583230

amount_raw

Balance of tokens (unnormalized). For ERC1155 tokens, there are no decimals division involved.

1

amount_raw_str

Balance of tokens (unnormalized) in string.

1

amount

Amount of tokens moved.

1

amount_str

Amount of tokens moved in string.

1

usd_value

The amount of tokens moved, in $USD.

usd_exchange_rate

This is the price of a single token, in $USD. Refer to Hourly Token Prices for more information.

operator

The operator is defined as the addresses authorized (or approved) by a NFT owner to spend all of his token Ids.

0x92acc22c7e154d8164decb901f9cdf0cad93ac6a

transaction_hash

Transaction hash that this transfer belongs to.

0xdfd40caed2ac0cdd89a79b5728a965cda73bc5a56088f1b1d086b3f23fd5df53

log_index

The log index that corresponds to this transfer.

395

block_timestamp

The timestamp of the block that the corresponding transaction of this transfer belongs to. This is also the timestamp when this transfer occurred.

2022-09-18T09:43:59

block_number

The block number that the corresponding transaction of this transfer belongs to.

15559619

block_hash

The block hash that the corresponding transaction of this transfer belongs to.

0x2437b0e92b011094a3e60e6bd9d0cd781cba7237f8fc2d59b8b85e94ef9c2137

unique_id

Unique id generated to each transfer. Includes transaction hash, log index and credit and debit transaction type.

txn-0xdfd40caed2ac0cdd89a79b5728a965cda73bc5a56088f1b1d086b3f23fd5df53_log_index-395_debit

Last updated