Query editor
-- ПараметрыWITH parameters AS (SELECTCAST('{{target_date}}' AS TIMESTAMP) AS target_date,'{{token_mint_address}}' AS target_token_mint),-- 1. Получаем ВСЕ уникальные пулы за целевую дату с агрегациейall_pools_aggregated AS (SELECTproject_program_id AS pool_address,project AS dex,-- Берем самый частый pool_typeMAX(version_name) AS pool_type,-- Для target токенаMAX(CASEWHEN token_bought_mint_address = (SELECT target_token_mint FROM parameters)THEN token_bought_vaultELSE token_sold_vaultEND) AS target_token_account,-- Для парного токена (SOL/USDC)MAX(CASEWHEN token_bought_mint_address IN ('So11111111111111111111111111111111111111112', -- SOL'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- USDC) THEN token_bought_vaultWHEN token_sold_mint_address IN ('So11111111111111111111111111111111111111112','EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v') THEN token_sold_vaultELSE NULLEND) AS paired_token_account,-- Символы токеновMAX(CASEWHEN token_bought_mint_address = (SELECT target_token_mint FROM parameters)THEN token_bought_symbolELSE token_sold_symbolEND) AS target_token_symbol,MAX(CASEWHEN token_bought_mint_address IN ('So11111111111111111111111111111111111111112','EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v') THEN token_bought_symbolWHEN token_sold_mint_address IN ('So11111111111111111111111111111111111111112','EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v') THEN token_sold_symbolELSE NULLEND) AS paired_token_symbol,-- Mint адреса токеновMAX(CASEWHEN token_bought_mint_address = (SELECT target_token_mint FROM parameters)THEN token_bought_mint_addressELSE token_sold_mint_addressEND) AS target_token_mint,