Inscription Transfers - Allium Documentation Hub

The bitcoin.assets.inscription_transfers table contain the transfer details (sender, recipient) of the inscription with the ID of the inscribed satoshis.

Table Details

Property	Value
Table Name	`bitcoin.assets.inscription_transfers`
Table Status	Production-Ready
Unique Key	`block_timestamp::date`, `transaction_hash`, `inscription_id`
Clustering Key(s)	`block_timestamp::date`
Search Optimization	`inscription_id`, `transaction_hash`, `from_utxo_id`, `to_utxo_id`, `from_address`, `to_address`

Get an overview of Ordinals Activity on Bitcoin Network with inscription transfers.

Table Columns

Column Name	Data Type	Description
from_address	VARCHAR(16777216)	Address where the inscription is being transferred from.
input_index	NUMBER(38,0)	Index of the input which spent the UTXO containing the inscription.
from_utxo_id	VARCHAR(16777216)	ID of the origin UTXO.
from_utxo_offset	NUMBER(38,0)	Offset of the sat in the origin UTXO.
to_address	VARCHAR(16777216)	Address where the inscription is being transferred to.
output_index	NUMBER(38,0)	Index of the output UTXO which receives the inscription.
to_utxo_id	VARCHAR(16777216)	ID of the destination UTXO.
to_utxo_offset	NUMBER(38,0)	Offset of the sat in the destination UTXO.
inscription_id	VARCHAR(16777216)	ID of the inscription.
transfer_count	NUMBER(38,0)	Transfer count of the inscription. 0 for the mint transaction
transaction_hash	VARCHAR(16777216)	Unique transaction hash of the transfer.
block_hash	VARCHAR(16777216)	Block hash of the the inscription transfer.
block_number	NUMBER(38,0)	Block number of the inscription transfer.
block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp of the transfer.