| owner | Address of the liquidity position owner | varchar | HYco5pWjQTatiSJAT97XSBrv4hqtreThFA58ZDrTCNLZ |
| position | The liquidity position address | varchar | Gh3UP8uvSLkyiRo94sEUdh5pCNYpS4WLbJ2evsGTmR71 |
| pool | The liquidity pool address | varchar | HTvjzsfX3yU6BUodCjZ5vZkUrAxMDTrBs3CJaq43ashR |
| project | The DEX project | varchar | meteora |
| protocol | The protocol used by the DEX project | varchar | meteora-dlmm |
| token0 | Token0’s mint address | varchar | So11111111111111111111111111111111111111112 |
| token1 | Token1’s mint address | varchar | EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v |
| token0_symbol | Token0’s symbol, if available | varchar | SOL |
| token1_symbol | Token1’s symbol, if available | varchar | USDC |
| add_liquidity_amount0 | Total amount of token0 added to position | float | 10.5 |
| add_liquidity_amount1 | Total amount of token1 added to position | float | 1050.0 |
| add_liquidity_usd_amount0 | USD value of token0 added to position | float | 1055.25 |
| add_liquidity_usd_amount1 | USD value of token1 added to position | float | 1050.00 |
| add_liquidity_usd_amount_total | Total USD value of liquidity added | float | 2105.25 |
| remove_liquidity_amount0 | Total amount of token0 removed from position | float | 8.0 |
| remove_liquidity_amount1 | Total amount of token1 removed from position | float | 800.0 |
| remove_liquidity_usd_amount0 | USD value of token0 removed from position | float | 804.00 |
| remove_liquidity_usd_amount1 | USD value of token1 removed from position | float | 800.00 |
| remove_liquidity_usd_amount_total | Total USD value of liquidity removed | float | 1604.00 |
| claim_fee_amount0 | Total amount of token0 fees claimed | float | 0.1 |
| claim_fee_amount1 | Total amount of token1 fees claimed | float | 10.0 |
| claim_fee_usd_amount0 | USD value of token0 fees claimed | float | 10.05 |
| claim_fee_usd_amount1 | USD value of token1 fees claimed | float | 10.00 |
| claim_fee_usd_amount_total | Total USD value of fees claimed | float | 20.05 |
| rebalancing_amount0 | Total amount of token0 from rebalancing | float | 2.0 |
| rebalancing_amount1 | Total amount of token1 from rebalancing | float | 200.0 |
| rebalancing_usd_amount0 | USD value of token0 from rebalancing | float | 201.00 |
| rebalancing_usd_amount1 | USD value of token1 from rebalancing | float | 200.00 |
| rebalancing_usd_amount_total | Total USD value of rebalancing | float | 401.00 |
| add_liquidity_count | Number of add liquidity events | number | 5 |
| remove_liquidity_count | Number of remove liquidity events | number | 3 |
| claim_fee_count | Number of claim fee events | number | 2 |
| rebalancing_count | Number of rebalancing events | number | 1 |
| create_position_count | Number of create position events | number | 1 |
| close_position_count | Number of close position events | number | 1 |
| usd_amount_net_gain | Net USD gain/loss for the position | float | 521.30 |
| open_timestamp | Timestamp when position was created | timestamp_ntz(9) | 2023-11-07 05:11:45+00:00 |
| open_txn_id | Transaction ID of position creation | varchar | 4GCpQa7BVefNiwhrB9QhSha4ZLMmQBdYgWTVXwspreBQhx7zdm1a1cTsgW6zjGdqdJH64fxXEiBZY1j5jD5aGgjb |
| close_timestamp | Timestamp when position was closed | timestamp_ntz(9) | 2023-11-15 10:30:22+00:00 |
| close_txn_id | Transaction ID of position closure | varchar | 5HDpQa7BVefNiwhrB9QhSha4ZLMmQBdYgWTVXwspreBQhx7zdm1a1cTsgW6zjGdqdJH64fxXEiBZY1j5jD5aGgjb |
| is_closed | Whether the position has been closed | boolean | true |
| duration_seconds | Position duration in seconds | number | 691357 |
| price_usd_token0_at_open | Token0 price in USD when position opened | varchar | 100.50 |
| price_usd_token1_at_open | Token1 price in USD when position opened | varchar | 1.00 |
| price_usd_token0_at_close | Token0 price in USD when position closed | varchar | 102.30 |
| price_usd_token1_at_close | Token1 price in USD when position closed | varchar | 1.00 |
