Query editor
SELECTSUM(CASE WHEN block_date = CURRENT_DATE - INTERVAL '1' day THEN amount_usd * fee / 1e6 END) AS fee_usd_1d,SUM(CASE WHEN block_date = CURRENT_DATE - INTERVAL '1' day THEN amount_usd * fee / 1e6 * 0.86 END) AS LPers_fee_usd_1d,SUM(CASE WHEN block_date >= CURRENT_DATE - INTERVAL '7' day THEN amount_usd * fee / 1e6 END) AS fee_usd_7d,SUM(CASE WHEN block_date >= CURRENT_DATE - INTERVAL '7' day THEN amount_usd * fee / 1e6 * 0.86 END) AS LPers_fee_usd_7d,SUM(CASE WHEN block_date >= CURRENT_DATE - INTERVAL '30' day THEN amount_usd * fee / 1e6 END) AS fee_usd_30d,SUM(CASE WHEN block_date >= CURRENT_DATE - INTERVAL '30' day THEN amount_usd * fee / 1e6 * 0.86 END) AS LPers_fee_usd_30d,SUM(amount_usd * fee / 1e6) AS total_fee_usd_all_time,SUM(amount_usd * fee / 1e6 * 0.86) AS total_LPers_fee_usd_all_timeFROM dex.trades tLEFT JOIN prjx_hyperevm.uniswapv3factory_evt_poolcreated pON t.project_contract_address = poolWHEREt.blockchain = 'hyperevm'AND t.project = 'prjx'AND t.block_date > date '2025-07-08'AND t.block_date < CURRENT_DATE