Skip to main content
The assets.erc721_balances_latest table contains the current balances of ERC721 tokens of all address. This table is derived from the assets.erc721_balances table, by selecting the most recent balance update for each unique address-asset combination.

​
Sample Query

Finding all the holders of Pudgy Penguins NFTs currently. 
select * from ethereum.assets.erc721_balances_latest
where token_address = '0xbd3531da5cf5857e7cfaa92426877b022e612cf8' -- Pudgy Penguins NFT
and address != '0x0000000000000000000000000000000000000000' -- Exclude burn address

​
Table Columns

Unique Key: unique_id
Column NameData TypeDescription
addressVARCHARAddress of the account
token_addressVARCHARAddress of the token
token_nameVARCHARName of the token
token_symbolVARCHARSymbol of the token
token_idVARCHARToken ID of the ERC721 token
raw_balanceFLOATBalance of tokens (unnormalized). For ERC721 tokens, there are no decimals division involved
raw_balance_strVARCHARBalance of tokens (unnormalized) in string. For ERC721 tokens, there are no decimals division involved
balance_strVARCHARBalance of tokens in string. For ERC721 tokens, the max balance is 1
balanceFLOATBalance of tokens. For ERC721 tokens, the max balance is 1
last_activity_block_timestampTIMESTAMP_NTZ(9)Timestamp of the last activity that resulted in this balance
last_activity_block_numberBIGINTBlock number of the last activity that resulted in this balance
last_activity_block_hashVARCHARBlock hash of the last activity that resulted in this balance
_updated_at__usd_exchange_rate_currentTIMESTAMP_NTZ(9)Timestamp of the current USD exchange
unique_idVARCHARUnique ID of the balance
_updated_atTIMESTAMP_NTZ(9)Timestamp of the balance update