Query editor
SELECTDATE_TRUNC('{{interval}}', evt_block_time) AS evt_date,chain,SUM(swapVol /CASEWHEN chain = 'bnb' THEN 1e18ELSE 1e6END) AS swapVol_sumFROM woofi_multichain.wooppv2_evt_wooswapWHEREevt_block_time >=CASEWHEN '{{interval}}' = 'day' THEN DATE_TRUNC('day', CURRENT_DATE) - INTERVAL '1' monthWHEN '{{interval}}' = 'week' THEN DATE_TRUNC('day', CURRENT_DATE) - INTERVAL '4' monthWHEN '{{interval}}' = 'month' THEN DATE_TRUNC('day', CURRENT_DATE) - INTERVAL '1' yearEND GROUP BYDATE_TRUNC('{{interval}}', evt_block_time),chain