thorchain.defi Table: fact_tcy_claim_events Type: Base Table
Comprehensive fact table tracking THORchain Yield (TCY) reward claim events and transactions. This
table captures detailed information about users claiming their earned TCY rewards including
transaction IDs, claimed TCY amounts, asset types, RUNE addresses, L1 addresses for cross-chain
operations, memo fields, and precise timing information. Essential for yield analysis and reward
distribution tracking, understanding user claiming behavior patterns, calculating total rewards
distributed, and analyzing cross-chain reward mechanics. Each record represents a unique TCY reward
claim transaction with complete user and transaction metadata for thorough yield farming analysis,
reward distribution monitoring, and protocol performance evaluation.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| FACT_TCY_CLAIM_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 |
| L1_ADDRESS | TEXT | The L1 address |
| ASSET | TEXT | Asset name or pool name |
| TCY_AMT | NUMBER | The TCY 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. |