Historical Nft Owners
ethereum.historical_nft_owners table is a time-series of NFT balances for a given owner_address every time it sends or receives a NFT.
||The balance of the
||The block number the
||Contract address of the NFT's collection.|
||The owner address that sent or received the NFT in the block.|
||The timestamp the
||The NFT's token ID.|
||An internal identifier for the indexer that updates this row. Use block_number instead when querying.|
||Flag indicating whether the balance has been confirmed by the network.|
||The timestamp when this row was last updated.|
|owner_address, contract_address, token_id, timestamp|
|__indexer_id WHERE __confirmed = false|
|contract_address, token_id, owner_address, timestamp|
Got questions? Join our Discord
Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.