Query editor
WITH params AS (SELECT'{{token_address}}' AS token_address,CAST('{{start_date}}' AS TIMESTAMP) AS start_date,CAST('{{end_date}}' AS TIMESTAMP) AS end_date),-- ============================================-- ЧАСТЬ 1: DLMM POOLS (Meteora)-- ============================================-- Находим все DLMM пулы с участием целевого токенаdlmm_pools AS (SELECTlbPair AS pool_address,tokenX,tokenY,binStep,'DLMM' AS programFROM meteora_solana.lb_clmm_evt_lbpaircreateWHERE tokenX = (SELECT token_address FROM params)OR tokenY = (SELECT token_address FROM params)),-- Получаем информацию о токенах для DLMMdlmm_token_info AS (SELECTcontract_address,symbol,decimalsFROM (SELECTcontract_address,symbol,decimals,ROW_NUMBER() OVER (PARTITION BY contract_address ORDER BY hour DESC) as rnFROM dex_solana.price_hourWHERE contract_address IN (SELECT tokenX FROM dlmm_poolsUNION ALLSELECT tokenY FROM dlmm_pools))WHERE rn = 1),-- Суммируем операции добавления для DLMM за периодdlmm_add_operations AS (SELECTpc.lbPair AS pool_address,SUM(CAST(al.amounts[1] AS DOUBLE)) AS total_add_x_raw,SUM(CAST(al.amounts[2] AS DOUBLE)) AS total_add_y_rawFROM meteora_solana.lb_clmm_evt_addliquidity alINNER JOIN meteora_solana.lb_clmm_evt_positioncreate pcON al.position = pc.positionINNER JOIN dlmm_pools dpON pc.lbPair = dp.pool_addressWHERE al.evt_block_time >= (SELECT start_date FROM params)AND al.evt_block_time <= (SELECT end_date FROM params)GROUP BY pc.lbPair