Query editor
WITH pool_info AS(SELECT pool,token0,token1FROM prjx_hyperevm.uniswapv3factory_evt_poolcreated),dex_trades AS(SELECT project_contract_address AS pool,COUNT(*) AS trade_countFROM dex.tradesWHERE 1=1AND blockchain = 'hyperevm'AND project = 'prjx'AND block_time >= NOW() - INTERVAL '14' DAYGROUP BY project_contract_address),pool_activity AS (SELECT p.pool,COALESCE(t.trade_count, 0) AS trade_count,p.token0,p.token1FROM pool_info pLEFT JOIN dex_trades t ON p.pool = t.pool)SELECT COUNT_IF(trade_count > 0) AS active_pools,COUNT(*) AS total_pools,ROUND(100.0 * COUNT_IF(trade_count > 0) / COUNT(*), 2) AS active_ratioFROM pool_activity