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 t0.symbol || '/' || t1.symbol,get_href('https://hyperevmscan.io/address/' || CAST(p.pool AS VARCHAR), t0.symbol || '/' || t1.symbol) AS liquidity_pool,p.pool AS pool_address,p.trade_countFROM pool_activity pLEFT JOIN tokens.erc20 t0 ON p.token0 = t0.contract_address AND t0.blockchain = 'hyperevm'LEFT JOIN tokens.erc20 t1 ON p.token1 = t1.contract_address AND t1.blockchain = 'hyperevm'WHERE p.trade_count > 0ORDER BY p.trade_count DESCLIMIT 20