Table Description
Event-level data for swaps executed on THORChain. This table captures detailed swap events including amounts, fees, slippage, and streaming swap information.Column Descriptions
| Column | Type | Description |
|---|---|---|
| tx_id | bigint | Transaction ID |
| blockchain | varchar | Source blockchain identifier |
| from_address | varchar | Source address |
| to_address | varchar | Destination address |
| from_asset | varchar | Source asset identifier |
| from_e8 | bigint | From E8 |
| to_asset | varchar | Destination asset identifier |
| to_e8 | bigint | To E8 |
| memo | varchar | Transaction memo |
| pool_name | varchar | Name of the liquidity pool |
| to_e8_min | bigint | To E8 Min |
| swap_slip_bp | varchar | Swap slippage in basis points |
| liq_fee_e8 | bigint | Liq Fee E8 |
| liq_fee_in_rune_e8 | bigint | Liq Fee In Rune E8 |
| _DIRECTION | varchar | Direction |
| event_id | bigint | Event identifier |
| block_timestamp | timestamp | Timestamp of when the block was created |
| streaming_count | varchar | Streaming Count |
| streaming_quantity | varchar | Streaming Quantity |
| _TX_TYPE | varchar | Tx Type |
| _INSERTED_TIMESTAMP | timestamp | Timestamp of the record |
| fact_swap_events_id | bigint | Surrogate key for the swap event record |
| dim_block_id | bigint | Reference to the block dimension table |
| inserted_timestamp | timestamp | Time when the record was inserted |
| modified_timestamp | timestamp | Time when the record was last modified |