Ordinals inscription transfers involve moving inscribed satoshis from one Bitcoin wallet to another. Each transfer preserves the inscription’s data, maintaining its uniqueness and ownership history on-chain. The process is similar to standard Bitcoin transactions, but with inscribed satoshis acting like digital collectibles. Ownership is updated with each transfer, allowing inscribed satoshis to be traded or collected while remaining part of the Bitcoin blockchain.

Read more in docs here: https://docs.ordinals.com/

Sample Query

Fetch inscription transfers for a given address

select * from bitcoin.ordinals_inscription_transfers where from_address = 'bc1p757l4macyx2s4wrnhjyafwehtjra0reqptqjxw2265vjer29h25qfv3ash';

Table Columns

ColumnDescriptionExample
from_addressaddress the inscription was sent frombc1p757l4macyx2s4wrnhjyafwehtjra0reqptqjxw2265vjer29h25qfv3ash
input_indexindex of input containing inscription0
from_utxo_idutxo id of input containing inscriptiond59fcdb27c33d8ec4c27a8d806ee679ac0d6411c7a921fc6e862d9478fa87846:0
from_utxo_offsetinput utxo offset of satoshi containing inscription0
to_addressaddress the inscription was sent tobc1pzu0u7lhdy69r64v9n94rerpdfu5qe82zdmkmx7zj5uw3dezyzt5serrgzd
output_indexindex of output containing inscription0
to_utxo_idutxo id of output containing inscription67022c7df83e4b2c74761172f97d1c47db209ced8b2cbe5dc16c4063a9ee9528:0
to_utxo_offsetoutput utxo offset of satoshi containing inscription0
inscription_idinscription id67022c7df83e4b2c74761172f97d1c47db209ced8b2cbe5dc16c4063a9ee9528i0
transfer_countnumber of times the inscription was transferred, note that only the first transfer counts as per inscription docs0
transaction_hashtransaction hash of transfer67022c7df83e4b2c74761172f97d1c47db209ced8b2cbe5dc16c4063a9ee9528
block_hashblock hash of transfer00000000000000000004f3f03394c49cffb4efe7208e413cc36ee45e6992cdfc
block_numberblock number of transfer778741
block_timestampblock timestamp of transfer2023-03-01 03:03:50
transaction_indextransaction index of transfer916
valuevalue of utxo containing inscription4000
sat_tx_offsetsat level offset of output containing inscription0
is_tokenwhether transferred inscription is a brc-20 tokenf