Credit Debit
The credit debit table is a double entry book of all utxo interactions in the bitcoin ecosystem. This allows you to easily query for any onchain activity affecting change in balance.
Sample query:
Table Columns
address
Address of the account.
bc1q6kglpx6h6f5a5nljr0u3pfnpgwkp7q4340mcs9
value
Change of value to the address
-91,224
block_timestamp
The timestamp of the block that that resulted in change in balance.
2023-10-24 09:34:58
block_number
The number of the block that resulted in change in balance.
813,624
block_hash
The hash of block that resulted in change in balance.
00000000000000000003306de67b0a54e98ef716b46b012d4d0937286e38d577
transaction_index
Index of the transaction that resulted in the change in balance.
3,703
transaction_hash
Hash of the transaction that resulted in the change in balance.
c7de8299741c7bec5e8bf5f602e6d3ae0970d5f56c65b09e10ab5937afd6762c
input_index
Index of the inputs that resulted in the change in balance (debit)
12 or NULL
output_index
Index of the output that resulted in the change in balance (credit)
123 or NULL
unique_id
Unique ID of the credit debit entry
output-150
Last updated