Query editor
WITHparams AS (SELECT'{{token_mint_address}}' AS token_mint_address,CAST('{{start_date}}' AS timestamp) AS start_date,CAST('{{end_date}}' AS timestamp) AS end_date,'{{time_interval}}' AS time_interval,'{{project_program_id}}' AS project_program_id_filter),-- Оптимизированный CTE: объединяем фильтрацию пулов и сделок в один шагfiltered_trades AS (SELECTt.*,CASEWHEN t.token_bought_mint_address = p.token_mint_address THEN t.token_sold_vaultELSE t.token_bought_vaultEND AS pool_address,CASEWHEN t.token_bought_mint_address = p.token_mint_address THEN 'BUY'WHEN t.token_sold_mint_address = p.token_mint_address THEN 'SELL'END AS trade_typeFROM dex_solana.trades tCROSS JOIN params pWHERE (t.token_bought_mint_address = p.token_mint_addressOR t.token_sold_mint_address = p.token_mint_address)AND t.block_time BETWEEN p.start_date AND p.end_dateAND (p.project_program_id_filter = 'All' OR t.project_program_id = p.project_program_id_filter)),-- Оптимизированные цены SOLsol_prices AS (SELECThour,price AS sol_price_usdFROM dex_solana.price_hourWHERE contract_address = 'So11111111111111111111111111111111111111112'AND hour BETWEEN (SELECT start_date FROM params) AND (SELECT end_date FROM params)),-- Основные расчетыtrade_data AS (SELECTft.project_program_id,ft.version_name,ft.pool_address,ft.project,ft.token_pair,CASEWHEN (SELECT time_interval FROM params) = 'hour' THENDATE_TRUNC('hour', ft.block_time)ELSEDATE_TRUNC('day', ft.block_time)END AS time_window,ft.trade_type,ft.amount_usd,-- Количество токеновCASEWHEN ft.trade_type = 'BUY' THEN ft.token_bought_amount