aleo.defi Table: fact_swaps Type: Base Table
Records of all swap transactions on Aleo, including both public and private swaps.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The timestamp at which the block began. |
| BLOCK_ID | NUMBER | The block height the block was recorded at. |
| TX_ID | TEXT | The unique identifier for the transaction. |
| SUCCEEDED | BOOLEAN | A boolean value indicating if the event succeeded. |
| SWAPPER | TEXT | The address that initiated the swap |
| FROM_AMOUNT_UNADJ | FLOAT | The amount of tokens input into the swap, unadjusted for decimals |
| FROM_AMOUNT | FLOAT | The amount of tokens input into the swap, adjusted for decimals |
| FROM_SYMBOL | TEXT | The token being swapped from |
| FROM_ID | TEXT | The token id being swapped from |
| TO_AMOUNT_UNADJ | FLOAT | The amount of tokens received from the swap, unadjusted for decimals |
| TO_AMOUNT | FLOAT | The amount of tokens received from the swap, adjusted for decimals |
| TO_SYMBOL | TEXT | The token being swapped to |
| TO_ID | TEXT | The token id being swapped to |
| ROOT_ACTION | TEXT | The program and function that initiated the swap |
| PLATFORM | TEXT | The name of the protocol where the swap occurred |
| FACT_SWAPS_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |
| _INVOCATION_ID | TEXT |