thorchain.defi Table: fact_daily_tvl Type: Base Table
Fact table that shows the total valued locked and the total value bonded/pooled
Columns
| Column Name | Data Type | Description |
|---|---|---|
| FACT_DAILY_TVL_ID | TEXT | The surrogate key for the table. Will be unique and is used as a foreign key in other tables |
| DAY | DATE | The unique transaction id |
| TOTAL_VALUE_POOLED | FLOAT | The total amount of rune provided by the liquidity provides and pooled in the pool |
| TOTAL_VALUE_POOLED_USD | FLOAT | The total USD amount of rune provided by the liquidity provides and pooled in the pool |
| TOTAL_VALUE_BONDED | FLOAT | The total amount of rune provided by the node operators and bonded in the pool |
| TOTAL_VALUE_BONDED_USD | FLOAT | The total USD amount of rune provided by the node operators and bonded in the pool |
| TOTAL_VALUE_LOCKED | FLOAT | The total rune value locked in the pool |
| TOTAL_VALUE_LOCKED_USD | FLOAT | The total USD value locked in the pool |
| _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. |