Links

btc.blocks

SQL table schema for btc.blocks and btc.recent_blocks
Bitcoin Block headers.
Column Name
Data Type
Description
number
BIGINT
Block number
hash
CHARACTER VARYING
Block hash
size
BIGINT
The size of the block, in bytes
stripped_size
BIGINT
The size of block data in bytes excluding witness data
weight
BIGINT
Three times the base size plus the total size
version
BIGINT
Protocol version specified in block header
merkle_root
CHARACTER VARYING
The root node of a Merkle tree, where leaves are transaction hashes
timestamp
BIGINT
Timestamp of the block being collated
nonce
CHARACTER VARYING
Difficulty solution specified in block header
bits
CHARACTER VARYING
Difficulty threshold specified in block header
coinbase_param
CHARACTER VARYING
Data specified in the coinbase transaction of this block
transaction_count
BIGINT
Number of transactions in the block
Last modified 6mo ago