aleo.defi Table: fact_liquidity_pool_actions Type: Base Table
Records of all liquidity pool actions on Aleo, including adding and removing liquidity.
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. |
| ROOT_ACTION | TEXT | The program and function that initiated the liquidity pool action |
| LIQUIDITY_ACTION | TEXT | The type of liquidity action performed (e.g., add, remove) |
| LIQUIDITY_PROVIDER | TEXT | The address that performed the liquidity pool action |
| TOKEN1_ID | TEXT | The token id of the first token in the liquidity pair |
| TOKEN1_SYMBOL | TEXT | The symbol of the first token in the liquidity pair |
| TOKEN1_AMOUNT_UNADJ | NUMBER | The amount of the first token added or removed from the pool, unadjusted for decimals |
| TOKEN1_AMOUNT | FLOAT | The amount of the first token added or removed from the pool, adjusted for decimals |
| TOKEN2_ID | TEXT | The token id of the second token in the liquidity pair |
| TOKEN2_SYMBOL | TEXT | The symbol of the second token in the liquidity pair |
| TOKEN2_AMOUNT_UNADJ | NUMBER | The amount of the second token added or removed from the pool, unadjusted for decimals |
| TOKEN2_AMOUNT | FLOAT | The amount of the second token added or removed from the pool, adjusted for decimals |
| LIQUIDITY_POOL_PROTOCOL | TEXT | The liquidity pool protocol related to the action |
| FACT_LIQUIDITY_POOL_ACTIONS_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 |