| project | The DEX protocol name (e.g., Soroswap) |
| protocol | The protocol identifier |
| contract_id | The contract address for the DEX protocol |
| liquidity_pool_address | The address of the liquidity pool where the trade was executed |
| sender_address | The address that initiated the trade |
| to_address | The recipient address (typically null for direct swaps) |
| token_sold_asset_id | The Stellar asset ID of the token being sold (format asset_code:issuer) |
| token_sold_asset_code | The asset code of the token being sold |
| token_sold_decimals | The number of decimal places for the sold token |
| token_sold_amount_raw | The raw amount of tokens sold (before normalization) |
| token_sold_amount | The normalized amount of tokens sold |
| usd_sold_amount | The USD value of tokens sold (null if exceeds upper limit) |
| token_bought_asset_id | The Stellar asset ID of the token being bought (format asset_code:issuer) |
| token_bought_asset_code | The asset code of the token being bought |
| token_bought_decimals | The number of decimal places for the bought token |
| token_bought_amount_raw | The raw amount of tokens bought (before normalization) |
| token_bought_amount | The normalized amount of tokens bought |
| usd_bought_amount | The USD value of tokens bought (null if exceeds upper limit) |
| usd_amount | The USD value of the trade (prefers USD token pairs, falls back to available prices) |
| extra_fields | Additional metadata stored as a JSON variant object |
| ledger_sequence | The ledger sequence number containing this trade |
| ledger_close_time | The timestamp when the ledger containing this trade closed |
| ledger_hash | The hash of the ledger containing this trade |
| transaction_hash | The hash of the transaction containing this trade |
| transaction_index | The index of the transaction within the ledger |
| transaction_result | The result code of the transaction |
| unique_id | A unique identifier for this trade record |
| _created_at | Timestamp when the record was created in the warehouse |
| _updated_at | Timestamp when the record was last updated in the warehouse |
| _changed_since_full_refresh | Flag indicating if the record has changed since the last full refresh |
