Skip to main content

Table description

Stores complete ledger of asset transfers across the Peaq network, capturing the movement of tokens between accounts. This table is partitioned by year, month, and day for efficient querying. Each transfer record includes information about the sender and recipient (in both SS58 and public key formats), the asset being transferred, the amount in both processed (double) and raw (decimal) formats, and the event and extrinsic that triggered the transfer.

Column Descriptions

ColumnDescriptionType
yearThe year when the transfer occurred, used for partitioning.int
monthThe month when the transfer occurred, used for partitioning.int
dayThe day when the transfer occurred, used for partitioning.int
block_timeThe timestamp when the block containing this transfer was created.timestamp
block_numberThe block number where this transfer occurred.long
event_idThe unique identifier of the event that represents this transfer.string
extrinsic_idThe unique identifier of the extrinsic that triggered this transfer.string
sectionThe pallet section (module) that emitted the transfer event.string
methodThe method name within the pallet section that identifies the transfer type.string
extrinsic_hashThe hash of the extrinsic that triggered this transfer, in binary format.binary
block_hashThe hash of the block containing this transfer, in binary format.binary
from_ss58The SS58-encoded address of the sender account, in human-readable format.string
from_pub_keyThe public key of the sender account, in binary format.binary
to_ss58The SS58-encoded address of the recipient account, in human-readable format.string
to_pub_keyThe public key of the recipient account, in binary format.binary
assetThe asset identifier or address being transferred.string
symbolThe symbol of the asset being transferred (e.g., “PEAQ”).string
decimalsThe number of decimal places for the asset.long
amountThe transfer amount in processed format (double).double
raw_amountThe transfer amount in raw format, preserving full precision (decimal 38,9).decimal(38,9)
_updated_atThe time when the transfer record was last updated.timestamp
_ingested_atThe time when the transfer data was ingested into the system.timestamp

Table Sample