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