Query editor
WITH-- Находим пулы с китовыми транзакциями (>5000 USD) в выбранный периодwhale_pools AS (SELECT DISTINCTproject_program_id as pool_address,-- Для случая 'All' определяем целевой токенCASEWHEN '{{token_address}}' != 'All' THEN '{{token_address}}'WHEN amount_usd > 5000 THEN token_bought_mint_addressELSE token_sold_mint_addressEND as target_token_address,CASEWHEN '{{token_address}}' != 'All' AND token_bought_mint_address = '{{token_address}}' THEN token_bought_symbolWHEN '{{token_address}}' != 'All' AND token_sold_mint_address = '{{token_address}}' THEN token_sold_symbolWHEN amount_usd > 5000 THEN token_bought_symbolELSE token_sold_symbolEND as target_token_symbol,token_bought_mint_address,token_sold_mint_address,token_bought_symbol,token_sold_symbol,project,version,token_pairFROM dex_solana.tradesWHEREblock_time >= CAST('{{start_date}}' AS timestamp)AND block_time < CAST('{{end_date}}' AS timestamp)AND amount_usd > 5000-- ДОБАВЛЕНО: при конкретном токене — только сделки с его участиемAND ('{{token_address}}' = 'All'OR token_bought_mint_address = '{{token_address}}'OR token_sold_mint_address = '{{token_address}}')),-- Получаем USD цены для ВСЕХ токенов в выбранный период - ПРАВИЛЬНАЯ ЛОГИКАhourly_prices_with_ranking AS (SELECTDATE_TRUNC('{{time_interval}}', hour) as date,contract_address as token_address,symbol,hour,price,ROW_NUMBER() OVER (PARTITION BY DATE_TRUNC('{{time_interval}}', hour), contract_addressORDER BY hour ASC) as hour_rank_asc,ROW_NUMBER() OVER (PARTITION BY DATE_TRUNC('{{time_interval}}', hour), contract_addressORDER BY hour DESC) as hour_rank_descFROM dex_solana.price_hourWHEREhour >= CAST('{{start_date}}' AS timestamp)AND hour < CAST('{{end_date}}' AS timestamp)-- ДОБАВЛЕНО: при конкретном токене — только его ценыAND ('{{token_address}}' = 'All'