Query editor
WITH params AS (SELECTCASEWHEN '{{token_mint_address}}' = 'All' THEN NULLELSE '{{token_mint_address}}'END AS token_mint_address,CASEWHEN '{{owner}}' = 'All' THEN NULLELSE '{{owner}}'END AS owner_address,'{{status}}' AS status_filter),-- Находим пулы где участвует нужный токенrelevant_pools AS (SELECTlbPair AS pool_address,binStep,tokenX,tokenYFROM meteora_solana.lb_clmm_evt_lbpaircreateWHERE (SELECT token_mint_address FROM params) IS NULLOR 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 (SELECT token_mint_address FROM params) IS NOT NULL THENCASEWHEN rp.tokenX = (SELECT token_mint_address FROM params) THEN 'X'ELSE 'Y'ENDELSE 'X' -- В режиме All показываем цены для токена X по умолчанию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 (SELECT owner_address FROM params) IS NULLOR pc.owner = (SELECT owner_address FROM params)),-- ОПЕРАЦИИ ДОБАВЛЕНИЯ (ADD) - отдельная агрегацияadd_operations AS (SELECTposition,SUM(CAST(amounts[1] AS DOUBLE)) as add_x_raw,