Transactions
The bitcoin.transactions table provides indexed views of all transactions.
Columns
| 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. |
Indexes
| Index |
|---|
| 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.