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 |
| solidly-v3 | 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.