Query editor
WITH pool_info AS (SELECT pool,token0,token1FROM prjx_hyperevm.uniswapv3factory_evt_poolcreatedORDER BY evt_block_time DESC),dex_trades AS (SELECT DATE_TRUNC('day', block_time) AS "date",project_contract_address AS pool_address,amount_usd AS volume_usdFROM dex.tradesWHERE 1=1AND blockchain = 'hyperevm'AND project = 'prjx'),pool_volume AS(SELECT "date",p.pool,p.token0,p.token1,SUM(COALESCE(volume_usd, 0)) AS pool_daily_volumeFROM dex_trades tLEFT JOIN pool_info p ON p.pool = t.pool_addressGROUP BY 1,2,3,4ORDER BY 1 DESC, pool_daily_volume DESC)SELECT "date",t0.symbol || '/' || t1.symbol AS ticker,get_href('https://hyperevmscan.io/address/' || CAST(p.pool AS VARCHAR), t0.symbol || '/' || t1.symbol) AS pool,p.pool AS pool_address,p.pool_daily_volume,SUM(p.pool_daily_volume) OVER (PARTITION BY p.pool) AS pool_cumulative_volume,SUM(p.pool_daily_volume) OVER (PARTITION BY "date") AS daily_cumulative_volume,SUM(p.pool_daily_volume) OVER (ORDER BY "date") AS cumulative_volumeFROM pool_volume 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'ORDER BY 1 DESC, p.pool_daily_volume DESC