Query editor
WITH-- 1. ФИЛЬТР ПО ДАТАМ СРАЗУ - partition pruningfiltered_dates AS (SELECTCAST('{{start_date}}' AS timestamp) as start_date,CAST('{{end_date}}' AS timestamp) as end_date,DATE_TRUNC('{{time_interval}}', CAST('{{start_date}}' AS timestamp)) as truncated_start,DATE_TRUNC('{{time_interval}}', CAST('{{end_date}}' AS timestamp)) as truncated_end),-- 2. ТОЛЬКО НУЖНЫЕ КОЛОНКИ из trades (только для китов >5000)initial_trades_whales AS (SELECTproject_program_id as pool_address,token_bought_mint_address,token_sold_mint_address,token_bought_symbol,token_sold_symbol,token_bought_vault,token_sold_vault,project,version,token_pair,block_time,block_date,amount_usd,trader_idFROM dex_solana.tradesWHERE block_date >= DATE_TRUNC('day', CAST('{{start_date}}' AS timestamp))AND block_date < DATE_TRUNC('day', CAST('{{end_date}}' AS timestamp)) + INTERVAL '1' dayAND amount_usd > 5000AND ('{{token_address}}' = 'All'OR token_bought_mint_address = '{{token_address}}'OR token_sold_mint_address = '{{token_address}}')),-- 2a. ВСЕ СДЕЛКИ (включая <5000) для общих объемовall_trades AS (SELECTproject_program_id as pool_address,token_bought_mint_address,token_sold_mint_address,token_bought_symbol,token_sold_symbol,token_bought_vault,token_sold_vault,project,version,token_pair,block_time,block_date,amount_usd,trader_idFROM dex_solana.tradesWHERE block_date >= DATE_TRUNC('day', CAST('{{start_date}}' AS timestamp))AND block_date < DATE_TRUNC('day', CAST('{{end_date}}' AS timestamp)) + INTERVAL '1' dayAND ('{{token_address}}' = 'All'OR token_bought_mint_address = '{{token_address}}'OR token_sold_mint_address = '{{token_address}}')),