Enriched Inputs

Inputs in Bitcoin transactions reference unspent outputs from previous transactions, using them to fund new transfers. Each input must match or exceed the value being spent, with any excess allocated to change or fees. Inputs are consumed in a First-In-First-Out (FIFO) manner, helping track the flow of funds.

Enriched bitcoin inputs contain input data enirched with the address that it belonged to (from previous unspent output) and the value of the input utxo. These are represented in address0 and value fields respectively.

Sample Query

To find input utxos belonging to a specific address, do the following:

select 
    inputs.transaction_hash, 
    spent_utxo_id 
from bitcoin.enriched_inputs 
where address0 = 'bc1qvj7sa83e7j9l9dz60vxuy5n4dmp2q8vhml6ftj'

Table Columns

This table is indexed on address0, spent_utxo_id, block_number, block_timestamp, transaction_hash. Query for a specific row with any of these columns to see faster query results.

Column Name
Description
Example

transaction_hash

Transaction hash of input utxo

cda25c1ccefcc07bdde18b3ceb372e46bead3c1e2dba2284e5e598f6ef770179

block_hash

Block hash of the transaction input.

0000000000000000000373af917a0f20860073133a22a3bd3c4259d4349366d0

block_number

Block number or block height of the transaction input.

772,155

block_timestamp

Block timestamp of the transaction input.

2023-01-16 00:56:39

address0

address the input came from

bc1...

value

value of the input

1000

index

The index of the input.

202

spent_utxo_id

Spent UTXO ID generated from transaction hash and index.

b425e59215c510fdd6881660230046b640426ea60a3fb7eaeb3ddb7984f14c4e:194

spent_transaction_hash

The transaction where this input utxo was spent (as an output)

b425e59215c510fdd6881660230046b640426ea60a3fb7eaeb3ddb7984f14c4e

spent_output_index

Index of output from spent transaction.

194

script_asm

The script public key in the form of string,

00145814cbfd2ed36fba9cde2b29fc577e2242dd83af

script_hex

Hexadecimal representation of the bitcoin's script language op-codes.

1600145814cbfd2ed36fba9cde2b29fc577e2242dd83af

sequence

The sequence number of the script.

4,294,967,295

type

The addres type of intput

scripthash

input_id

Input ID generated from transaction hash and index.

cda25c1ccefcc07bdde18b3ceb372e46bead3c1e2dba2284e5e598f6ef770179:202

Last updated