stellar.defi Table: fact_trades Type: Base Table
What
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-structuresColumns
| Column Name | Data Type | Description |
|---|---|---|
| HISTORY_OPERATION_ID | NUMBER | HISTORY_OPERATION_ID column |
| TRADE_ORDER | NUMBER | TRADE_ORDER column |
| LEDGER_CLOSED_AT | TIMESTAMP_NTZ | LEDGER_CLOSED_AT column |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | BLOCK_TIMESTAMP column |
| SELLING_ACCOUNT_ADDRESS | TEXT | SELLING_ACCOUNT_ADDRESS column |
| SELLING_ASSET_CODE | TEXT | SELLING_ASSET_CODE column |
| SELLING_ASSET_ISSUER | TEXT | SELLING_ASSET_ISSUER column |
| SELLING_ASSET_TYPE | TEXT | SELLING_ASSET_TYPE column |
| SELLING_ASSET_ID | NUMBER | SELLING_ASSET_ID column |
| SELLING_AMOUNT | FLOAT | SELLING_AMOUNT column |
| BUYING_ACCOUNT_ADDRESS | TEXT | BUYING_ACCOUNT_ADDRESS column |
| BUYING_ASSET_CODE | TEXT | BUYING_ASSET_CODE column |
| BUYING_ASSET_ISSUER | TEXT | BUYING_ASSET_ISSUER column |
| BUYING_ASSET_TYPE | TEXT | BUYING_ASSET_TYPE column |
| BUYING_ASSET_ID | NUMBER | BUYING_ASSET_ID column |
| BUYING_AMOUNT | FLOAT | BUYING_AMOUNT column |
| PRICE_N | NUMBER | PRICE_N column |
| PRICE_D | NUMBER | PRICE_D column |
| SELLING_OFFER_ID | NUMBER | SELLING_OFFER_ID column |
| BUYING_OFFER_ID | NUMBER | BUYING_OFFER_ID column |
| BATCH_ID | TEXT | BATCH_ID column |
| BATCH_RUN_DATE | TIMESTAMP_NTZ | BATCH_RUN_DATE column |
| BATCH_INSERT_TS | TIMESTAMP_NTZ | BATCH_INSERT_TS column |
| SELLING_LIQUIDITY_POOL_ID | TEXT | SELLING_LIQUIDITY_POOL_ID column |
| LIQUIDITY_POOL_FEE | NUMBER | LIQUIDITY_POOL_FEE column |
| TRADE_TYPE | NUMBER | TRADE_TYPE column |
| ROUNDING_SLIPPAGE | NUMBER | ROUNDING_SLIPPAGE column |
| SELLER_IS_EXACT | BOOLEAN | SELLER_IS_EXACT column |
| FACT_TRADES_ID | TEXT | FACT_TRADES_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |