thorchain.defi Table: fact_tcy_unstake_events Type: Base Table
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 | |
| _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. |