Table description
Thebitcoin.outputs table contains information about the outputs of Bitcoin transactions. An output is a record of the amount of Bitcoin being sent to a specific address.
Table Schema
| Column | Type | Description |
|---|---|---|
block_time | TIMESTAMP | Timestamp of the block containing this transaction |
block_date | DATE | Date of the block for daily aggregations |
block_height | BIGINT | Height of the block containing this transaction |
block_hash | VARBINARY | Hash of the block containing this transaction |
tx_id | VARBINARY | Hash of the transaction this output belongs to |
index | BIGINT | Position of this output within the transaction’s output list |
value | DOUBLE | Amount of BTC assigned to this output |
address | VARCHAR | Bitcoin address that can spend this output |
type | VARCHAR | Address/script type of the output (e.g. pubkeyhash, scripthash, witness_v0_keyhash) |
script_asm | VARCHAR | Locking script (scriptPubKey) in human-readable ASM format |
script_hex | VARBINARY | Locking script (scriptPubKey) in raw hex |