Skip to content

Dex Liquidity

The ethereum.dex_liquidity table provides indexed views of all DEX liquidity for the chain. All DEX liquidity tables follows the same database schema presented below.

Columns

Name Type Description
block_number integer The block number at which the event occurred.
category text The category of the event, one of (deposit, withdraw, or swap).
contract_address text The contract address of the DEX pool.
contract_version text The version of the exchange contract interacted with (e.g. v1 or v2).
exchange_name text The name of the exchange that facilitated the event.
liquidity numeric The total pool liquidity between the tick range post transaction (only Uniswap V3 and Kyber V3).
liquidity_delta numeric The change in the liquidity in the tick range (only Uniswap V3 and Kyber V3).
log_index integer The log index at which the event occurred.
lp_address text The address of the liquidity provider (null for swap events).
pool_balance numeric The DEX Pool's balance of token_address
position_id integer Unique position NFT ID for the tick range (only Uniswap V3 and Kyber V3).
position_liquidity numeric The total position liquidity for position_id post transaction (only Uniswap V3 and Kyber V3).
quantity numeric The quantity of the token_address (negative for withdrawals, swaps out).
sender_address text The address that initiated the event.
tick_lower numeric The bottom of the tick range (only Uniswap V3 and Kyber V3).
tick_upper numeric The top of the tick range (only Uniswap V3 and Kyber V3).
timestamp timestamp without time zone The timestamp at which the event occurred.
token_address text The token address whose pool balance was affected in the liquidity event.
transaction_hash text The transaction hash at which the event occurred.
__block_number integer The block number at which the event took place in.
__confirmed boolean Flag indicating whether the transfer has been confirmed.
__last_modified timestamp The date at which this row was last updated (in ISO-8601 format).

Supported Protocols

Protocol
1inch-v2 apeswap-v2 balancer-v1 balancer-v1-forks
balancer-v2 bancor-v1 bancor-v2 cityswap-v1
collection-v1 collection-v2 curve-metapool curve-tricrypto
curve-v1 curve-v2 defi-swap-v1 dfx-v1
dfx-v2 dodoswap-private dodoswap-stable dodoswap-v1
dodoswap-v2 elasticswap-v1 fraxswap-v1 fraxswap-v2
kyber-elastic kyber-v2 kyber-v3 maverick-v1
miniswap-v1 pancakeswap-v2 pancakeswap-v3 pendle-v2
saddle-finance-metapool saddle-finance-stableswap sakeswap-v1 sashimiswap-v1
shibaswap-v2 smardex-v1 solidly-v1 solidly-v1-forks
sudoswap-v1 sudoswap-v2 sushiswap-v1 sushiswap-v2
sushiswap-v3 synapse-v1 traderjoe-v2 unicly-v1
uniswap-v1 uniswap-v2 uniswap-v2-forks uniswap-v3
uniswap-v3-forks unsheth-v2 zkswap-v1 zkswap-v2

Indexes

Index
lp_address, timestamp, log_index
exchange_name, contract_version, timestamp, log_index
__last_modified
lp_address, contract_address, timestamp, log_index
position_id, timestamp, log_index
contract_address, position_id, timestamp, log_index
__indexer_id WHERE __confirmed = false
lp_address, token_address, timestamp, log_index
token_address, contract_address, timestamp, log_index
transaction_hash, log_index
exchange_name, timestamp, log_index
__indexer_id, __block_number
token_address, timestamp, log_index
timestamp, log_index
contract_address, token_address, block_number, log_index
contract_address, timestamp, log_index

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.