Query editor
WITH params AS (SELECTCAST('{{start_date}}' AS timestamp) AS start_date,CAST('{{end_date}}' AS timestamp) AS end_date,'{{token_mint_address}}' AS token_mint_address,{{min_total_liquidity_usd}} AS min_total_liquidity_usd),-- Находим все пулы где участвует нужный токен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)),-- Собираем все события добавления ликвидности для этих пуловliquidity_adds AS (SELECTal.evt_block_time,al.lbPair AS pool_address,pc.owner,al.position,rp.binStep,rp.tokenX,rp.tokenY,CAST(al.amounts[1] AS DOUBLE) AS amount_x_raw,CAST(al.amounts[2] AS DOUBLE) AS amount_y_rawFROM meteora_solana.lb_clmm_evt_addliquidity alINNER JOIN relevant_pools rp ON al.lbPair = rp.pool_addressLEFT JOIN meteora_solana.lb_clmm_evt_positioncreate pc ON al.position = pc.positionWHERE al.evt_block_time >= (SELECT start_date FROM params)AND al.evt_block_time < (SELECT end_date FROM params)),-- Получаем последние цены токенов за периодlatest_token_prices AS (SELECTcontract_address,symbol,decimals,price AS latest_priceFROM (SELECTcontract_address,symbol,decimals,price,hour,ROW_NUMBER() OVER (PARTITION BY contract_address ORDER BY hour DESC) as rnFROM dex_solana.price_hourWHERE contract_address IN (SELECT token_mint_address FROM paramsUNION ALLSELECT tokenX FROM relevant_poolsUNION ALL