thorchain.defi_pool_balance_change_events

Table Description

The thorchain.defi_pool_balance_change_events table event data for pool balance change on THORChain. This table is partitioned by day.

Column	Type	Description
asset	varchar	Asset identifier
rune_amt	varchar	Rune Amt
rune_add	varchar	Rune Add
asset_amt	varchar	Asset Amt
asset_add	varchar	Asset Add
reason	varchar	Reason
event_id	bigint	Event identifier
block_timestamp	timestamp	Timestamp of when the block was created
rune_amount	decimal(38,0)	Amount in RUNE
asset_amount	decimal(38,0)	Amount of asset
block_time	timestamp	Timestamp of when the block was created
block_month	timestamp	Block Month
_inserted_timestamp	timestamp	Timestamp of the record
fact_pool_balance_change_events_id	bigint	Surrogate key for the fact 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