This table contains DEX trades on Stellar blockchain. It includes hydrated trade data with token metadata, pricing information, and USD value calculations for both tokens involved in each swap on Stellar’s decentralized exchanges.Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
Table Columns
Unique Key:unique_id
| Column Name | Description |
|---|---|
| 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 |