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.

​

Sample Query

To find input utxos belonging to a specific address, do the following (note that we’ve added a bitcoin.enriched_inputs table that has better support for fetching input utxos belonging to a specific address):

select

    inputs.transaction_hash

    utxo_id

from bitcoin.inputs

INNER JOIN bitcoin.outputs

ON outputs.utxo_id = inputs.spent_utxo_id

where inputs.block_timestamp >= current_timestamp - interval '1 hour'

and inputs.block_timestamp < current_timestamp

and outputs.address0 = 'bc1qvj7sa83e7j9l9dz60vxuy5n4dmp2q8vhml6ftj'

​

Table Columns

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