DEX
Pools
Coming Soon
We’re actively working on expanding our DEX pools coverage to other chains like Ink. If you’d like to request support for ink, please reach out to our team.
The dex.pools table contains liquidity pools of DEX protocols indexed by Allium, consolidated into a single table.
Protocols indexed by Allium:
- velodrome_protocol, uniswap_v3_protocol, uniswap_v2_protocol,
Table Columns
Unique Key: liquidity_pool_address
| Column | Data Type | Description |
|---|---|---|
| project | VARCHAR | The project or platform name |
| protocol | VARCHAR | The specific protocol or version used |
| liquidity_pool_address | VARCHAR | The address of the liquidity pool |
| token0_address | VARCHAR | The address of the first token in the pair |
| token0_name | VARCHAR | The name of the first token |
| token0_symbol | VARCHAR | The symbol of the first token |
| token0_decimals | BIGINT | The number of decimal places for the first token |
| token1_address | VARCHAR | The address of the second token in the pair |
| token1_name | VARCHAR | The name of the second token |
| token1_symbol | VARCHAR | The symbol of the second token |
| token1_decimals | BIGINT | The number of decimal places for the second token |
| tokens_array | ARRAY | An array containing the addresses of all tokens for pools with more than two tokens |
| fee | BIGINT | The fee associated with the pool |
| tick_spacing | VARCHAR | The spacing between ticks in the pool |
| factory_address | VARCHAR | The address of the factory contract that created the pool |
| extra_fields | VARIANT | Additional fields emitted in pool creation in JSON format |
| transaction_hash | VARCHAR | The hash of the transaction (*null for seed pools) |
| transaction_index | BIGINT | The index of the transaction within the block (*null for seed pools) |
| log_index | BIGINT | The index of the log entry within the transaction (*null for seed pools) |
| trace_id | VARCHAR | The ID of the trace (if applicable) |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block |
| block_number | BIGINT | The number of the block |
| block_hash | VARCHAR | The hash of the block |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when the record was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when the record was last updated |