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 NameDescriptionExampleColumn Name
addressAddress of the account that was credited or debited value amount of ERC721 token0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459
counterparty_addressThe address of counter party of this credit or debit transfer.0x3a3355805181ba5752cb52cebe8c95c0f3ed3d61
token_addressToken address of the ERC721 token.0x453de6bb174148de579acf3c0ace98fc0671bccc
token_nameName of the ERC721 token.BruceTheGoose
token_symbolToken symbol of this token.GOOS
token_idUnique ID of the ERC721 token.10059
raw_amountBalance of tokens (unnormalized). For ERC721 tokens, there are no decimals division involved. 1
raw_amount_strBalance of tokens (unnormalized) in string.1
amountAmount of tokens moved.1
amount_strAmount of tokens moved in string.1
usd_valueThe amount of tokens moved, in USD.</td><td></td><td></td></tr><tr><td>usdexchangerate</td><td>Thisisthepriceofasingletoken,inUSD.</td><td></td><td></td></tr><tr><td>usd_exchange_rate</td><td>This is the price of a single token, in USD.

Refer to Hourly Token Prices for more information.
transaction_hashTransaction hash that this transfer belongs to.0x6da35a18d348f9f3415ad596e2c92e5419b490a5ca37b07da765493207d147d8
log_indexThe log index that corresponds to this transfer.62
block_timestampThe 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_numberThe block number that the corresponding transaction of this transfer belongs to.10,924,947
block_hashThe block hash that the corresponding transaction of this transfer belongs to.0x8211192e00d12750ed46c5b63ba88a98172215f56324e3390f16aabce22d2a05
unique_idUnique id generated to each transfer. Includes transaction hash, log index and credit and debit transaction type. txn-0x6da35a18d348f9f3415ad596e2c92e5419b490a5ca37b07da765493207d147d8_log_index-62_debit