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:

select
    inputs.transaction_hash
    utxo_id
from bitcoin.mempool_inputs
INNER JOIN bitcoin.mempool_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.