| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| strategy | VARCHAR(134217728) | Type of yield strategy (long_yield, short_yield, mint_pt_yt, redeem_pt_yt, mint_sy, redeem_sy, add_liquidity, remove_liquidity). |
| event_name | VARCHAR(134217728) | Name of the Pendle router event that produced this record. |
| receiver | VARCHAR(134217728) | Address receiving tokens from the event. |
| market | VARCHAR(134217728) | Pendle market (liquidity pool) address. |
| market_name | VARCHAR(134217728) | Human-readable market name. |
| lp_amount_str | VARCHAR(134217728) | Amount of liquidity pool tokens, as a string to retain precision. |
| lp_amount | FLOAT | Amount of liquidity pool tokens. |
| lp_amount_usd | FLOAT | USD value of the liquidity pool tokens. |
| sy | VARCHAR(134217728) | Standardized yield token address. |
| sy_name | VARCHAR(134217728) | Name of the standardized yield token. |
| sy_amount_str | VARCHAR(134217728) | Amount of standardized yield tokens, as a string to retain precision. |
| sy_amount | FLOAT | Amount of standardized yield tokens. |
| sy_amount_usd | FLOAT | USD value of the standardized yield tokens. |
| pt | VARCHAR(134217728) | Principal token address. |
| pt_name | VARCHAR(134217728) | Name of the principal token. |
| pt_amount_str | VARCHAR(134217728) | Amount of principal tokens, as a string to retain precision. |
| pt_amount | FLOAT | Amount of principal tokens. |
| pt_amount_usd | FLOAT | USD value of the principal tokens. |
| yt | VARCHAR(134217728) | Yield token address. |
| yt_name | VARCHAR(134217728) | Name of the yield token. |
| yt_amount_str | VARCHAR(134217728) | Amount of yield tokens, as a string to retain precision. |
| yt_amount | FLOAT | Amount of yield tokens. |
| yt_amount_usd | FLOAT | USD value of the yield tokens. |
| token | VARCHAR(134217728) | Address of the token being swapped in or out. |
| token_name | VARCHAR(134217728) | Name of the token being swapped. |
| token_symbol | VARCHAR(134217728) | Symbol of the token being swapped. |
| token_amount_str | VARCHAR(134217728) | Amount of tokens being swapped, as a string to retain precision. |
| token_amount | FLOAT | Amount of tokens being swapped. |
| token_amount_usd | FLOAT | USD value of the swapped tokens. |
| usd_amount | FLOAT | Total USD value of the event. |
| extra_fields | VARIANT | JSON object containing additional fields from the onchain event that are not part of the standard schema. |
| transaction_index | NUMBER(38,0) | Zero-based position of the transaction within its block. The first transaction in a block has index 0. |
| log_index | NUMBER(38,0) | Zero-based position of this event log within its transaction. The first log emitted by a transaction has index 0. |
| block_hash | VARCHAR(66) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| unique_id | VARCHAR(134217728) | Allium’s deterministic unique identifier for this row, generated from the fields that uniquely identify the record. Stable across full refreshes. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |
