Query editor
WITH params AS (SELECT'{{token_mint_address}}' AS token_mint_address,'{{owner}}' AS owner_address),-- Находим пулы где участвует нужный токенrelevant_pools AS (SELECTlbPair AS pool_address,binStep,tokenX,tokenYFROM meteora_solana.lb_clmm_evt_lbpaircreateWHERE tokenX = (SELECT token_mint_address FROM params)OR tokenY = (SELECT token_mint_address FROM params)),-- Получаем ВСЕ позиции владельца с on-chain даннымиowner_positions_with_data AS (SELECTpc.position,pc.lbPair AS pool_address,pc.evt_block_time AS created_date,pc.owner,rp.binStep,rp.tokenX,rp.tokenY,ip.lowerBinId,ip.width,ip.lowerBinId + ip.width - 1 as upperBinId,CASEWHEN rp.tokenX = (SELECT token_mint_address FROM params) THEN 'X'ELSE 'Y'END AS target_token_sideFROM meteora_solana.lb_clmm_evt_positioncreate pcINNER JOIN relevant_pools rp ON pc.lbPair = rp.pool_addressLEFT JOIN meteora_solana.lb_clmm_call_initializeposition ipON pc.position = ip.account_positionWHERE pc.owner = (SELECT owner_address FROM params)),-- ОПЕРАЦИИ ДОБАВЛЕНИЯ (ADD) - отдельная агрегацияadd_operations AS (SELECTposition,SUM(CAST(amounts[1] AS DOUBLE)) as add_x_raw,SUM(CAST(amounts[2] AS DOUBLE)) as add_y_raw,COUNT(*) as add_countFROM meteora_solana.lb_clmm_evt_addliquidityWHERE "from" = (SELECT owner_address FROM params)GROUP BY position),-- ОПЕРАЦИИ ВЫВОДА (REMOVE) - отдельная агрегацияremove_operations AS (SELECTposition,SUM(CAST(amounts[1] AS DOUBLE)) as remove_x_raw,SUM(CAST(amounts[2] AS DOUBLE)) as remove_y_raw,