thorchain.defi_total_block_rewards

Table Description

The thorchain.defi_total_block_rewards table block-level data for total rewards on THORChain. This table is partitioned by day.

Column	Type	Description
block_id	bigint	Identifier
reward_entity	varchar	Reward Entity
rune_amount	decimal(38,0)	Amount in RUNE
rune_amount_usd	decimal(20,6)	USD value of RUNE amount
_unique_key	varchar	Unique Key
_INSERTED_TIMESTAMP	timestamp	Timestamp of the record
fact_total_block_rewards_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