thorchain.defi Table: fact_daily_earnings Type: Base Table
The earnings information for the whole THORChain network broken down by daily
Columns
| Column Name | Data Type | Description |
|---|---|---|
| FACT_DAILY_EARNINGS_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_FEES | FLOAT | The summarized liquidity cost fee within this day |
| LIQUIDITY_FEES_USD | FLOAT | The summarized liquidity cost fee within this day in USD |
| BLOCK_REWARDS | FLOAT | The summarized total block rewards within this day |
| BLOCK_REWARDS_USD | FLOAT | The summarized total block rewards within this day in USD |
| TOTAL_EARNINGS | FLOAT | The summarized total earnings within this day |
| TOTAL_EARNINGS_USD | FLOAT | The summarized total earnings within this day in USD |
| EARNINGS_TO_NODES | FLOAT | The summarized bonding earnings within this day |
| EARNINGS_TO_NODES_USD | FLOAT | The summarized bonding earnings within this day in USD |
| EARNINGS_TO_POOLS | FLOAT | The summarized liquidity earnings fee within this day |
| EARNINGS_TO_POOLS_USD | FLOAT | The summarized liquidity earnings fee within this day in USD |
| 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. |