DEX Liquidity
The dex_liquidity table provides indexed views of all DEX liquidity for a specified chain.
Supported DEXs
| Base | ||||
|---|---|---|---|---|
| leetswap v2 | rocketswap v2 | damaswap v2 | uniswap v2 forks | solidly forkst |
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.