Query editor
SELECTSUM(w.swapFee /CASEWHEN chain = 'bnb' THEN 1e18ELSE 1e6END) AS swapFee_sumFROM woofi_multichain.wooppv2_evt_wooswap AS wWHEREw.evt_block_time >= CURRENT_TIMESTAMP - INTERVAL '7' day
Query editor
1SELECT2SUM(w.swapFee /3CASE4WHEN chain = 'bnb' THEN 1e185ELSE 1e66END7) AS swapFee_sum8FROM woofi_multichain.wooppv2_evt_wooswap AS w9WHERE10w.evt_block_time >= CURRENT_TIMESTAMP - INTERVAL '7' day11