thorchain.defi_withdraw_events

Table Description

The thorchain.defi_withdraw_events table event data for liquidity withdrawal actions on THORChain. This table captures events when users remove liquidity from pools.

Column Descriptions

Column	Type	Description
_TX_TYPE	varchar	Tx Type
_INSERTED_TIMESTAMP	timestamp	Timestamp of the record
fact_withdraw_events_id	bigint	Surrogate key for the fact record
block_timestamp	timestamp	Timestamp of when the block was created
dim_block_id	bigint	Reference to the block dimension table
tx_id	bigint	Transaction ID
blockchain	varchar	Source blockchain identifier
from_address	varchar	Source address
to_address	varchar	Destination address
asset	varchar	Asset identifier
asset_e8	bigint	Asset amount in e8 units
emit_asset_e8	bigint	Emit Asset E8
emit_rune_e8	bigint	Emit Rune E8
memo	varchar	Transaction memo
pool_name	varchar	Name of the liquidity pool
stake_units	varchar	Pool units (LP tokens) received or burned
basis_points	int	Basis Points
asymmetry	varchar	Asymmetry
imp_loss_protection_e8	bigint	Imp Loss Protection E8
_emit_asset_in_rune_e8	bigint	Emit Asset In Rune E8
inserted_timestamp	timestamp	Time when the record was inserted
modified_timestamp	timestamp	Time when the record was last modified

Table Sample

Upgrades Swaps

​Table Description

​Column Descriptions

​Table Sample

Table Description

Column Descriptions

Table Sample