ERC721 Balances Latest - Allium Documentation Hub

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 Name	Data Type	Description
address	VARCHAR	Address of the account
token_address	VARCHAR	Address of the token
token_name	VARCHAR	Name of the token
token_symbol	VARCHAR	Symbol of the token
token_id	VARCHAR	Token ID of the ERC721 token
raw_balance	FLOAT	Balance of tokens (unnormalized). For ERC721 tokens, there are no decimals division involved
raw_balance_str	VARCHAR	Balance of tokens (unnormalized) in string. For ERC721 tokens, there are no decimals division involved
balance_str	VARCHAR	Balance of tokens in string. For ERC721 tokens, the max balance is 1
balance	FLOAT	Balance of tokens. For ERC721 tokens, the max balance is 1
last_activity_block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the last activity that resulted in this balance
last_activity_block_number	BIGINT	Block number of the last activity that resulted in this balance
last_activity_block_hash	VARCHAR	Block hash of the last activity that resulted in this balance
_updated_at__usd_exchange_rate_current	TIMESTAMP_NTZ(9)	Timestamp of the current USD exchange
unique_id	VARCHAR	Unique ID of the balance
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of the balance update

​Sample Query

​Table Columns

Sample Query

Table Columns