Skip to main content
Schema: crosschain.unifai Table: fact_swaps Type: Base Table

What

This table contains fact-based records of swap transactions within the UnifAI protocol. It captures essential information about each swap event, including transaction details, token information, and user data.

Columns

Column NameData TypeDescription
CREATED_AT_TIMESTAMPTIMESTAMP_NTZThe timestamp when the transaction was created.
TX_HASHTEXTThe unique transaction hash that identifies the transaction on the blockchain.
CHAINTEXTThe blockchain network on which the transaction occurred.
AMOUNTFLOATThe amount of tokens involved in the transaction.
INPUT_TOKENTEXTThe token swapped from
OUTPUT_TOKENTEXTThe token swapped to
SLIPPAGEFLOATThe slippage percentage or amount that occurred during the swap transaction.
STATUSTEXTThe status of the transaction, indicating whether it was successful, pending, or failed.
TX_TYPETEXTThe type of swap transaction, notably the aggregator used.
WALLET_ADDRESSTEXTThe blockchain wallet address used in the swap transaction.
WALLET_CHAINTEXTThe blockchain network of the wallet used in the swap transaction.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.
FACT_SWAPS_IDTEXTThe unique identifier for each row in the table.