Skip to content


The bitcoin.transactions table provides indexed views of all transactions.


Name Type Description
block_number integer The block number the transaction was included in.
fee numeric The fee of the transaction.
hex text The transaction data in hex format.
locktime numeric The locktime of the transaction.
position integer The position of the transaction in the block.
size integer The size of the transaction.
timestamp timestamp The timestamp of the transaction (in ISO-8601 format).
transaction_hash text The hash of the transaction.
txid text The transaction ID.
version numeric The version of the transaction.
vsize integer The virtual size of the transaction.
weight integer The weight of the transaction.
__confirmed boolean Flag indicating whether the transaction has been confirmed.


transaction_hash, position
block_number, position
__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.