ERC721 Credit Debit

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

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

Sample Query

Getting the ERC721 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 NameDescriptionExample

address

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

0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459

counterparty_address

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

0x3a3355805181ba5752cb52cebe8c95c0f3ed3d61

token_address

Token address of the ERC721 token.

0x453de6bb174148de579acf3c0ace98fc0671bccc

token_name

Name of the ERC721 token.

BruceTheGoose

token_symbol

Token symbol of this token.

GOOS

token_id

Unique ID of the ERC721 token.

10059

raw_amount

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

1

raw_amount_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.

transaction_hash

Transaction hash that this transfer belongs to.

0x6da35a18d348f9f3415ad596e2c92e5419b490a5ca37b07da765493207d147d8

log_index

The log index that corresponds to this transfer.

62

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.

2020-09-24 11:09:46.000

block_number

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

10,924,947

block_hash

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

0x8211192e00d12750ed46c5b63ba88a98172215f56324e3390f16aabce22d2a05

unique_id

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

txn-0x6da35a18d348f9f3415ad596e2c92e5419b490a5ca37b07da765493207d147d8_log_index-62_debit

Last updated