bitcoin.outputs - Dune Docs

Table description

The bitcoin.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

Table Sample

Inputs Transactions