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

What

A comprehensive convenience table holding blockchain and platform specific liquidity pool actions, including deposits and withdrawals.

Columns

Column NameData TypeDescription
BLOCKCHAINTEXTBlockchain, Network, or Platform where the liquidity pool action occurred.
PLATFORMTEXTThe name of the dex or liquidity pool platform, typically a concatenation of the protocol and version.
PROTOCOLTEXTThe name of the protocol.
PROTOCOL_VERSIONTEXTThe version of the protocol.
BLOCK_NUMBERNUMBERAlso known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
TX_HASHTEXTTransaction hash is a unique identifier that is generated when a transaction is executed.
ACTIONTEXTThe name of the liquidity pool action or event (e.g., deposit, mint, addliquidity, withdrawal, burn, removeliquidity etc).
LIQUIDITY_PROVIDERTEXTThe address that provided or withdrew liquidity from the pool.
POOL_ADDRESSTEXTThe contract address of the liquidity pool where the action occurred.
POOL_NAMETEXTThe name of the liquidity pool, typically including the token pair.
TOKEN_ADDRESSTEXTThe address of the token involved in the action.
SYMBOLTEXTThe symbol of the token involved in the action.
DECIMALSNUMBERThe number of decimals for the token.
AMOUNT_RAWFLOATThe unadjusted amount of tokens involved in the action.
AMOUNTFLOATThe decimal adjusted amount of tokens involved in the action.
AMOUNT_USDFLOATThe amount of tokens involved in the action converted to USD.
TOKEN_IS_VERIFIEDBOOLEANIndicates whether the token has been verified.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.
EZ_DEX_LIQUIDITY_POOL_ACTIONS_IDTEXTThe unique identifier for each row in the table.