thorchain.defi Table: fact_tcy_unstake_events Type: Base Table
What
Comprehensive fact table tracking THORchain Yield (TCY) unstaking events and withdrawal transactions. This table captures detailed information about users withdrawing their staked assets from TCY pools including transaction IDs, unstaked amounts, RUNE addresses, memo fields, and precise timing information. Essential for calculating actual yield earned by users, understanding user exit patterns and behaviors, measuring pool retention rates, and analyzing the lifecycle of TCY staking positions. Each record represents a unique TCY unstaking transaction with complete user and transaction metadata for thorough yield farming analysis, liquidity flow tracking, and protocol performance monitoring.Columns
| Column Name | Data Type | Description |
|---|---|---|
| FACT_TCY_UNSTAKE_EVENTS_ID | TEXT | The surrogate key for the table. Will be unique and is used as a foreign key in other tables |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | Timestamp of block minting(without a timezone) |
| DIM_BLOCK_ID | TEXT | FK to DIM_BLOCK table |
| TX_ID | TEXT | The unique transaction id |
| AMOUNT | NUMBER | The amount |
| RUNE_ADDRESS | TEXT | The account public key |
| MEMO | TEXT | The memo for this event |
| EVENT_ID | NUMBER | The primary key for the table. |
| _INSERTED_TIMESTAMP | TIMESTAMP_NTZ | _INSERTED_TIMESTAMP column |
| _AUDIT_RUN_ID | TEXT | _AUDIT_RUN_ID column |
| 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. |