thorchain.defi_pool_events

THORChain pool lifecycle events — creation, suspension, and status changes.

Table Description

The thorchain.defi_pool_events table event data for pool-related events on THORChain. This table captures various pool events including balance changes and pool operations.

Column Descriptions

Column	Type	Description
asset	varchar	Asset identifier
status	varchar	Status
event_id	bigint	Event identifier
block_timestamp	timestamp	Timestamp of when the block was created
fact_pool_events_id	bigint	Surrogate key for the fact record
day	timestamp	Date of the 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