Table Description
Event data for liquidity withdrawal actions on THORChain. This table captures events when users remove liquidity from pools.Column Descriptions
| Column | Type | Description |
|---|---|---|
| _TX_TYPE | varchar | Tx Type |
| _INSERTED_TIMESTAMP | timestamp | Timestamp of the record |
| fact_withdraw_events_id | bigint | Surrogate key for the fact record |
| block_timestamp | timestamp | Timestamp of when the block was created |
| dim_block_id | bigint | Reference to the block dimension table |
| tx_id | bigint | Transaction ID |
| blockchain | varchar | Source blockchain identifier |
| from_address | varchar | Source address |
| to_address | varchar | Destination address |
| asset | varchar | Asset identifier |
| asset_e8 | bigint | Asset amount in e8 units |
| emit_asset_e8 | bigint | Emit Asset E8 |
| emit_rune_e8 | bigint | Emit Rune E8 |
| memo | varchar | Transaction memo |
| pool_name | varchar | Name of the liquidity pool |
| stake_units | varchar | Pool units (LP tokens) received or burned |
| basis_points | int | Basis Points |
| asymmetry | varchar | Asymmetry |
| imp_loss_protection_e8 | bigint | Imp Loss Protection E8 |
| _emit_asset_in_rune_e8 | bigint | Emit Asset In Rune E8 |
| inserted_timestamp | timestamp | Time when the record was inserted |
| modified_timestamp | timestamp | Time when the record was last modified |