Historical Nft Owners
The optimism.historical_nft_owners table is a time-series of NFT balances for a given owner_address every time it sends or receives a NFT.
Columns
| Name | Type | Description |
|---|---|---|
| balance | numeric |
The balance of the owner_address after sending/receiving at the block_number. |
| block_number | integer |
The block number the owner_address sent or received the NFT at. |
| contract_address | text |
Contract address of the NFT's collection. |
| owner_address | text |
The owner address that sent or received the NFT in the block. |
| timestamp | timestamp |
The timestamp the owner_address sent or received the NFT at (in ISO-8601 format). |
| token_id | numeric |
The NFT's token ID. |
| __block_number | integer |
An internal identifier for the indexer that updates this row. Use block_number instead when querying. |
| __confirmed | boolean |
Flag indicating whether the balance has been confirmed by the network. |
| __last_modified | timestamp |
The timestamp when this row was last updated. |
Indexes
| Index |
|---|
| owner_address, contract_address, token_id, timestamp |
| __last_modified |
| __indexer_id WHERE __confirmed = false |
| __indexer_id, __block_number |
| 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.