Skip to content

Output Transfers

The bitcoin.output_transfers table provides indexed views of all output transfers.

Columns

Name Type Description
address text The address associated with the transfer.
asset text The asset type.
block_number integer The block number the transfer was included in.
index integer The index of the output transfer.
timestamp timestamp The timestamp of the transfer (in ISO-8601 format).
transaction_hash text The hash of the transaction that includes the transfer.
transaction_position integer The position of the transaction in the block.
value numeric The value transferred.
__confirmed boolean Flag indicating whether the transfer has been confirmed.

Indexes

Index
transaction_hash, index
block_number, transaction_position
transaction_hash, transaction_position
address, transaction_hash, index
__confirmed 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.