thorchain.defi_swap_events

Table Description

The thorchain.defi_swap_events table provides event-level data for swaps executed on THORChain. This table captures detailed swap events including amounts, fees, slippage, and streaming swap information.

Column Descriptions

Column	Type	Description
tx_id	bigint	Transaction ID
blockchain	varchar	Source blockchain identifier
from_address	varchar	Source address
to_address	varchar	Destination address
from_asset	varchar	Source asset identifier
from_e8	bigint	From E8
to_asset	varchar	Destination asset identifier
to_e8	bigint	To E8
memo	varchar	Transaction memo
pool_name	varchar	Name of the liquidity pool
to_e8_min	bigint	To E8 Min
swap_slip_bp	varchar	Swap slippage in basis points
liq_fee_e8	bigint	Liq Fee E8
liq_fee_in_rune_e8	bigint	Liq Fee In Rune E8
_DIRECTION	varchar	Direction
event_id	bigint	Event identifier
block_timestamp	timestamp	Timestamp of when the block was created
streaming_count	varchar	Streaming Count
streaming_quantity	varchar	Streaming Quantity
_TX_TYPE	varchar	Tx Type
_INSERTED_TIMESTAMP	timestamp	Timestamp of the record
fact_swap_events_id	bigint	Surrogate key for the swap event record
dim_block_id	bigint	Reference to the block dimension table
inserted_timestamp	timestamp	Time when the record was inserted
modified_timestamp	timestamp	Time when the record was last modified

Table Sample

Liquidity Actions New Node Events

​Table Description

​Column Descriptions

​Table Sample

Table Description

Column Descriptions

Table Sample