Skip to content

DEX Liquidity

The dex_liquidity table provides indexed views of all DEX liquidity for a specified chain.

Supported DEXs

Arbitrum
3xcalibur arbether arbiswap arbswap balancer
curve dodoswap elkswap gumball hop
magicswap owlswap raidswap solidlizard solidly
sushiswap swapfish swapr synapse traderjoe
zyberswap

Columns

Name Description Type
block_number The block number at which the event occurred. integer
log_index The timestamp at which the event occurred. integer
transaction_hash The transaction hash of the event. text
timestamp The timestamp at which the event occurred. timestamp
exchange_name The name of the exchange that the event occurred on. text
contract_version The version of the exchange contract interacted with (e.g. v1 or v2). text
contract_address The contract address of the DEX pool. text
token_address The address of the token. string
pool_balance The balance of the DEX pool. integer
category The category of the event, one of (deposit, withdraw, or swap). text
lp_address The address of the liquidity provider (null for swap events). text
quantity The quantity of tokens. integer
tick_lower The lower tick of the event. integer
tick_upper The upper tick of the event. integer
sender_address The address that initiated the event. text

Indexes

The following indexes are available for this table:

(timestamp, log_index)
(transaction_hash, log_index)
(token_address, timestamp, log_index)
(token_address, contract_address, timestamp, log_index)
(contract_address, timestamp, log_index)
(contract_address, token_address, timestamp, log_index)
(lp_address, token_address, timestamp, log_index)
(lp_address, 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.