Skip to main content
The ERC721 Balances Daily table provides one row per (address, token, token_id, date) capturing the closing ERC721 balance for each day. Use this table for day-over-day ownership analysis and point-in-time holder views. For per-block balance changes, use the erc721_balances table instead.

Table Columns

Column NameData TypeDescription
dateTIMESTAMP_NTZ(9)The UTC date this daily balance snapshot covers
addressVARCHARThe wallet address holding the tokens
token_addressVARCHARContract address of the ERC721 token
token_nameVARCHARName of the token
token_symbolVARCHARSymbol of the token
token_idVARCHARToken ID of the ERC721 token
balanceINTEGERToken balance. For ERC721 tokens, the max balance is 1
balance_strVARCHARToken balance as a string. For ERC721 tokens, the max is 1
last_activity_block_timestampTIMESTAMP_NTZ(9)Block timestamp of the most recent balance-changing activity
last_activity_block_numberINTEGERBlock number of the most recent balance-changing activity
last_activity_block_hashVARCHARBlock hash of the most recent balance-changing activity