Skip to main content
The assets data schema includes transfers of inscriptions, balances and credit debit tables

​
A note on native(BTC) transfers

Due to the way utxos work, there is no concept of point to point A->B native transfers in bitcoin. in each tx, a bunch of utxos are spent, and another bunch created, and we cannot reliably conclude that address X sent some amount to some address A. A more concrete example:

Sample txn

Question: How much did X and Y transfer to A,B,C,D? Answer: Depending on how we ‘view’ the sats in the input utxos, there can be many different answers to the above question. Possibility 1 - if we say input sats in a utxo move to the output side in a first-in-first-out (FIFO) manner:

fifo style transfer

Possibility 2 - multiplexed from inputs to output. each input is proportionately split into all the outputs

multiplexed transfers

Possibility 3 - any other logic mapping inputs to outputs (e.g. maybe we assume input0 always pays for the gas?) Depending on the use case of the analysis, how input/outputs translates to transfers will be drastically different. Feel free to reach out to the team to clarify/for assistance in implementing a preferred style! Our Bitcoin Assets schema contains the following tables: