thorchain.defi Table: fact_block_rewards Type: Base Table
The summarized rewards information for each block per day
Columns
| Column Name | Data Type | Description |
|---|---|---|
| FACT_BLOCK_REWARDS_ID | TEXT | The surrogate key for the table. Will be unique and is used as a foreign key in other tables |
| DAY | DATE | The recorded day |
| LIQUIDITY_FEE | FLOAT | The summarized liquidity cost fee within this day |
| BLOCK_REWARDS | FLOAT | The summarized total block rewards within this day |
| EARNINGS | FLOAT | The summarized earnings within this day |
| BONDING_EARNINGS | FLOAT | The summarized bonding earnings within this day |
| LIQUIDITY_EARNINGS | FLOAT | The summarized liquidity earnings fee within this day |
| AVG_NODE_COUNT | NUMBER | The summarized average node operators number within this day |
| _INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| _AUDIT_RUN_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |