Query editor
-- Запрос 1: Находим активных трейдеров с большим объёмом (гарантированно рабочий)SELECTtx_from as wallet,COUNT(*) as tx_count,SUM(amount_usd) as total_volume,AVG(amount_usd) as avg_trade_size,COUNT(DISTINCT token_bought_symbol) as unique_tokensFROM dex.tradesWHERE block_time >= NOW() - INTERVAL '30' dayAND amount_usd > 1000GROUP BY 1HAVING SUM(amount_usd) > 1000000 AND COUNT(*) > 50ORDER BY total_volume DESCLIMIT 100