DEX
Liquidity Events
This table contains transaction-level information about events that modify liquidity positions across various DEX protocols on Solana.
solana.dex.liquidity_events tracks transaction-level events that modify liquidity positions and covers the following actions:
- add - Adding liquidity to a position
- remove - Removing liquidity from a position
- rebalance - Rebalancing a liquidity position
- claim_fee - Claiming fees from a liquidity position
- create_position - Creating a new liquidity position
- close_position - Closing an existing liquidity position
Supported Protocols
The table currently includes the following DEX protocols:| Project | Protocol |
|---|---|
| meteora | meteora-dlmm |
Table Columns
| Column Name | Description | Type | Example |
|---|---|---|---|
| project | The DEX project | varchar(7) | meteora |
| protocol | The protocol used by the DEX project | varchar | meteora-dlmm |
| owner | Address of the liquidity position owner | varchar | HYco5pWjQTatiSJAT97XSBrv4hqtreThFA58ZDrTCNLZ |
| pool | The liquidity pool address | varchar | HTvjzsfX3yU6BUodCjZ5vZkUrAxMDTrBs3CJaq43ashR |
| position | The liquidity position address | varchar | Gh3UP8uvSLkyiRo94sEUdh5pCNYpS4WLbJ2evsGTmR71 |
| token0 | Token0’s mint address | varchar | So11111111111111111111111111111111111111112 |
| token1 | Token1’s mint address | varchar | EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v |
| raw_delta0 | Raw amount change for token0 | varchar | 1000000000 |
| raw_delta1 | Raw amount change for token1 | varchar | 1000000 |
| action | The liquidity position action performed. Choices are create_position, close_position, add_liquidity, remove_liquidity, claim_fee, rebalancing | varchar | add |
| block_slot | Block slot of the transaction | number | 228499898 |
| block_height | Block height of the transaction | number | 210416091 |
| block_timestamp | Block timestamp of the transaction | timestamp_ntz(9) | 2023-11-07 05:11:45+00:00 |
| block_hash | Block hash of the transaction | varchar | BNCv6p7EYHwGUNop1kACfTgA9Km6mc8LbSHJq5B9HEA2 |
| txn_id | Transaction ID | varchar(88) | 4GCpQa7BVefNiwhrB9QhSha4ZLMmQBdYgWTVXwspreBQhx7zdm1a1cTsgW6zjGdqdJH64fxXEiBZY1j5jD5aGgjb |
| txn_index | Transaction index within the block | number | 51 |
| instruction_index | Instruction index within the transaction | number | 0 |
| inner_instruction_index | Inner instruction index within the parent instruction | number | 0 |
| token0_symbol | Token0’s symbol, if available | varchar | SOL |
| token1_symbol | Token1’s symbol, if available | varchar | USDC |
| token0_decimals | Token0’s decimal places | number | 9 |
| token1_decimals | Token1’s decimal places | number | 6 |
| delta0 | Normalized amount change for token0 | float | 1.0 |
| delta1 | Normalized amount change for token1 | float | 100.0 |
| token0_price_usd | Token0 price in USD at the time of the event | float | 100.50 |
| token1_price_usd | Token1 price in USD at the time of the event | float | 1.00 |
| delta0_usd | USD value of token0 amount change | float | 100.50 |
| delta1_usd | USD value of token1 amount change | float | 100.00 |
| usd_amount_total | Total USD value of the liquidity event | float | 200.50 |