Query editor
-- inputs created at top level tx_id, spent_tx_id is the tx the UTXO was created in.-- Values are already summed for you in total "input_value" and "output_value", this is just a demonstration.withinputs as (SELECTtx.id as top_tx_id, tx.block_time as top_block_time, input.tx_id as utxo_id, input.output_number, tx.output_value as top_output_value, tx.input_value as top_input_valueFROM bitcoin.transactions as tx, unnest(input) as input --you can spend from multiple inputsWHERE id = 0x1024cb12a576b69defa67dbc2f1899700ab58e5ad3d5e058edefb907f59865bc --https://www.blockchain.com/explorer/transactions/btc/1024cb12a576b69defa67dbc2f1899700ab58e5ad3d5e058edefb907f59865bcAND tx.block_height = 500000)--all value spent must come from the output of some older transaction. If you follow the tree, you'll eventually end up at some coinbase--https://bitcoin.stackexchange.com/questions/89207/how-to-get-input-address-and-amount-from-vin-using-bitcoin-core-rpcSELECTinputs.*, output.value as input_value, output.block_time as utxo_block_timeFROM inputsJOIN bitcoin.outputs as output ON output.tx_id = inputs.utxo_id AND output.index = inputs.output_number-- --should sum to get totals, subtract output_value from input_value to get fees-- SELECT-- inputs.top_tx_id-- , inputs.block_time-- , sum(output.value) as input_values-- , inputs.top_output_value-- FROM inputs-- JOIN bitcoin.outputs as output ON output.tx_id = inputs.utxo_id AND output.index = inputs.output_number