stellar.defi Table: fact_trades Type: Base Table
This table reports trading activity that occurs in both the decentralized exchange and automated
money markets. Trades fulfill one of four operations: manage buy offers, manage sell offers and path
payments (strict send and receive). Trades can be executed either against the orderbook or a
liquidity pool that contains both bid and ask asset pair. Trades can be either path payments or
offers that are fully or partially fulfilled, which means that the trade can be split into segments.
A full trade is compromised of all “order” numbers for a given history_operation_id.
Learn more about Stellar data concepts:
https://developers.stellar.org/docs/learn/fundamentals/stellar-data-structures
Columns
| Column Name | Data Type | Description |
|---|---|---|
| HISTORY_OPERATION_ID | NUMBER | |
| TRADE_ORDER | NUMBER | |
| LEDGER_CLOSED_AT | TIMESTAMP_NTZ | |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | |
| SELLING_ACCOUNT_ADDRESS | TEXT | |
| SELLING_ASSET_CODE | TEXT | |
| SELLING_ASSET_ISSUER | TEXT | |
| SELLING_ASSET_TYPE | TEXT | |
| SELLING_ASSET_ID | NUMBER | |
| SELLING_AMOUNT | FLOAT | |
| BUYING_ACCOUNT_ADDRESS | TEXT | |
| BUYING_ASSET_CODE | TEXT | |
| BUYING_ASSET_ISSUER | TEXT | |
| BUYING_ASSET_TYPE | TEXT | |
| BUYING_ASSET_ID | NUMBER | |
| BUYING_AMOUNT | FLOAT | |
| PRICE_N | NUMBER | |
| PRICE_D | NUMBER | |
| SELLING_OFFER_ID | NUMBER | |
| BUYING_OFFER_ID | NUMBER | |
| BATCH_ID | TEXT | |
| BATCH_RUN_DATE | TIMESTAMP_NTZ | |
| BATCH_INSERT_TS | TIMESTAMP_NTZ | |
| SELLING_LIQUIDITY_POOL_ID | TEXT | |
| LIQUIDITY_POOL_FEE | NUMBER | |
| TRADE_TYPE | NUMBER | |
| ROUNDING_SLIPPAGE | NUMBER | |
| SELLER_IS_EXACT | BOOLEAN | |
| FACT_TRADES_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ |