| FACT_SWAPS_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 |
| BLOCKCHAIN | TEXT | The name of the blockchain |
| POOL_NAME | TEXT | Name of the pool — also asset name in other tables |
| FROM_ADDRESS | TEXT | The user address that initiates the swap |
| NATIVE_TO_ADDRESS | TEXT | The user address that is receiving the result of the swap |
| TO_POOL_ADDRESS | TEXT | The pool address that processes the swap |
| AFFILIATE_ADDRESS | TEXT | The affiliate address that is receiving the affiliate fee (redundant with array) |
| AFFILIATE_FEE_BASIS_POINTS | NUMBER | The affiliate fee basis points that is received by the affiliate address (redundant with array) |
| AFFILIATE_ADDRESSES_ARRAY | ARRAY | The affiliate addresses that are receiving the affiliate fee |
| AFFILIATE_FEE_BASIS_POINTS_ARRAY | ARRAY | The affiliate fee basis points that are received by the affiliate addresses |
| FROM_ASSET | TEXT | Initial asset to swap |
| TO_ASSET | TEXT | The asset swap to |
| FROM_AMOUNT | FLOAT | Amount of the asset to swap from |
| TO_AMOUNT | FLOAT | Amount of the asset to swap for |
| MIN_TO_AMOUNT | FLOAT | Minimal amount to swap for |
| FROM_AMOUNT_USD | FLOAT | Amount in USD of the asset to swap from |
| TO_AMOUNT_USD | FLOAT | Amount in USD of the asset to swap for |
| RUNE_USD | FLOAT | Minimal amount in USD to swap for |
| ASSET_USD | FLOAT | Asset amount in USD |
| TO_AMOUNT_MIN_USD | FLOAT | Min asset amount in USD |
| SWAP_SLIP_BP | NUMBER | The slippage during the swap process |
| LIQ_FEE_RUNE | FLOAT | The amount of RUNE liquidity fee paid in RUNE for the swaps |
| LIQ_FEE_RUNE_USD | FLOAT | The amount of RUNE in USD liquidity fee paid in RUNE for the swaps |
| LIQ_FEE_ASSET | FLOAT | The amount of Asset liquidity fee paid in RUNE for the swaps |
| LIQ_FEE_ASSET_USD | FLOAT | The amount of Asset in USD liquidity fee paid in RUNE for the swaps |
| STREAMING_COUNT | NUMBER | The count of the streaming events |
| STREAMING_QUANTITY | NUMBER | The quantity of the streaming events |
| _TX_TYPE | TEXT | |
| _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. |
