Table Details
| Property | Value |
|---|---|
| Table Name | solana.dex.pools |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, txn_id, unique_id |
solana.dex.pools currently includes the following dex/protocols
| Project | Protocol |
|---|---|
| invariant | invariant |
| lifinity | lifinity-v2 |
| meteora | meteora-dlmm |
| orca | orca-v2, orca-whirlpool, orca-whirlpool-v2 |
| phoenix | phoenix |
| pumpswap | pumpswap |
| raydium | raydium-v4, raydium-cp, raydium-clmm |
| saber | saber-stableswap |
Pools Fees
For now, information on pools fees are only available for raydium-v4, raydium-cp, raydium-clmm, pumpswap, orca-whirlpool, orca-whirlpool-v2.Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR(16777216) | The dex project |
| protocol | VARCHAR(16777216) | The protocol used by the dex project |
| liquidity_pool_address | VARCHAR(44) | The liquidity pool address |
| token0_address | VARCHAR(44) | Token0’s mint address |
| token0_symbol | VARCHAR(16777216) | Token0’s symbol, if available |
| token0_decimals | NUMBER(38,0) | Token0’s decimal, if available |
| token0_vault | VARCHAR(44) | Token account that holds token0 |
| token1_address | VARCHAR(44) | Token1’s mint address |
| token1_symbol | VARCHAR(16777216) | Token1’s symbol, if available |
| token1_decimals | NUMBER(38,0) | Token1’s decimal, if available |
| token1_vault | VARCHAR(44) | Token account that holds token1 |
| trade_fee_bps | NUMBER(38,0) | fees (in bps) that the a swapper pays for the swap, excluding transaction gas fees |
| lp_share_bps | NUMBER(38,0) | out of the fees paid, the share (in bps) paid to the liquidity pool providers |
| treasury_share_bps | NUMBER(38,0) | out of the fees paid, the share (in bps) paid to the treasury |
| protocol_share_bps | NUMBER(38,0) | out of the fees paid, the share (in bps) paid to the protocol |
| pool_creation_fee_lamports | VARCHAR(16777216) | Fee paid in lamports to initialize this liquidity pool. |
| block_slot | NUMBER(38,0) | Block slot of the txn |
| block_height | NUMBER(38,0) | Block height of the txn |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the txn |
| block_hash | VARCHAR(44) | Block hash of the txn |
| txn_id | VARCHAR(88) | Txn id of the txn |
| txn_index | NUMBER(38,0) | Txn index of the txn |
| instruction_index | NUMBER(38,0) | Instruction index of the instruction |
| inner_instruction_index | NUMBER(38,0) | Inner instruction index of the instruction, within its parent instruction |
| unique_id | VARCHAR(16777216) | unique id of the pool creation record |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |