Historical Native Token Owners
nova.historical_native_token_owners table is a time-series of native token balances for a given owner_address every time it sends or receives a token. This token inclues miner addresses, transaction senders, failed transactions, and accounts that withdraw their stake from the Beacon Chain
|The balance of the
owner_address after sending/receiving at the
|The block number the
owner_address sent or received the native token at.
|The owner address that sent or received the native token in the block.
|The timestamp the
owner_address sent or received the native token at (in ISO-8601 format).
|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.
|__indexer_id WHERE __confirmed = false
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.