Skip to main content

Table Description

Records all cross-chain native asset swaps executed on THORChain. This table captures swap transactions that allow users to swap native assets across multiple chains without wrapped or pegged tokens.

Column Descriptions

ColumnTypeDescription
block_timestamptimestampTimestamp of when the block was created
block_idbigintIdentifier
tx_idbigintTransaction ID
blockchainvarcharSource blockchain identifier
pool_namevarcharName of the liquidity pool
from_addressvarcharSource address
native_to_addressvarcharAddress
to_pool_addressvarcharAddress
affiliate_addressvarcharAddress
affiliate_fee_basis_pointsintAffiliate Fee Basis Points
affiliate_addresses_arrayarray(varchar)Address
affiliate_fee_basis_points_arrayintAffiliate Fee Basis Points Array
from_assetvarcharSource asset identifier
to_assetvarcharDestination asset identifier
from_amountdecimal(38,0)Amount of source asset
to_amountdecimal(38,0)Amount of destination asset
min_to_amountdecimal(38,0)Amount value
from_amount_usddecimal(20,6)USD value
to_amount_usddecimal(20,6)USD value
rune_usddecimal(20,6)Rune Usd
asset_usddecimal(20,6)Asset Usd
to_amount_min_usddecimal(20,6)USD value
swap_slip_bpvarcharSwap slippage in basis points
liq_fee_runevarcharLiquidity fee in RUNE
liq_fee_rune_usddecimal(20,6)USD value of liquidity fee in RUNE
liq_fee_assetvarcharLiq Fee Asset
liq_fee_asset_usddecimal(20,6)Liq Fee Asset Usd
streaming_countvarcharStreaming Count
streaming_quantityvarcharStreaming Quantity
_TX_TYPEvarcharTx Type
_unique_keyvarcharUnique Key
_inserted_timestamptimestampTimestamp of the record
fact_swaps_idbigintSurrogate key for the swap record
dim_block_idbigintReference to the block dimension table
inserted_timestamptimestampTime when the record was inserted
modified_timestamptimestampTime when the record was last modified

Table Sample