Skip to main content
Schema: monad.defi Table: ez_dex_liquidity_pool_actions Type: View

What

This table provides a comprehensive view of liquidity pool actions across major decentralized exchanges (DEXs) on EVM blockchains. Each row represents one token in a liquidity pool action. For example, if a user adds WETH and USDC to a pool, there will be 2 rows: one for WETH and one fo

Columns

Column NameData TypeDescription
AMOUNTFLOATDecimal-adjusted amount of the individual token in this a…
AMOUNT_UNADJFLOATRaw, non-decimal adjusted amount of the individual token …
AMOUNT_USDFLOATUSD value of the individual token amount at the time of t…
BLOCK_NUMBERNUMBERSequential counter representing the position of a block i…
BLOCK_TIMESTAMPTIMESTAMP_NTZUTC timestamp when the block was produced by validators/m…
DECIMALSTEXTThe number of decimal places for the individual token.
E… | | EVENT_INDEX | NUMBER | Zero-based sequential position of the event within a tran… | | EVENT_NAME | TEXT | The event name as defined in the contract’s ABI. **Forma… | | EZ_DEX_LIQUIDITY_POOL_ACTIONS_ID | TEXT | Primary key - unique identifier for each row ensuring dat… | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the record was first added to the Flip… | | LIQUIDITY_PROVIDER | TEXT | The address that is providing or removing liquidity from … | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp of the most recent update to this record. … | | PLATFORM | TEXT | The DEX protocol and version where the liquidity action o… | | POOL_ADDRESS | TEXT | The liquidity pool contract address where the action occu… | | POOL_NAME | TEXT | Human-readable name for the liquidity pool. Example: ‘WE… | | PROTOCOL | TEXT | The protocol used for the liquidity action. This is the c… | | PROTOCOL_VERSION | TEXT | The version of the protocol used for the liquidity action… | | RECEIVER | TEXT | The recipient address of the LP tokens or withdrawn asset… | | SENDER | TEXT | The address that initiated the liquidity pool action func… | | SYMBOL | TEXT | The symbol of the individual token. Example: ‘WETH’ | | TOKEN_ADDRESS | TEXT | The contract address of the individual token in this liqu… | | TOKEN_IS_VERIFIED | TEXT | Whether the individual token is verified in the Flipside … | | TX_HASH | TEXT | Unique 66-character identifier for the transaction. **Fo… |