DEX Liquidity

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

Supported DEXs

Nova
arbswap	archly	rcpswap	sushiswap	uniswap

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.