| PLATFORM | TEXT | |
| BLOCK_ID | NUMBER | The block height the block was recorded at. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block began. |
| TX_SUCCEEDED | BOOLEAN | Transaction status is TRUE if the transaction was successful, FALSE if the transaction failed. |
| TX_ID | TEXT | A unique key that identifies a transaction. Called “TxHash” on block explorers. |
| MSG_GROUP | NUMBER | Value grouping different messages together to represent a single action. Format will include the numeric msg_group and msg_sub_group with a ”:” seperator. The subgroup will always be 0 except for “Exec” actions. NULL group means messages are related to the header (overall transaction) |
| MSG_SUB_GROUP | NUMBER | Silver only — Numeric value grouping different messages together to represent a single action within a group. This is relevent for exec actions that contain mutiple underlying actions. NULL sub group means messages are related to the header (overall transaction) |
| MSG_INDEX | NUMBER | Short for “message index,” the position in which messages occur in a transaction. |
| LIQUIDITY_PROVIDER_ADDRESS | TEXT | The address that took an action on the pool. |
| LP_ACTION | TEXT | The action that the liquidity provider took. The value is one of the following: add_liquidity,remove_liquidity |
| POOL_ADDRESS | TEXT | Address of the pool |
| POOL_NAME | TEXT | The name of the pool |
| TOKEN1_AMOUNT | FLOAT | The amount of the first token provided by the liquidity provider |
| TOKEN1_CURRENCY | TEXT | The currency of the first token provided by the liquidity provider |
| TOKEN2_AMOUNT | NUMBER | The amount of the second token provided by the liquidity provider |
| TOKEN2_CURRENCY | TEXT | The currency of the second token provided by the liquidity provider |
| LP_TOKEN_ADDRESS | TEXT | The address of LP tokens that were added, removed, bonded, or unbonded from the pool. |
| _INSERTED_TIMESTAMP | TIMESTAMP_LTZ | |
| FACT_LP_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. |
