thorchain.defi Table: fact_pending_liquidity_events Type: Base Table
Fact table that provides the summary of the gas events for each block
Columns
| Column Name | Data Type | Description |
|---|---|---|
| FACT_PENDING_LIQUIDITY_EVENTS_ID | TEXT | The surrogate key for the table. Will be unique and is used as a foreign key in other tables |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | Timestamp of block minting(without a timezone) |
| DIM_BLOCK_ID | TEXT | FK to DIM_BLOCK table |
| POOL_NAME | TEXT | Name of the pool — also asset name in other tables |
| ASSET_TX_ID | TEXT | The unique transaction id for the rune event, the liquidity type can be add/remove the rune/asset, if the event related to rune |
| ASSET_BLOCKCHAIN | TEXT | The blockchain of the asset |
| ASSET_ADDRESS | TEXT | The address of asset |
| ASSET_E8 | NUMBER | The amount of asset for the liquidity events |
| RUNE_TX_ID | TEXT | The unique transaction id for the rune event, the liquidity type can be add/remove the rune/asset, if the event related to rune |
| RUNE_ADDRESS | TEXT | The address of rune |
| RUNE_E8 | NUMBER | The amount of rune for the liquidity events |
| PENDING_TYPE | TEXT | The type of liquidity, can be ‘add’ or ‘withdraw’ |
| _INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| _AUDIT_RUN_ID | TEXT | |
| 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. |