Table Description
Block-level data for total rewards on THORChain. This table is partitioned by day.Column Descriptions
| 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 |