Links

btc.transactions

SQL table schema for btc.transactions and btc.recent_transactions
Bitcoin Block transactions.
Column Name
Data Type
Description
hash
CHARACTER VARYING
The hash of this transaction
size
BIGINT
The size of this transaction in bytes
virtual_size
BIGINT
The virtual transaction size (differs from size for witness transactions
version
BIGINT
Protocol version specified in block which contained this transaction
lock_time
BIGINT
Earliest time that miners can include the transaction in their hashing of the Merkle root to attach it in the latest block of the blockchain
block_hash
CHARACTER VARYING
Hash of the block which contains this transaction
block_number
BIGINT
Number of the block which contains this transaction
block_timestamp
BIGINT
Timestamp of the block which contains this transaction
input_count
BIGINT
The number of inputs in the transaction
output_count
BIGINT
The number of outputs in the transaction
input_value
DECIMAL
Total value of inputs in the transaction
output_value
DECIMAL
Total value of outputs in the transaction
is_coinbase
BOOLEAN
True if this transaction is a coinbase transaction
fee
DECIMAL
The fee paid by this transaction
Last modified 6mo ago