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