ERC721 Balances Latest - Allium Documentation Hub

The ERC721 Balances Latest table contains the current balances of ERC721 tokens of all address. This table is derived from the 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
transaction_hash	VARCHAR	Transaction hash of the most recent activity that resulted in this balance
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