thorchain.defi Table: fact_tcy_stake_events Type: Base Table
Comprehensive fact table tracking THORchain Yield (TCY) staking events and transactions. This table
captures detailed information about user staking activities including transaction IDs, staked
amounts, RUNE addresses, memo fields, and precise timing information. Essential for analyzing user
staking behavior patterns, calculating total value locked (TVL) in TCY pools, measuring staking
trends over time, and understanding liquidity provision dynamics. Each record represents a unique
TCY staking transaction with complete user and transaction metadata for thorough yield farming
analysis, user behavior tracking, and protocol performance monitoring.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| FACT_TCY_STAKE_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 |
| RUNE_ADDRESS | TEXT | The account public key |
| AMOUNT | NUMBER | The amount |
| 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. |