Priced Transfers Failed Table

Contains information about failed priced transfers within the Solana network, aiding in the analysis of transaction failures and associated details.

Name

Type

Description

BLOCK_SLOT

FIXED

Slot number or identifier of the block.

TIMESTAMP

FIXED

Raw value of the time in Unix Epoch time (in UTC time zone), which is then converted to DATETIME column.

DATETIME

TIMESTAMP_NTZ

Timestamp of the transaction in UTC.

BLOCK_HASH

TEXT

The hash of a specific block in the chain.

TRANSACTION_INDEX

FIXED

The position or order of a transaction within a block of the blockchain.

TRANSACTION_ID

TEXT

Unique identifier assigned to each transaction within the blockchain.

INSTRUCTION_INDEX

FIXED

Index of the instruction within a transaction.

INNER_INSTRUCTION_INDEX

FIXED

Index of inner instruction within a transaction.

PROGRAM

TEXT

Program or smart contract associated with the instruction.

PROGRAM_ID

TEXT

The program ID of the instruction.

TYPE

TEXT

The type of the transfer.

ACCOUNT_AUTHORITY

TEXT

The authority address that is assigned to the account.

SIGNERS

VARIANT

List of signers associated with the instruction.

FROM_ACCOUNT_OWNER

TEXT

The owner address of the from account.

FROM_ACCOUNT_SOURCE

TEXT

The source address of the from account.

FROM_ACCOUNT

TEXT

The projected highest level from account owner based on owner, authority, and source fields in this order.

TO_ACCOUNT_OWNER

TEXT

The owner address of the to account.

TO_ACCOUNT_DESTINATION

TEXT

The source address of the to account.

TO_ACCOUNT

TEXT

The projected highest level to_account owner based on owner and destination fields in this order.

TOKEN_ADDRESS

TEXT

The address of the token.

NAME

TEXT

The name of the token being searched.

SYMBOL

TEXT

The symbol of the token being searched.

VALUE

REAL

The curated quantity of the token. A negative value indicates the token is being sent out. A positive value indicates the token is being received.

TOKEN_FEE

REAL

The fee or royalties associated to the token account.

USD_VALUE

REAL

The curated value of the token, priced in USD.

USD_TOKEN_FEE

REAL

The token fee priced in USD.

SOURCE_VALUE

FIXED

The raw quantity of the token before the decimal conversion.

SOURCE_TOKEN_FEE

FIXED

The raw quantity of the token before the decimal conversion.

DATE_CREATED

TIMESTAMP_NTZ

Indicates the date in which the data was loaded.

DATE_UPDATED

TIMESTAMP_NTZ

Indicates the date in which the data was updated.

🔍 Use these columns to analyze failed priced transfers and diagnose potential issues, identifying which program was involved, the block and transaction where the failure occurred, and any relevant authority or signers associated with the account, among others. You can:

  • Identify the block and transaction context using BLOCK_SLOT, TIMESTAMP, DATETIME, BLOCK_HASH, TRANSACTION_INDEX, and TRANSACTION_ID.

  • Pinpoint the specific instruction with INSTRUCTION_INDEX and INNER_INSTRUCTION_INDEX.

  • Examine transfer details by reviewing PROGRAM, PROGRAM_ID, and TYPE.

  • Understand account involvement with ACCOUNT_AUTHORITY and SIGNERS.

  • Analyze participating accounts via FROM_ACCOUNT_OWNER, FROM_ACCOUNT_SOURCE, FROM_ACCOUNT, TO_ACCOUNT_OWNER, TO_ACCOUNT_DESTINATION, and TO_ACCOUNT.

  • Retrieve token identity and characteristics using TOKEN_ADDRESS, NAME, and SYMBOL.

  • Evaluate the attempted transfer amount and fee structure with VALUE, TOKEN_FEE, USD_VALUE, USD_TOKEN_FEE, SOURCE_VALUE, and SOURCE_TOKEN_FEE.

  • Monitor data recency using DATE_CREATED and DATE_UPDATED.

💡 For example, you might query VALUE, USD_VALUE, and FROM_ACCOUNT to assess the scale of a failed transfer and determine the context of the failure, along with other key parameters.

Last updated