thorchain.defi_upgrades

THORChain protocol upgrade events — version changes and migration records.

Table Description

The thorchain.defi_upgrades table contains data for protocol upgrade events on THORChain.

Column Descriptions

Column	Type	Description
block_id	bigint	Identifier
tx_id	bigint	Transaction ID
from_address	varchar	Source address
to_address	varchar	Destination address
burn_asset	varchar	Burn Asset
rune_amount	decimal(38,0)	Amount in RUNE
rune_amount_usd	decimal(20,6)	USD value of RUNE amount
mint_amount	decimal(38,0)	Amount value
mint_amount_usd	decimal(20,6)	USD value
_unique_key	varchar	Unique Key
_inserted_timestamp	timestamp	Timestamp of the record
fact_upgrades_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
inserted_timestamp	timestamp	Time when the record was inserted
modified_timestamp	timestamp	Time when the record was last modified

Table Sample